Table oc312.public.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
subject_id serial 10  √  nextval('subject_subject_id_seq'::regclass)
dn_subject_map.subject_id dn_subject_map_subject_id_fkey R
study_subject.subject_id fk_study_reference_subject N
subject.father_id has_father N
subject.mother_id has_mother N
father_id int4 10  √  null
subject.subject_id has_father N
mother_id int4 10  √  null
subject.subject_id has_mother N
status_id int4 10  √  null
status.status_id fk_subject_fk_subjec_status R
date_of_birth date 13  √  null
gender bpchar 1  √  null
unique_identifier varchar 255  √  null
date_created date 13  √  null
owner_id int4 10  √  null
user_account.user_id fk_subject_fk_subjec_user_acc R
date_updated date 13  √  null
update_id int4 10  √  null
dob_collected bool 1  √  null

Analyzed at za okt 20 16:34 CEST 2012

Indexes:
Column(s) Type Sort Constraint Name
subject_id Primary key Asc pk_subject
date_created Performance Asc i_subject_date_created
date_of_birth Performance Asc i_subject_date_of_birth
gender Performance Asc i_subject_gender
unique_identifier Performance Asc i_subject_unique_identifier

Close relationships  within of separation: