app_perform_element_response

0 rows


Description

Contains a single response to a single performance activity element

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_perform_element_response_id_seq'::regclass)
app_perform_element_response_snapshot.response_id Defined in XML R
section_element_id int8 19 null
app_perform_section_element.id Defined in XML R
participant_instance_id int8 19 null
app_perform_participant_instance.id Defined in XML R
response_data text 2147483647 √ null
created_at int8 19 null
updated_at int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
app_perfelemresp_id_pk Primary key Asc id
app_perfelemresp_par_ix Performance Asc participant_instance_id
app_perfelemresp_sec_ix Performance Asc section_element_id
app_perfelemresp_secpar_uix Must be unique Asc/Asc section_element_id + participant_instance_id

Relationships

Close relationships within degrees of separation