SchemaSpy - Table pub.mgd.voc_marker

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
SchemaSpy

Legend:

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

√

nextval('voc_marker_cache_seq'::regclass)

voc_allele_cache._cache_key

Implied Constraint R

_term_key

int4

voc_term._term_key

voc_marker_cache__term_key_fkey R

foreign key to VOC_Term

_marker_key

int4

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

Indexes:

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