Table transmart.deapp.de_gene_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
gene_info_id serial 10  √  nextval('deapp.de_gene_info_gene_info_id_seq'::regclass)
gene_source_id int4 10 1
de_gene_source.gene_source_id Implied Constraint R
entrez_id int4 10  √  null
gene_symbol varchar 255
gene_name varchar 255  √  null
chrom varchar 40  √  null
chrom_start int4 10  √  null
chrom_stop int4 10  √  null
strand int2 5  √  null

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

Indexes:
Column(s) Type Sort Constraint Name
entrez_id + gene_source_id Performance Asc/Asc de_gene_info_entrez_id_gene_source_id_idx
gene_symbol Performance Asc de_gene_info_gene_symbol_idx

Close relationships: