View transmart.deapp.de_variant_summary_detail_gene 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
variant_subject_summary_id int8 19  √  null
chr varchar 50  √  null
pos int8 19  √  null
dataset_id varchar 50  √  null
de_variant_dataset.dataset_id Implied Constraint R
subject_id varchar 50  √  null
rs_id varchar 500  √  null
variant varchar 1000  √  null
variant_format varchar 100  √  null
variant_type varchar 100  √  null
reference bool 1  √  null
allele1 int4 10  √  null
allele2 int4 10  √  null
assay_id int8 19  √  null
ref varchar 500  √  null
alt varchar 500  √  null
qual varchar 100  √  null
filter varchar 50  √  null
info varchar 10000  √  null
format varchar 500  √  null
variant_value text 2147483647  √  null
gene_name varchar 4000  √  null
gene_id varchar 4000  √  null

Analyzed at Wed Jun 26 00:11 CEST 2019


Close relationships: