Table transmart.i2b2metadata.i2b2_secure
The same as i2b2, but with an added security token.

 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  √  null Number that represents the depth of the node. 0 for root.
c_fullname varchar 900 Full path to the node. E.g., \Vital Signs\Heart Rate\.
c_name varchar 2000  √  null Name of the node. E.g., Heart Rate.
c_synonym_cd bpchar 1  √  null
c_visualattributes bpchar 3  √  null 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 450  √  null Code that represents node. E.g., VSIGN:HR. Not used.
c_metadataxml text 2147483647  √  null Metadata encoded as XML.
c_facttablecolumn varchar 50  √  null Column of observation_fact corresponding with c_columnname.
c_tablename varchar 150  √  null Table of the dimension referred to by this node.
c_columnname varchar 50  √  null Column of the table of the dimension referred to by this node
c_columndatatype varchar 50  √  null
c_operator varchar 10  √  null Operator. E.g., like, =
c_dimcode varchar 900  √  null 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  √  null
update_date timestamp 29,6  √  null
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 900  √  null
c_symbol varchar 50  √  null
i2b2_id numeric 18  √  null
secure_obj_token varchar 50  √  null Token encoding access the node. Refers to bio_data_unique_id in searchapp.search_secure_object. E.g., PUBLIC or EXP:SCSCP.

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

Indexes:
Column(s) Type Sort Constraint Name
c_fullname Performance Asc idx_i2b2_secure_fullname