Table transmart.i2b2metadata.custom_meta 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 int8 19
c_fullname varchar 700
c_name varchar 2000
c_synonym_cd bpchar 1
c_visualattributes bpchar 3
c_totalnum int8 19  √  null
c_basecode varchar 50  √  null
c_metadataxml text 2147483647  √  null
c_facttablecolumn varchar 50
c_tablename varchar 50
c_columnname varchar 50
c_columndatatype varchar 50
c_operator varchar 10
c_dimcode varchar 900
c_comment text 2147483647  √  null
c_tooltip varchar 900  √  null
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_applied_path varchar 700
m_exclusion_cd varchar 25  √  null
c_path varchar 700  √  null
c_symbol varchar 50  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
m_applied_path Performance Asc meta_applied_path_custom_idx
c_fullname Performance Asc meta_fullname_custom_idx