Table transmart.i2b2demodata.concept_dimension
Table contains the concepts that classify observations.

 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
concept_cd varchar 50 REQUIRED. The code that is used to refer to the concept from observation_fact.
concept_path varchar 700
ricerca.concept_path Implied Constraint R
Primary key. The path that uniquely identifies a concept.
name_char varchar 2000  √  null REQUIRED. The name of the concept.
concept_blob text 2147483647  √  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 int8 19  √  null
table_name varchar 255  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
concept_path Primary key Asc concept_dimension_pk
concept_cd Performance Asc concept_dimension_concept_cd_idx

Close relationships: