Table oc312.public.item_form_metadata Generated by
SchemaSpy
Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
item_form_metadata_id serial 10  √  nextval('item_form_metadata_item_form_metadata_id_seq'::regclass)
scd_item_metadata.control_item_form_metadata_id scd_meta_fk_control_meta_id R
scd_item_metadata.scd_item_form_metadata_id scd_meta_fk_scd_form_meta_id R
item_id int4 10
item.item_id fk_item_id R
crf_version_id int4 10  √  null
header varchar 2000  √  null
subheader varchar 240  √  null
parent_id int4 10  √  null
parent_label varchar 120  √  null
column_number int4 10  √  null
page_number_label varchar 5  √  null
question_number_label varchar 20  √  null
left_item_text varchar 4000  √  null
right_item_text varchar 2000  √  null
section_id int4 10
section.section_id fk_sec_id R
decision_condition_id int4 10  √  null
response_set_id int4 10
response_set.response_set_id fk_rs_id R
regexp varchar 1000  √  null
regexp_error_msg varchar 255  √  null
ordinal int4 10
required bool 1  √  null
default_value varchar 4000  √  null
response_layout varchar 255  √  null
width_decimal varchar 10  √  null
show_item bool 1  √  true

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
item_form_metadata_id Primary key Asc pk_item_form_metadata
decision_condition_id Performance Asc i_item_form_metadata_decision_condition_id
ordinal Performance Asc i_item_form_metadata_ordinal
parent_id Performance Asc i_item_form_metadata_parent_id
crf_version_id Performance Asc i_itm_form_metadata_crf_ver_id

Close relationships  within of separation: