Table transmart.deapp.de_variant_subject_summary 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 bigserial 19  √  nextval('deapp.de_variant_subject_summary_seq'::regclass)
chr varchar 50  √  null
pos int8 19  √  null
dataset_id varchar 50
de_variant_dataset.dataset_id variant_subject_summary_fk R
subject_id varchar 50
rs_id varchar 500  √  null
variant varchar 1000  √  null
variant_format varchar 100  √  null
variant_type varchar 100  √  null
reference bool 1  √  null This column contains a flag whether this subject has a reference value on this variant, or not.
allele1 int4 10  √  null
allele2 int4 10  √  null
assay_id int8 19  √  null Reference to de_subject_sample_mapping

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

Indexes:
Column(s) Type Sort Constraint Name
variant_subject_summary_id Primary key Asc variant_subject_summary_id
chr + pos Performance Asc/Asc gen_variant_subj_summ_chr_pos
dataset_id + chr + pos + rs_id + subject_id Must be unique Asc/Asc/Asc/Asc/Asc variant_subject_summary_uk

Close relationships  within of separation: