Table oc312.public.item_data 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_data_id serial 10  √  nextval('item_data_item_data_id_seq'::regclass)
dn_item_data_map.item_data_id dn_itm_data_map_itm_data_id_fk R
item_id int4 10
item.item_id fk_answer_reference_item R
event_crf_id int4 10  √  null
event_crf.event_crf_id fk_item_reference_subject R
status_id int4 10  √  null
status.status_id fk_item_dat_fk_item_d_status R
value varchar 4000  √  null
date_created date 13  √  null
date_updated date 13  √  null
owner_id int4 10  √  null
user_account.user_id fk_item_dat_fk_item_d_user_acc R
update_id int4 10  √  null
ordinal int4 10  √  null
old_status_id int4 10  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
item_data_id Primary key Asc pk_item_data
event_crf_id Performance Asc i_item_data_event_crf_id
item_id Performance Asc i_item_data_item_id
ordinal Performance Asc i_item_data_ordinal
status_id Performance Asc i_item_data_status_id
item_id + event_crf_id + ordinal Must be unique Asc/Asc/Asc pk_item_data_new

Close relationships  within of separation: