Prog User Assignment Table Schema (prog_user_assignment)


Description

Stores details of the user assignments that have been made for a program based on the program's assignment criteria

prog_user_assignment table columns

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

Table contained -1 rows

prog_user_assignment table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
proguserassi_ass_ix Performance Asc assignmentid
proguserassi_exc_ix Performance Asc exceptionstatus
proguserassi_pro_ix Performance Asc programid
proguserassi_prouseass_uix Must be unique Asc/Asc/Asc programid + userid + assignmentid
proguserassi_use_ix Performance Asc userid

prog_user_assignment table relationships

Close relationships within degrees of separation