app_cohort_role

0 rows


Description

A table to store roles assigned to a cohort

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_cohort_role_id_seq'::regclass)
cohortid int8 19 0
app_cohort.id Defined in XMLR
roleid int8 19 0
app_role.id Defined in XMLR
contextid int8 19 0
timemodified int8 19 null
timecreated int8 19 null
usermodified int8 19 null
app_user.id Defined in XMLR

Indexes

Constraint Name Type Sort Column(s)
app_cohorole_id_pk Primary key Asc id
app_cohorole_coh_ix Performance Asc cohortid
app_cohorole_cohrolcon_uix Must be unique Asc/Asc/Asc cohortid + roleid + contextid
app_cohorole_rol_ix Performance Asc roleid
app_cohorole_use_ix Performance Asc usermodified

Relationships