Auth Connect User Collections Table Schema (auth_connect_user_collections)


List of cohorts synced from server

auth_connect_user_collections table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
serverid BIGINT 19 null authconnusercoll_ser2_fk R
collectiontype VARCHAR 30

cohort, course

collectionid BIGINT 19 null

server id of cohort, course

cohortid BIGINT 19 null authconnusercoll_coh2_fk R
timecreated BIGINT 19 null

Table contained -1 rows

auth_connect_user_collections table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
authconnusercoll_coh_ix Performance Asc cohortid
authconnusercoll_ser_ix Performance Asc serverid
authconnusercoll_sercolcol_uix Must be unique Asc/Asc/Asc serverid + collectiontype + collectionid

auth_connect_user_collections table relationships