Table transmart.i2b2demodata.patient_mapping
Table with subject identifiers from different sources.

 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_ide varchar 200 Primary key. Subject identifier associated with a patient.
patient_ide_source varchar 50 Primary key. Source of the subject identifier.
patient_num numeric 38
patient_dimension.patient_num Implied Constraint R
The id of the patient in TranSMART. Refers to patient_num in patient_dimension.
patient_ide_status varchar 50  √  null
upload_date timestamp 29,6  √  null
update_date timestamp 29,6  √  null
download_date timestamp 29,6  √  null
import_date timestamp 29,6  √  null
sourcesystem_cd varchar 50  √  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_ide + patient_ide_source Primary key Asc/Asc patient_mapping_pk
patient_num Performance Asc pm_patnum_idx

Close relationships: