Table transmart.i2b2demodata.visit_dimension
Table holds descriptions of actual visits in real time.

 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_num serial 10  √  nextval('i2b2demodata.visit_dimension_encounter_num_seq'::regclass)
encounter_mapping.encounter_num encounter_mapping_encounter_num_fk R
Primary key. Id of the visit. Referred to by the encounter_num column of observation_fact.
patient_num numeric 38
patient_dimension.patient_num visit_dimension_patient_num_fk R
Foreign key. Id linking to patient_num in the patient_dimension.
active_status_cd varchar 50  √  null
start_date timestamp 29,6  √  null Start date and time of the visit.
end_date timestamp 29,6  √  null End date and time of the visit.
inout_cd varchar 50  √  null
location_cd varchar 50  √  null
location_path varchar 900  √  null
length_of_stay numeric 38  √  null
visit_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 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_num Primary key Asc visit_dimension_pk
upload_id Performance Asc vd_uploadid_idx
encounter_num + patient_num + location_path + inout_cd + start_date + end_date + length_of_stay Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc visitdim_en_pn_lp_io_sd_idx
start_date + end_date Performance Asc/Asc visitdim_std_edd_idx

Close relationships  within of separation: