Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.voc_go_cache
A record in thie table represents the cached value of the GO Terms, the GO DAG and GO accession ids. See mgicacheload/vocgo.csh.

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
_cache_key serial 10  √  nextval('voc_go_cache__cache_key_seq'::regclass)
voc_allele_cache._cache_key Implied Constraint R
_term_key int4 10
voc_term._term_key voc_go_cache__term_key_fkey C
foreign key to VOC_Term
_dag_key int4 10
dag_dag._dag_key voc_go_cache__dag_key_fkey C
foreign key to DAG_DAG
dagabbrev bpchar 5 DAG abbreviation name ('C', 'F', 'O', 'P')
accid text 2147483647 GO accession id of the Term (GO:xxxxx)
term text 2147483647 term name (VOC_Term.term)

Table contained 47,058 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_cache_key Primary key, Used to cluster data Asc voc_go_cache_pkey
_term_key Performance Asc voc_go_cache_idx_clustered
_dag_key Performance Asc voc_go_cache_idx_dag_key
_term_key Performance Asc voc_go_cache_idx_term_key

Close relationships  within of separation: