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
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
isreviewarticle int2 5 is this a review article?
isreviewarticlestring bpchar 3 string representation of isReviewArticle
isdiscard int2 5

Table contained 239,950 rows at Mon Nov 20 05:26 EST 2017

Indexes:
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
numericpart Performance Asc bib_citation_cache_idx_numericpart
pubmedid Performance Asc bib_citation_cache_idx_pubmedid

Close relationships  within of separation: