Table oc312.public.event_definition_crf 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
event_definition_crf_id serial 10  √  nextval('event_definition_crf_event_definition_crf_id_seq'::regclass)
dataset_crf_version_map.event_definition_crf_id fk_dataset__ref_event_event_de R
study_event_definition_id int4 10  √  null
study_event_definition.study_event_definition_id fk_event_de_reference_study_ev R
study_id int4 10  √  null
study.study_id fk_study_reference_instrument R
crf_id int4 10  √  null
crf.crf_id fk_study_inst_reference R
required_crf bool 1  √  null
double_entry bool 1  √  null
require_all_text_filled bool 1  √  null
decision_conditions bool 1  √  null
null_values varchar 255  √  null
default_version_id int4 10  √  null
crf_version.crf_version_id fk_versioning_study_inst N
status_id int4 10  √  null
status.status_id fk_event_de_fk_study__status R
owner_id int4 10  √  null
user_account.user_id fk_event_de_study_crf_user_acc R
date_created date 13  √  null
date_updated date 13  √  null
update_id int4 10  √  null
ordinal int4 10  √  null
electronic_signature bool 1  √  false
hide_crf bool 1  √  false
source_data_verification_code int4 10  √  null
selected_version_ids varchar 150  √  null
parent_id int4 10  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
event_definition_crf_id Primary key Asc pk_event_definition_crf
crf_id Performance Asc i_event_definition_crf_crf_id
default_version_id Performance Asc i_event_definition_crf_default_version_id
electronic_signature Performance Asc i_event_definition_crf_electronic_signature
ordinal Performance Asc i_event_definition_crf_ordinal
status_id Performance Asc i_event_definition_crf_status_id
study_id Performance Asc i_event_definition_crf_study_id

Close relationships  within of separation: