Table transmart.i2b2demodata.study
Table holds studies and their access tokens

 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
study_num numeric 38  √  nextval('i2b2demodata.study_num_seq'::regclass)
linked_file_collection.study_id STUDY_ID_FK R
trial_visit_dimension.study_num trial_visit_dimension_study_fk R
Primary key.
bio_experiment_id int8 19  √  null
bio_experiment.bio_experiment_id study_bio_experiment_id_fk R
Foreign key: bio_experiment_id in bio_experiment.
study_id varchar 100 Unique study name. E.g., GSE8581.
secure_obj_token varchar 200 Token needed for access to the study. E.g., ?PUBLIC? or ?EXP:GSE8581?.
study_blob text 2147483647  √  null Stores arbitrary information about the study

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

Indexes:
Column(s) Type Sort Constraint Name
study_num Primary key Asc study_pk
study_id Must be unique Asc idx_study_id
study_num Must be unique Asc idx_study_pk
secure_obj_token Performance Asc idx_study_secure_obj_token

Close relationships  within of separation: