SchemaSpy - Table pub.mgd.bib_citation

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:

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

bib_refs._refs_key

bib_citation_cache__refs_key_fkey C

foreign key to BIB_Refs

numericpart

int4

√

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

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

is this a review article?

isreviewarticlestring

bpchar

string representation of isReviewArticle

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

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
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