Table oc312.public.dc_substitution_event 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
dc_event_id serial 10  √  nextval('dc_substitution_event_dc_event_id_seq'::regclass)
dc_event.dc_event_id fk_dc_subst_fk_dc_sub_dc_event R
item_id int4 10  √  null
item.item_id fk_dc_subst_fk_dc_sub_item R
value varchar 1000

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
dc_event_id Primary key Asc pk_dc_substitution_event
item_id Performance Asc i_dc_substitution_event_item_id

Close relationships  within of separation: