Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
Table pub.mgd.bib_citation_cache
A record in this table represents a unique Reference. This table is a cache table of all References in MGI. This table is loaded via the mgicacheload product. See mgicacheload/bibcitation.csh.

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
_refs_key int4 10
bib_refs._refs_key bib_citation_cache__refs_key_fkey C
foreign key to BIB_Refs
numericpart int4 10  √  null the trailing numerical portion of accID
jnumid text 2147483647  √  null J: accession id
mgiid text 2147483647 MGI accession id
pubmedid text 2147483647  √  null pubmed accession ID
doiid text 2147483647  √  null DOI (digital object identifier) accession ID
journal text 2147483647  √  null reference journal
citation text 2147483647 long citation format
short_citation text 2147483647 short citation format
referencetype text 2147483647 term of foreign key to VOC_Term._Vocab_key = 131
_relevance_key int4 10
voc_term._term_key bib_citation_cache__relevance_key_fkey R
foreign key to VOC_Term._Vocab_key = 149
relevanceterm text 2147483647 term of foreign key to VOC_Term._Vocab_key = 149
isreviewarticle int2 5 is this a review article?
isreviewarticlestring bpchar 3 string representation of isReviewArticle

Table contained 332,736 rows at Mon Sep 11 06:12 EDT 2023

Column(s) Type Sort Constraint Name
_refs_key Primary key, Used to cluster data Asc bib_citation_cache_pkey
doiid Performance Asc bib_citation_cache_idx_doiid
jnumid Performance Asc bib_citation_cache_idx_jnumid
journal Performance Asc bib_citation_cache_idx_journal
mgiid Performance Asc bib_citation_cache_idx_mgiid
numericpart Performance Asc bib_citation_cache_idx_numericpart
pubmedid Performance Asc bib_citation_cache_idx_pubmedid
_relevance_key Performance Asc bib_citation_cache_idx_relevance_key

Close relationships  within of separation: