Table transmart.deapp.de_snp_data_by_probe 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
snp_data_by_probe_id int8 19
probe_id int8 19  √  null
de_snp_probe.snp_probe_id fk_snp_by_probe_probe_id R
probe_name varchar 255  √  null
snp_id int8 19  √  null
de_snp_info.snp_info_id fk_snp_by_probe_snp_id R
snp_name varchar 255  √  null
trial_name varchar 255  √  null
data_by_probe text 2147483647  √  null
bio_asy_geno_platform_probe_id int8 19  √  null
genotype_probe_annotation_id int8 19  √  null
a1 varchar 4000  √  null
a2 varchar 4000  √  null
a1_clob text 2147483647  √  null
a2_clob text 2147483647  √  null
impute_quality numeric 131089  √  null
gps_by_probe_blob text 2147483647  √  null
gts_by_probe_blob text 2147483647  √  null
dose_by_probe_blob text 2147483647  √  null
gt_probability_threshold numeric 131089  √  null
maf numeric 131089  √  null
minor_allele varchar 2  √  null
c_a1_a1 numeric 131089  √  null
c_a1_a2 numeric 131089  √  null
c_a2_a2 numeric 131089  √  null
c_nocall numeric 131089  √  null
created_by varchar 30  √  null
created_date date 13  √  null
modified_by varchar 30  √  null
modified_date date 13  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
snp_data_by_probe_id Primary key Asc sys_c0020601
snp_data_by_probe_id + probe_name Must be unique Asc/Asc idx_dsdbp_probe_idname
trial_name Performance Asc idx_dsdbp_trial_name

Close relationships: