Table oc312.public.study_event 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
study_event_id serial 10  √  nextval('study_event_study_event_id_seq'::regclass)
dn_study_event_map.study_event_id dn_sem_study_event_id_fkey R
event_crf.study_event_id fk_event_cr_fk_event__study_ev R
study_event_definition_id int4 10  √  null
study_event_definition.study_event_definition_id fk_study_ev_fk_study__study_ev R
study_subject_id int4 10  √  null
study_subject.study_subject_id fk_study_ev_reference_study_su R
location varchar 2000  √  null
sample_ordinal int4 10  √  null
date_start timestamptz 35,6  √  null
date_end timestamptz 35,6  √  null
owner_id int4 10  √  null
user_account.user_id fk_study_ev_fk_study__user_acc R
status_id int4 10  √  null
status.status_id fk_study_ev_fk_study__status R
date_created date 13  √  null
date_updated date 13  √  null
update_id int4 10  √  null
subject_event_status_id int4 10  √  null
start_time_flag bool 1  √  null
end_time_flag bool 1  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
study_event_id Primary key Asc pk_study_event
date_end Performance Asc i_study_event_date_end
date_start Performance Asc i_study_event_date_start
sample_ordinal Performance Asc i_study_event_sample_ordinal
status_id Performance Asc i_study_event_status_id
subject_event_status_id Performance Asc i_study_event_subject_event_status_id

Close relationships  within of separation: