Table oc312.public.rule_set 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
id serial 10  √  nextval('rule_set_id_seq'::regclass)
study_module_status.id Implied Constraint R
rule_expression_id int4 10
study_event_definition_id int4 10  √  null
crf_id int4 10  √  null
crf_version_id int4 10  √  null
study_id int4 10
owner_id int4 10  √  null
date_created date 13  √  null
date_updated date 13  √  null
update_id int4 10  √  null
status_id int4 10  √  null
version int4 10  √  null
item_id int4 10  √  null
item_group_id int4 10  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc pk_rule_set
crf_id Performance Asc i_rule_set_crf_id
crf_version_id Performance Asc i_rule_set_crf_version_id
rule_expression_id Performance Asc i_rule_set_rule_expression_id
status_id Performance Asc i_rule_set_status_id
study_event_definition_id Performance Asc i_rule_set_study_event_definition_id
study_id Performance Asc i_rule_set_study_id

Close relationships: