Auth Connect User Collections Table Schema (auth_connect_user_collections)


Description

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
auth_connect_servers.id authconnusercoll_ser2_fk R
collectiontype VARCHAR 30

cohort, course
collectionid BIGINT 19 null

server id of cohort, course
cohortid BIGINT 19 null
cohort.id 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

Close relationships within degrees of separation