Prog Future User Assignment Table Schema (prog_future_user_assignment)


Description

Future user assignments such as from first login

prog_future_user_assignment table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
programid BIGINT 19 √ null
prog.id Implied Constraint R
userid BIGINT 19 √ null
user.id Implied Constraint R
assignmentid BIGINT 19 √ null

Table contained -1 rows

prog_future_user_assignment table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
progfutuuserassi_ass_ix Performance Asc assignmentid
progfutuuserassi_pro_ix Performance Asc programid
progfutuuserassi_prouseass_uix Must be unique Asc/Asc/Asc programid + userid + assignmentid
progfutuuserassi_use_ix Performance Asc userid

prog_future_user_assignment table relationships

Close relationships within degrees of separation