| 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 SchemaSpy |
| |||||||||||||||||||||||||||||||||||||||||||||||||||
Table contained 459,040 rows at Tue Nov 11 10:12 EST 2025 | |||||||||||||||||||||||||||||||||||||||||||||||||||
Indexes:
| 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 |
|