Table transmart.i2b2metadata.table_access 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_table_cd varchar 65
c_table_name varchar 50
c_protected_access bpchar 1  √  null
c_hlevel numeric 22
c_fullname varchar 700
c_name varchar 2000
c_synonym_cd bpchar 1
c_visualattributes bpchar 3
c_totalnum numeric 22  √  null
c_basecode varchar 50  √  null
c_metadataxml text 2147483647  √  null
c_facttablecolumn varchar 50
c_dimtablename varchar 50
c_columnname varchar 50
c_columndatatype varchar 50
c_operator varchar 10
c_dimcode varchar 700
c_comment text 2147483647  √  null
c_tooltip varchar 900  √  null
c_entry_date timestamp 29,6  √  null
c_change_date timestamp 29,6  √  null
c_status_cd bpchar 1  √  null
valuetype_cd varchar 50  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
c_table_cd Primary key Asc table_access_pk