Schemas
Tables
Relationships
Utility Tables
Constraints
Anomalies
Columns
Donate
Table
transmart
.
i2b2demodata
.
patient_trial
Table that links patients to trials. Unused.
Generated by
SchemaSpy
Related columns
Constraints
Comments
Legend
Legend:
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
patient_num
numeric
131089
√
null
Id that links to the patient_num of the patient_dimension table.
trial
varchar
30
√
null
Name of the trial.
secure_obj_token
varchar
50
√
null
Token referring to bio_data_unique_id in searchapp.search_secure_object. E.g., PUBLIC or EXP:GSE8581.
Table contained 0 rows at Wed Jun 26 00:11 CEST 2019