app_perform_track_user_assignment

0 rows


Description

Individual track assignments for real users

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_perform_track_user_assignment_id_seq'::regclass)
app_perform_subject_instance.track_user_assignment_id Defined in XMLR
app_perform_track_user_assignment_via.track_user_assignment_id Defined in XMLR
track_id int8 19 null
app_perform_track.id Defined in XMLR
subject_user_id int8 19 null
app_user.id Defined in XMLR
period_start_date int8 19 √ null
period_end_date int8 19 √ null
deleted int2 5 null
job_assignment_id int8 19 √ null
created_at int8 19 null
updated_at int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
app_perftracuserassi_id_pk Primary key Asc id
app_perftracuserassi_sub_ix Performance Asc subject_user_id
app_perftracuserassi_tra_ix Performance Asc track_id
app_perftracuserassi_trasub_ix Performance Asc/Asc track_id + subject_user_id

Relationships

Close relationships within degrees of separation