Table oc312.public.event_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_crf_id serial 10  √  nextval('event_crf_event_crf_id_seq'::regclass)
dn_event_crf_map.event_crf_id dn_evnt_crf_map_evnt_crf_id_fk R
item_data.event_crf_id fk_item_reference_subject R
study_event_id int4 10  √  null
study_event.study_event_id fk_event_cr_fk_event__study_ev R
crf_version_id int4 10  √  null
crf_version.crf_version_id fk_subject_referenc_instrument R
date_interviewed date 13  √  null
interviewer_name varchar 255  √  null
completion_status_id int4 10  √  null
completion_status.completion_status_id fk_event_cr_fk_event__completi R
status_id int4 10  √  null
status.status_id fk_event_cr_fk_event__status R
annotations varchar 4000  √  null
date_completed timestamptz 35,6  √  null
validator_id int4 10  √  null
date_validate date 13  √  null
date_validate_completed timestamptz 35,6  √  null
validator_annotations varchar 4000  √  null
validate_string varchar 256  √  null
owner_id int4 10  √  null
user_account.user_id fk_event_cr_fk_event__user_acc R
date_created date 13  √  null
study_subject_id int4 10  √  null
study_subject.study_subject_id fk_event_cr_reference_study_su R
date_updated date 13  √  null
update_id int4 10  √  null
electronic_signature_status bool 1  √  false
sdv_status bool 1 false
old_status_id int4 10  √  1
sdv_update_id int4 10  √  0

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
event_crf_id Primary key Asc pk_event_crf
completion_status_id Performance Asc i_event_crf_completion_status_id
date_interviewed Performance Asc i_event_crf_date_interviewed
interviewer_name Performance Asc i_event_crf_interviewer_name
owner_id Performance Asc i_event_crf_owner_id
status_id Performance Asc i_event_crf_status_id
study_subject_id Performance Asc i_event_crf_study_subject_id
validator_id Performance Asc i_event_crf_validator_id

Close relationships  within of separation: