Table transmart.i2b2demodata.trial_visit_dimension
Table holds descriptions of trial visits, which represent relative time points in a study.

 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
trial_visit_num numeric 38  √  nextval('i2b2demodata.trial_visit_num_seq'::regclass)
observation_fact.trial_visit_num observation_fact_trial_visit_fk R
Primary key.
study_num numeric 38
study.study_num trial_visit_dimension_study_fk R
Foreign key to study_num in study.
rel_time_unit_cd varchar 50  √  null The unit in which rel_time_num is expressed. E.g., Week, Day, Visit.
rel_time_num numeric 38  √  null E.g., 1 (for Week 1).
rel_time_label varchar 900  √  null Descriptive name. E.g., Baseline, Week 1.

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

Indexes:
Column(s) Type Sort Constraint Name
trial_visit_num Primary key Asc trial_visit_dimension_pk
study_num Performance Asc idx_trial_visit_study_num

Close relationships  within of separation: