Table oc312.public.decision_condition 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
decision_condition_id serial 10  √  nextval('decision_condition_decision_condition_id_seq'::regclass)
dc_event.decision_condition_id fk_dc_event_fk_dc_eve_decision R
dc_primitive.decision_condition_id fk_dc_primi_fk_dc_pri_decision R
crf_version_id int4 10  √  null
crf_version.crf_version_id fk_decision_fk_decisi_crf_vers R
status_id int4 10  √  null
status.status_id fk_decision_fk_decisi_status R
label varchar 1000
comments varchar 3000
quantity int4 10
type varchar 3
owner_id int4 10  √  null
user_account.user_id fk_decision_fk_decisi_user_acc R
date_created date 13  √  null
date_updated date 13  √  null
update_id int4 10  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
decision_condition_id Primary key Asc pk_decision_condition
crf_version_id Performance Asc i_decision_condition_crf_version_id
status_id Performance Asc i_decision_condition_status_id

Close relationships  within of separation: