Table transmart.i2b2metadata.i2b2
DEPRECATED. Holds all nodes in the i2b2 tree. Redundant, as the same data is in i2b2_secure.

 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
c_hlevel numeric 22 Number that represents the depth of the node. 0 for root.
c_fullname varchar 700 Full path to the node. E.g., \Vital Signs\Heart Rate\.
c_name varchar 2000 Name of the node. E.g., Heart Rate.
c_synonym_cd bpchar 1
c_visualattributes bpchar 3 Visual attributes describing how a node should be displayed. Can have three characters at maximum. See OntologyTerm#VisualAttributes for documentation on the values.
c_totalnum numeric 22  √  null
c_basecode varchar 50  √  null Code that represents node. E.g., VSIGN:HR. Not used.
c_metadataxml text 2147483647  √  null Metadata encoded as XML.
c_facttablecolumn varchar 50 Column of observation_fact corresponding with c_columnname.
c_tablename varchar 150 Table of the dimension referred to by this node.
c_columnname varchar 50 Column of the table of the dimension referred to by this node
c_columndatatype varchar 50
c_operator varchar 10 Operator. E.g., like, =
c_dimcode varchar 700 Refers to a dimension element, linked to observations.
c_comment text 2147483647  √  null Meant for comments, not for storing study based security tokens.
c_tooltip varchar 900  √  null
m_applied_path varchar 700
update_date timestamp 29,6
download_date timestamp 29,6  √  null
import_date timestamp 29,6  √  null
sourcesystem_cd varchar 50  √  null
valuetype_cd varchar 50  √  null
m_exclusion_cd varchar 25  √  null
c_path varchar 700  √  null
c_symbol varchar 50  √  null
i2b2_id int8 19  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
c_comment Performance Asc i2b2_c_comment_char_length_idx
c_fullname + c_basecode Performance Asc/Asc idx_i2b2_fullname_basecode
sourcesystem_cd Performance Asc ix_i2b2_source_system_cd