tool_cohortroles

0 rows


Description

Mapping of users to cohort role assignments.

Columns

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

The cohort to sync

roleid BIGINT 19 null
role.id 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?

Indexes

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

Relationships