Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
Table pub.mgd.voc_marker_cache
A record in this table represents a cached value of the association between a Marker, a Term and an Annotation Type. The Annotation Types are VOC_AnnotType: 1000:GO/Marker, 1003:InterPro/Marker, 1002:Mammalian Phenotype/Genotype, 1020:DO/Genotype, 1022:DO/Human Marker, 1007:PIRSF/Marker. The cache is loaded from mgicacheload/vocmarker.csh which refers to stored procedues in mgddbschema/procedure (VOC_Cache_Markers, VOC_Cache_Anatomy_Markers, VOC_Cache_MP_Markers, VOC_Cache_DO_Markers, VOC_Cache_Other_Markers).

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_marker_cache_seq'::regclass)
voc_allele_cache._cache_key Implied Constraint R
_term_key int4 10
voc_term._term_key voc_marker_cache__term_key_fkey R
foreign key to VOC_Term
_marker_key int4 10
mrk_marker._marker_key voc_marker_cache__marker_key_fkey C
foreign key to MRK_Marker
annottype text 2147483647 see table description for details

Table contained 4,061,465 rows at Mon Sep 11 06:12 EDT 2023

Column(s) Type Sort Constraint Name
_cache_key Primary key Asc voc_marker_cache_pkey
annottype Performance Asc voc_marker_cache_idx_annottype
annottype + _marker_key Performance Asc/Asc voc_marker_cache_idx_annottype_etc
_marker_key + _term_key Performance Asc/Asc voc_marker_cache_idx_marker_key
_term_key + _marker_key Performance Asc/Asc voc_marker_cache_idx_term_key

Close relationships  within of separation: