Table transmart.i2b2demodata.modifier_dimension
Table holds the modifiers on an observation. Used to link to highdim data and samples as well.

 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
modifier_path varchar 700
modifier_dimension_view.modifier_path Implied Constraint R
Primary key. The path that uniquely identifies a modifier.
modifier_cd varchar 50  √  null The code that is used to refer to the modifier from obervation_fact. However, it is nullable.
name_char varchar 2000  √  null The name of the modifier.
modifier_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 int8 19  √  null
modifier_level int8 19  √  null
modifier_node_type varchar 10  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
modifier_path Primary key Asc modifier_dimension_pk
upload_id Performance Asc md_idx_uploadid

Close relationships: