Table oc312.public.dn_item_data_map 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 int4 10  √  null
item_data.item_data_id dn_itm_data_map_itm_data_id_fk R
discrepancy_note_id int4 10  √  null
discrepancy_note.discrepancy_note_id dn_item_data_map_dn_id_fkey R
column_name varchar 255  √  null
study_subject_id int4 10  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
discrepancy_note_id Performance Asc i_dn_item_data_map_discrepancy_note_id
item_data_id Performance Asc i_dn_item_data_map_item_data_id

Close relationships  within of separation: