app_perform_section_element

0 rows


Description

Table to connect a specific question to a specific performance activity section

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_perform_section_element_id_seq'::regclass)
app_perform_element_response.section_element_id Defined in XMLR
section_id int8 19 null
app_perform_section.id Defined in XMLR
element_id int8 19 null
app_perform_element.id Defined in XMLR
sort_order int8 19 null

Indexes

Constraint Name Type Sort Column(s)
app_perfsectelem_id_pk Primary key Asc id
app_perfsectelem_ele_ix Performance Asc element_id
app_perfsectelem_sec_ix Performance Asc section_id
app_perfsectelem_secsor_uix Must be unique Asc/Asc section_id + sort_order

Relationships

Close relationships within degrees of separation