Table transmart.deapp.de_subject_snp_dataset 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
subject_snp_dataset_id int8 19
de_snp_data_by_patient.snp_dataset_id fk_snp_dataset_id R
de_snp_data_dataset_loc.snp_dataset_id fk_snp_loc_dataset_id R
dataset_name varchar 255  √  null
concept_cd varchar 255  √  null
platform_name varchar 255  √  null
trial_name varchar 255  √  null
patient_num int8 19  √  null
timepoint varchar 255  √  null
subject_id varchar 255  √  null
sample_type varchar 255  √  null
paired_dataset_id int8 19  √  null
patient_gender varchar 1  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
subject_snp_dataset_id Primary key Asc sys_c0020606

Close relationships: