app_engage_resource_completion

0 rows


Description

Table that holds the completion record of a user for a particular resource

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_engage_resource_completion_id_seq'::regclass)
resourceid int8 19 null
userid int8 19 null
app_user.id Defined in XMLR
timecreated int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_engaresocomp_id_pk Primary key Asc id
app_engaresocomp_resuse_uix Must be unique Asc/Asc resourceid + userid
app_engaresocomp_tim_ix Performance Asc timecreated
app_engaresocomp_use_ix Performance Asc userid

Relationships