template_element

139 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('template_element_id_seq'::regclass)
application_response.template_element_id application_response_template_element_id_fkeyR
review_question_assignment.template_element_id review_question_assignment_template_element_id_fkeyR
review_response.template_element_id review_response_template_element_id_fkeyR
section_id int4 10 √ null
template_section.id template_element_section_id_fkeyR
code varchar 2147483647 null
element_type_plugin.code Implied ConstraintR
index int4 10 √ null
title varchar 2147483647 √ null
category template_element_category 2147483647 √ null
element_type_plugin_code varchar 2147483647 √ null
element_type_plugin.code Implied ConstraintR
visibility_condition jsonb 2147483647 √ 'true'::jsonb
is_required jsonb 2147483647 √ 'true'::jsonb
is_editable jsonb 2147483647 √ 'true'::jsonb
validation jsonb 2147483647 √ 'true'::jsonb
default_value jsonb 2147483647 √ null
validation_message varchar 2147483647 √ null
help_text varchar 2147483647 √ null
parameters jsonb 2147483647 √ null
template_code varchar 2147483647 √ get_template_code(section_id)
element_type_plugin.code Implied ConstraintR
template_version int4 10 √ get_template_version(section_id)

Indexes

Constraint Name Type Sort Column(s)
template_element_pkey Primary key Asc id
template_element_template_code_code_template_version_key Must be unique Asc/Asc/Asc template_code + code + template_version

Relationships

Close relationships within degrees of separation