app_prog_user_assignment

0 rows


Description

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

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 nextval('app_prog_user_assignment_id_seq'::regclass)
programid int8 19 0
userid int8 19 0
assignmentid int8 19 0
timeassigned int8 19 0
exceptionstatus int8 19 0

Indexes

Constraint Name Type Sort Column(s)
app_proguserassi_id_pk Primary key Asc id
app_proguserassi_ass_ix Performance Asc assignmentid
app_proguserassi_exc_ix Performance Asc exceptionstatus
app_proguserassi_pro_ix Performance Asc programid
app_proguserassi_prouseass_uix Must be unique Asc/Asc/Asc programid + userid + assignmentid
app_proguserassi_use_ix Performance Asc userid

Relationships