app_perform_element

0 rows


Description

An element used within a section of a performance activity

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('app_perform_element_id_seq'::regclass)
app_perform_element.parent Defined in XMLR
app_perform_element_linked_review_content_response.child_element_id Defined in XMLR
app_perform_section_element.element_id Defined in XMLR
app_perform_section_element_reference.referencing_element_id Defined in XMLR
context_id int8 19 null
parent int8 19 √ null
app_perform_element.id Defined in XMLR
plugin_name varchar 1024 ''::character varying
title varchar 1024 ''::character varying
identifier_id int8 19 √ null
app_perform_element_identifier.id Defined in XMLR
is_required int2 5 √ null
data text 2147483647 √ null
sort_order int8 19 √ null

Indexes

Constraint Name Type Sort Column(s)
app_perfelem_id_pk Primary key Asc id
app_perfelem_ide_ix Performance Asc identifier_id
app_perfelem_par_ix Performance Asc parent
app_perfelem_parsor_ix Performance Asc/Asc parent + sort_order

Relationships

Close relationships within degrees of separation