Table transmart.deapp.de_variant_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
dataset_id varchar 50
de_variant_metadata.dataset_id var_met_dataset_id R
de_variant_population_data.dataset_id de_variant_population_data_fk R
de_variant_population_info.dataset_id de_variant_population_info_fk R
de_variant_subject_detail.dataset_id variant_subject_detail_fk R
de_variant_subject_idx.dataset_id variant_subject_idx_fk R
de_variant_subject_summary.dataset_id variant_subject_summary_fk R
de_variant_summary_detail_gene.dataset_id Implied Constraint R
datasource_id varchar 200  √  null
etl_id varchar 20  √  null
etl_date date 13  √  null
genome varchar 50
metadata_comment text 2147483647  √  null
variant_dataset_type varchar 50  √  null
gpl_id varchar 50  √  null
de_gpl_info.platform gpl_id R

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

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

Close relationships  within of separation: