app_perform_subject_instance_manual_participant

0 rows


Description

Manually selected participants for each subject instance

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_perform_subject_instance_manual_participant_id_seq'::regclass)
subject_instance_id int8 19 null
app_perform_subject_instance.id Defined in XMLR
core_relationship_id int8 19 null
app_totara_core_relationship.id Defined in XMLR
user_id int8 19 √ null
app_user.id Defined in XMLR
name varchar 255 √ null
email varchar 100 √ null
created_at int8 19 null
created_by int8 19 null
app_user.id Defined in XMLR

Indexes

Constraint Name Type Sort Column(s)
app_perfsubjinstmanupart_id_pk Primary key Asc id
app_perfsubjinstmanupart_co_ix Performance Asc core_relationship_id
app_perfsubjinstmanupart_cr_ix Performance Asc created_by
app_perfsubjinstmanupart_su_ix Performance Asc subject_instance_id
app_perfsubjinstmanupart_us_ix Performance Asc user_id

Relationships

Close relationships within degrees of separation