0 rows


Mapping of users to cohort role assignments.


Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
cohortid BIGINT 19 null tool_cohortroles_erd_cohortR

The cohort to sync

roleid BIGINT 19 null Implied ConstraintR

The role to assign

userid BIGINT 19 null

The user to sync

timecreated BIGINT 19 null

The time this record was created

timemodified BIGINT 19 null

The time this record was modified.

usermodified BIGINT 19 null

Who last modified this record?


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
toolcoho_cohroluse2_uix Must be unique Asc/Asc/Asc cohortid + roleid + userid