Table oc312.public.study_subject 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_subject_id serial 10  √  nextval('study_subject_study_subject_id_seq'::regclass)
dn_study_subject_map.study_subject_id dn_ssm_study_subject_id_fkey R
event_crf.study_subject_id fk_event_cr_reference_study_su R
study_event.study_subject_id fk_study_ev_reference_study_su R
subject_group_map.study_subject_id fk_subject__subject_g_study_su R
label varchar 30  √  null
secondary_label varchar 30  √  null
subject_id int4 10  √  null
subject.subject_id fk_study_reference_subject N
study_id int4 10  √  null
study.study_id fk_project__reference_study2 R
status_id int4 10  √  null
status.status_id fk_study_su_fk_study__status R
enrollment_date date 13  √  null
date_created date 13  √  null
date_updated date 13  √  null
owner_id int4 10  √  null
user_account.user_id fk_study_su_fk_study__user_acc R
update_id int4 10  √  null
oc_oid varchar 40

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
study_subject_id Primary key Asc pk_study_subject
label Performance Asc i_study_subject_label
oc_oid Performance Asc i_study_subject_oc_oid
status_id Performance Asc i_study_subject_status_id
oc_oid Must be unique Asc uniq_study_subject_oid

Close relationships  within of separation: