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 Implied ConstraintR

The cohort to sync

roleid BIGINT 19 null
role.id Implied ConstraintR

The role to assign

userid BIGINT 19 null
user.id Implied ConstraintR

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_cohroluse2_uix Must be unique Asc/Asc/Asc cohortid + roleid + userid

Relationships