Table transmart.i2b2demodata.encounter_mapping 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
encounter_ide varchar 200
encounter_ide_source varchar 50
encounter_num int4 10
visit_dimension.encounter_num encounter_mapping_encounter_num_fk R
patient_ide varchar 200  √  null
patient_ide_source varchar 50  √  null
encounter_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
encounter_ide + encounter_ide_source Primary key Asc/Asc encounter_mapping_pk
encounter_num Performance Asc em_encnum_idx
encounter_ide + encounter_ide_source + patient_ide + patient_ide_source + encounter_num Performance Asc/Asc/Asc/Asc/Asc em_idx_encpath
upload_id Performance Asc em_uploadid_idx

Close relationships  within of separation: