Table oc312.public.dc_primitive 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_primitive_id serial 10  √  nextval('dc_primitive_dc_primitive_id_seq'::regclass)
decision_condition_id int4 10  √  null
decision_condition.decision_condition_id fk_dc_primi_fk_dc_pri_decision R
item_id int4 10  √  null
item.item_id fk_dc_primi_fk_item_i_item R
dynamic_value_item_id int4 10  √  null
item.item_id fk_dc_primi_fk_dc_pri_item R
comparison varchar 3
constant_value varchar 4000  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
dc_primitive_id Primary key Asc pk_dc_primitive
decision_condition_id Performance Asc i_dc_primitive_decision_condition_id
dynamic_value_item_id Performance Asc i_dc_primitive_dynamic_value_item_id
item_id Performance Asc i_dc_primitive_item_id

Close relationships  within of separation: