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
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
_refs_key int4 10
bib_refs
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
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

Indexes:
Column(s) Type Sort
_refs_key Primary key, Used to cluster data Asc
doiid Performance Asc
jnumid Performance Asc
journal Performance Asc
mgiid Performance Asc
numericpart Performance Asc
pubmedid Performance Asc
_relevance_key Performance Asc

Close relationships  within of separation: