Table oc312.public.study_module_status 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('study_module_status_id_seq'::regclass)
audit_user_login.id Implied Constraint R
authorities.id Implied Constraint R
configuration.id Implied Constraint R
dyn_item_form_metadata.id Implied Constraint R
dyn_item_group_metadata.id Implied Constraint R
measurement_unit.id Implied Constraint R
openclinica_version.id Implied Constraint R
rule.id Implied Constraint R
rule_action.id Implied Constraint R
rule_action_property.id Implied Constraint R
rule_action_run.id Implied Constraint R
rule_action_run_log.id Implied Constraint R
rule_expression.id Implied Constraint R
rule_set.id Implied Constraint R
rule_set_audit.id Implied Constraint R
rule_set_rule.id Implied Constraint R
rule_set_rule_audit.id Implied Constraint R
scd_item_metadata.id Implied Constraint R
usage_statistics_data.id Implied Constraint R
study_id int4 10  √  null
study.study_id fk_study_module_study_id R
study int4 10  √  1
crf int4 10  √  1
event_definition int4 10  √  1
subject_group int4 10  √  1
rule int4 10  √  1
site int4 10  √  1
users int4 10  √  1
version int4 10  √  null
date_created date 13  √  null
date_updated date 13  √  null
owner_id int4 10  √  null
update_id int4 10  √  null
status_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_study_module_status

Close relationships  within of separation: