app_auth_connect_user_collections

0 rows


Description

List of cohorts synced from server

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_auth_connect_user_collections_id_seq'::regclass)
serverid int8 19 null
app_auth_connect_servers.id Defined in XMLR
collectiontype varchar 30 ''::character varying
collectionid int8 19 null
cohortid int8 19 null
app_cohort.id Defined in XMLR
timecreated int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_authconnusercoll_id_pk Primary key Asc id
app_authconnusercoll_coh_ix Performance Asc cohortid
app_authconnusercoll_ser_ix Performance Asc serverid
app_authconnusercoll_serco_uix Must be unique Asc/Asc/Asc serverid + collectiontype + collectionid

Relationships