Table transmart.deapp.de_snp_info 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_info_id int8 19
de_snp_data_by_probe.snp_id fk_snp_by_probe_snp_id R
de_snp_probe.snp_id fk_snp_probe_snp_id R
name varchar 255  √  null
chrom varchar 16  √  null
chrom_pos int8 19  √  null

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
snp_info_id Primary key Asc de_snp_info_id_pk  
chrom + chrom_pos Performance Asc/Asc de_snp_chrompos_ind  
name Must be unique Asc u_snp_info_name This unique column is also nullable

Close relationships: