Table transmart.deapp.de_rc_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 bigserial 19  √  nextval('deapp.de_rc_snp_info_seq'::regclass)
rs_id varchar 50  √  null
chrom varchar 4  √  null
pos int8 19  √  null
ref varchar 1000  √  null
alt varchar 1000  √  null
gene_info varchar 1000  √  null
variation_class varchar 24  √  null
strand varchar 1  √  null
clinsig varchar 100  √  null
disease varchar 500  √  null
gmaf varchar 10  √  null
gene_biotype varchar 100  √  null
impact varchar 50  √  null
transcript_id varchar 100  √  null
functional_class varchar 100  √  null
effect varchar 100  √  null
exon_id varchar 100  √  null
amino_acid_change varchar 100  √  null
codon_change varchar 1000  √  null
hg_version varchar 10  √  null
gene_name varchar 50  √  null
entrez_id varchar 50  √  null
recombination_rate numeric 18,6  √  null
recombination_map numeric 18,6  √  null
regulome_score varchar 10  √  null
exon_intron varchar 50  √  null

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

Indexes:
Column(s) Type Sort Constraint Name Anomalies
snp_info_id Performance Asc de_r_s_i_ind4  
chrom + pos Performance Asc/Asc de_rc_snp_info_chrom_pos_idx  
entrez_id Performance Asc de_rc_snp_info_entrez_id_idx  
rs_id Performance Asc de_rc_snp_info_rs_id_idx  
chrom + hg_version + pos Performance Asc/Asc/Asc de_rsnp_chrom_comp_idx  
chrom + pos Performance Asc/Asc de_rsnp_chrompos_ind  
hg_version + rs_id Must be unique Asc/Asc de_rsnp_hgrs_ind These unique columns are also nullable
pos Performance Asc ind_vcf_pos  
rs_id Performance Asc ind_vcf_rsid