Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
Table pub.mgd.voc_allele_cache
A record in this table represents the cached value of the association between an Allele and an Annotation Type. The Annotation Types are VOC_AnnotType: 1002:Mammalian Phentype/Genotype, 1020:DO/Genotype. The cache is loaded from mgicacheload/vocallele.csh which calls stored procedures in pgmgddbschema/procedure (VOC_Allele_Cache, VOC_GO_Cache, VOC_Marker_Cache).

Generated by
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_allele_cache_seq'::regclass)
voc_annot_count_cache._cache_key Implied Constraint R
voc_go_cache._cache_key Implied Constraint R
voc_marker_cache._cache_key Implied Constraint R
_term_key int4 10
voc_term._term_key voc_allele_cache__term_key_fkey R
foreign key to VOC_Term
_allele_key int4 10
all_allele._allele_key voc_allele_cache__allele_key_fkey R
foreign key to ALL_Allele
annottype text 2147483647 see table description for details

Table contained 440,559 rows at Mon Sep 11 06:12 EDT 2023

Column(s) Type Sort Constraint Name
_cache_key Primary key Asc voc_allele_cache_pkey
_allele_key + _term_key Performance Asc/Asc voc_allele_cache_idx_allele_key
annottype + _allele_key Performance Asc/Asc voc_allele_cache_idx_annottype

Close relationships  within of separation: