Table transmart.i2b2demodata.patient_dimension
Table holds patients.

 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
patient_num numeric 38
archive_observation_fact.patient_num Implied Constraint R
observation_fact.patient_num Implied Constraint R
patient_mapping.patient_num Implied Constraint R
relation.left_subject_id left_subject_id_fk R
relation.right_subject_id right_subject_id_fk R
visit_dimension.patient_num visit_dimension_patient_num_fk R
Primary key. Id of the patient.
vital_status_cd varchar 50  √  null
birth_date timestamp 29,6  √  null
death_date timestamp 29,6  √  null
sex_cd varchar 50  √  null One of [Male, Female, Unknown].
age_in_years_num numeric 38  √  null
language_cd varchar 50  √  null
race_cd varchar 50  √  null
marital_status_cd varchar 50  √  null
religion_cd varchar 50  √  null
zip_cd varchar 50  √  null
statecityzip_path varchar 700  √  null
income_cd varchar 50  √  null
patient_blob text 2147483647  √  null
update_date timestamp 29,6  √  null
download_date timestamp 29,6  √  null
import_date timestamp 29,6  √  null
sourcesystem_cd varchar 107  √  null
upload_id numeric 38  √  null
upload_status.upload_id Implied Constraint R

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

Indexes:
Column(s) Type Sort Constraint Name
patient_num Primary key Asc patient_dimension_pk

Close relationships  within of separation: