Table transmart.i2b2metadata.dimension_description
All supported dimensions and their properties.

 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
id serial 10  √  nextval('i2b2metadata.dimension_description_id_seq'::regclass)
study_dimension_descriptions.dimension_description_id fk_9vvv5m5nbxsu2lkbeeftevd5j R
density varchar 255  √  null Indicates the typical density of the dimension. [DENSE, SPARSE]
modifier_code varchar 255  √  null The modifier code if the dimension is a modifier dimension
value_type varchar 50  √  null T for string, N for numeric, B for raw text and D for date values. [T, N, B, D]
name varchar 255 The name of the dimension.
packable varchar 255  √  null Indicates if dimensions values can be packed when serialising. NOT_PACKABLE is a good default. [PACKABLE, NOT_PACKABLE]
size_cd varchar 255  √  null Indicates the typical size of the dimension. [SMALL, MEDIUM, LARGE]
dimension_type varchar 50  √  null Indicates whether the dimension represents subjects or observation attributes. [SUBJECT, ATTRIBUTE]
sort_index int4 10  √  null Specifies a relative order between dimensions.

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc dimension_description_pkey
name Must be unique Asc dimension_description_unique_name

Close relationships: