| 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 440,559 rows at Mon Sep 11 06:12 EDT 2023 | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
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 |
|