Table transmart.biomart.bio_patient Generated by
SchemaSpy
Legend: SourceForge.net
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
bio_patient_id int8 19
bio_patient_event.bio_patient_id bio_pt_event_bio_pt_fk R
bio_subject.bio_subject_id bio_patient_bio_subject_fk R
first_name varchar 200  √  null
last_name varchar 200  √  null
middle_name varchar 200  √  null
birth_date timestamp 29,6  √  null
birth_date_orig varchar 200  √  null
gender_code varchar 200  √  null
race_code varchar 200  √  null
ethnic_group_code varchar 200  √  null
address_zip_code varchar 200  √  null
country_code varchar 200  √  null
informed_consent_code varchar 200  √  null
bio_experiment_id int8 19  √  null
bio_clinical_trial.bio_experiment_id bio_patient_bio_clinical_trial R
bio_clinical_trial_p_group_id int8 19  √  null
bio_clinc_trial_pt_group.bio_clinical_trial_p_group_id bio_patient_bio_clinic_tri_fk R

Table contained 0 rows at Wed Jun 26 00:10 CEST 2019

Indexes:
Column(s) Type Sort Constraint Name
bio_patient_id Primary key Asc bio_patient_pk

Close relationships  within of separation: