Table oc312.public.item_group_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_group_metadata_id serial 10  √  nextval('item_group_metadata_item_group_metadata_id_seq'::regclass)
item_group_id int4 10
item_group.item_group_id fk_item_group R
header varchar 255  √  null
subheader varchar 255  √  null
layout varchar 100  √  null
repeat_number int4 10  √  null
repeat_max int4 10  √  null
repeat_array varchar 255  √  null
row_start_number int4 10  √  null
crf_version_id int4 10
crf_version.crf_version_id fk_crf_metadata R
item_id int4 10
item.item_id fk_item R
ordinal int4 10
borders int4 10  √  null
show_group bool 1  √  true
repeating_group bool 1 true

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
item_group_metadata_id Primary key Asc pk_item_group_metadata
crf_version_id Performance Asc i_item_group_metadata_crf_version_id
item_group_id Performance Asc i_item_group_metadata_item_group_id
item_id Performance Asc i_item_group_metadata_item_id

Close relationships  within of separation: