Table transmart.deapp.de_mrna_annotation 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
gpl_id varchar 100  √  null
probe_id varchar 100  √  null
gene_symbol varchar 100  √  null
probeset_id int8 19  √  null
gene_id int8 19  √  null
organism varchar 200  √  null
de_mrna_annotation_id int8 19

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

Indexes:
Column(s) Type Sort Constraint Name
de_mrna_annotation_id Primary key Asc de_mrna_annotation_pkey
gpl_id + probe_id Performance Asc/Asc de_mrna_annotation_idx1
gene_id + probeset_id Performance Asc/Asc de_mrna_annotation_idx2