Table transmart.i2b2demodata.observation_fact
Table that stores all observations

 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 int4 10 Primary key. Refers to encounter_num in visit_dimension.
patient_num numeric 38
patient_dimension.patient_num Implied Constraint R
Primary key. Refers to patient_num in patient_dimension.
concept_cd varchar 50 Primary key. Refers to concept_cd in concept_dimension.
provider_id varchar 50 Primary key. Refers to provider_id in provider_dimension.
start_date timestamp 29,6 Primary key. Starting date-time of the observation. Default: 0001-01-01 00:00:00.
modifier_cd varchar 100 Primary key. Refers to modifier_cd in modifier_dimension. Default: @. Highdim values: [TRANSMART:HIGHDIM:GENE EXPRESSION, TRANSMART:HIGHDIM:RNASEQ_TRANSCRIPT], original variable: [TRANSMART:ORIGINAL_VARIABLE], sample type: [TNS:SMPL].
instance_num numeric 18 Primary key. Default: 1.
valtype_cd varchar 50  √  null T for string, N for numeric, B for raw text and D for date values.
tval_char varchar 255  √  null If valtype_cd is T, the observations text value. If valtype_cd is N, an i2b2 supported operator [E = Equals, NE = Not equal, L = Less than, LE = Less than or Equal to, G = Greater than, GE = Greater than or Equal to]
nval_num numeric 29,16  √  null Used in conjunction with valtype_cd = N to store a numerical value
valueflag_cd varchar 50  √  null
quantity_num numeric 18,5  √  null
units_cd varchar 50  √  null
end_date timestamp 29,6  √  null The end date-time of the observation
location_cd varchar 50  √  null
observation_blob text 2147483647  √  null
confidence_num numeric 18,5  √  null
update_date timestamp 29,6  √  null
download_date timestamp 29,6  √  null
import_date timestamp 29,6  √  null
sourcesystem_cd varchar 50  √  null Deprecated. Is currently being ignored.
upload_id numeric 38  √  null
upload_status.upload_id Implied Constraint R
sample_cd varchar 200  √  null
sample_dimension.sample_cd Implied Constraint R
Deprecated. Refers to the sample_dimension table.
trial_visit_num numeric 38  √  null
trial_visit_dimension.trial_visit_num observation_fact_trial_visit_fk R
Refers to the new trial_visit dimension. Is not part of the primary key to make the primary key of observation_fact identical with that used by i2b2.

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

Indexes:
Column(s) Type Sort Constraint Name
encounter_num + patient_num + concept_cd + provider_id + instance_num + modifier_cd + start_date Primary key Asc/Asc/Asc/Asc/Asc/Asc/Asc observation_fact_pkey
concept_cd Performance Asc idx_fact_concept
patient_num Performance Asc idx_fact_patient_num
trial_visit_num Performance Asc idx_fact_trial_visit_num
patient_num + concept_cd + trial_visit_num Performance Asc/Asc/Asc observation_fact_pct_idx
trial_visit_num + modifier_cd + concept_cd + encounter_num + patient_num + provider_id + instance_num + start_date Performance Asc/Asc/Asc/Asc/Asc/Asc/Asc/Asc observation_fact_tmceppis_idx

Close relationships  within of separation: