Table oc312.public.dc_computed_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_summary_event_id serial 10  √  nextval('dc_computed_event_dc_summary_event_id_seq'::regclass)
dc_summary_item_map.dc_summary_event_id fk_dc_summa_fk_dc_sum_dc_compu R
dc_event_id int4 10
dc_event.dc_event_id fk_dc_compu_fk_dc_com_dc_event R
item_target_id int4 10  √  null
summary_type varchar 255  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
dc_summary_event_id Primary key Asc pk_dc_computed_event
dc_event_id Performance Asc i_dc_computed_event_dc_event_id
item_target_id Performance Asc i_dc_computed_event_item_target_id

Close relationships  within of separation: