app_perform_subject_instance

0 rows


Description

Represents a single activity for one subject user

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_perform_subject_instance_id_seq'::regclass)
app_perform_manual_relation_selection_progress.subject_instance_id Defined in XMLR
app_perform_participant_instance.subject_instance_id Defined in XMLR
app_perform_subject_instance_manual_participant.subject_instance_id Defined in XMLR
app_perform_subject_static_instance.subject_instance_id Defined in XMLR
track_user_assignment_id int8 19 null
app_perform_track_user_assignment.id Defined in XMLR
subject_user_id int8 19 null
app_user.id Defined in XMLR
progress int2 5 0
availability int2 5 0
job_assignment_id int8 19 √ null
due_date int8 19 √ null
status int2 5 √ null
completed_at int8 19 √ null
created_at int8 19 null
updated_at int8 19 √ null
task_id varchar 32 √ null

Indexes

Constraint Name Type Sort Column(s)
app_perfsubjinst_id_pk Primary key Asc id
app_perfsubjinst_due_ix Performance Asc due_date
app_perfsubjinst_sub_ix Performance Asc subject_user_id
app_perfsubjinst_tas_ix Performance Asc task_id
app_perfsubjinst_tra_ix Performance Asc track_user_assignment_id

Relationships

Close relationships within degrees of separation