Table transmart.i2b2demodata.code_lookup 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
table_cd varchar 100
column_cd varchar 100
code_cd varchar 50
name_char varchar 650  √  null
lookup_blob text 2147483647  √  null
upload_date timestamp 29,6  √  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 numeric 38  √  null
upload_status.upload_id Implied Constraint R

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

Indexes:
Column(s) Type Sort Constraint Name
table_cd + column_cd + code_cd Primary key Asc/Asc/Asc code_lookup_pk
name_char Performance Asc cl_idx_name_char
upload_id Performance Asc cl_idx_uploadid

Close relationships: