app_role_sortorder

0 rows


Description

sort order of course managers in a course

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_role_sortorder_id_seq'::regclass)
userid int8 19 null
app_user.id Defined in XMLR
roleid int8 19 null
app_role.id Defined in XMLR
contextid int8 19 null
app_context.id Defined in XMLR
sortoder int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_rolesort_id_pk Primary key Asc id
app_rolesort_con_ix Performance Asc contextid
app_rolesort_rol_ix Performance Asc roleid
app_rolesort_use_ix Performance Asc userid
app_rolesort_userolcon_uix Must be unique Asc/Asc/Asc userid + roleid + contextid

Relationships