Table transmart.deapp.de_variant_subject_detail 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_detail_id bigserial 19  √  nextval('deapp.de_variant_subject_detail_seq'::regclass)
dataset_id varchar 50  √  null
de_variant_dataset.dataset_id variant_subject_detail_fk R
chr varchar 50  √  null
pos int8 19  √  null
rs_id varchar 50  √  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

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
variant_subject_detail_id Primary key Asc variant_subject_detail_id  
dataset_id + chr Performance Asc/Asc de_variant_sub_detail_idx2  
dataset_id + rs_id Performance Asc/Asc de_variant_sub_dt_idx1  
chr + pos Performance Asc/Asc gen_variant_subj_det_chr_pos  
dataset_id + chr + pos + rs_id Must be unique Asc/Asc/Asc/Asc variant_subject_detail_uk These unique columns are also nullable

Close relationships  within of separation: