Table oc312.public.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
status_id serial 10  √  nextval('status_status_id_seq'::regclass)
completion_status.status_id fk_completi_fk_comple_status R
crf.status_id fk_crf_fk_crf_fk_status R
crf_version.status_id fk_crf_vers_fk_crf_ve_status R
dataset.status_id fk_dataset_fk_datase_status R
decision_condition.status_id fk_decision_fk_decisi_status R
event_crf.status_id fk_event_cr_fk_event__status R
event_definition_crf.status_id fk_event_de_fk_study__status R
filter.status_id fk_filter_fk_query__status R
item.status_id fk_item_fk_item_s_status R
item_data.status_id fk_item_dat_fk_item_d_status R
item_group.status_id fk_item_gro_fk_item_g_status R
section.status_id fk_section_fk_sectio_status R
study.old_status_id fk_old_status_id R
study.status_id fk_study_fk_study__status R
study_event.status_id fk_study_ev_fk_study__status R
study_event_definition.status_id fk_study_ev_fk_studye_status R
study_group_class.status_id fk_study_gr_fk_study__status R
study_subject.status_id fk_study_su_fk_study__status R
study_user_role.status_id fk_study_us_fk_study__status R
subject.status_id fk_subject_fk_subjec_status R
subject_group_map.status_id fk_subject__fk_subjec_status R
user_account.status_id fk_user_acc_status_re_status R
name varchar 255  √  null
description varchar 1000  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
status_id Primary key Asc pk_status

Close relationships  within of separation: