SchemaSpy - Table pub.mgd.bib

A record in this table represents a journal article, book or personal communication.

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

serial

√

nextval('bib_refs_seq'::regclass)

acc_accessionreference._refs_key	acc_accessionreference__refs_key_fkey C
all_allele._refs_key	all_allele__refs_key_fkey R
all_cellline_derivation._refs_key	all_cellline_derivation__refs_key_fkey R
bib_books._refs_key	bib_books__refs_key_fkey C
bib_citation_cache._refs_key	bib_citation_cache__refs_key_fkey C
bib_notes._refs_key	bib_notes__refs_key_fkey C
bib_workflow_data._refs_key	bib_workflow_data__refs_key_fkey C
bib_workflow_relevance._refs_key	bib_workflow_relevance__refs_key_fkey C
bib_workflow_status._refs_key	bib_workflow_status__refs_key_fkey C
bib_workflow_tag._refs_key	bib_workflow_tag__refs_key_fkey C
crs_references._refs_key	crs_references__refs_key_fkey R
dag_dag._refs_key	dag_dag__refs_key_fkey R
gxd_antibodyalias._refs_key	gxd_antibodyalias__refs_key_fkey R
gxd_assay._refs_key	gxd_assay__refs_key_fkey R
gxd_expression._refs_key	gxd_expression__refs_key_fkey C
gxd_index._refs_key	gxd_index__refs_key_fkey R
img_image._refs_key	img_image__refs_key_fkey R
mgi_reference_assoc._refs_key	mgi_reference_assoc__refs_key_fkey R
mgi_relationship._refs_key	mgi_relationship__refs_key_fkey R
mgi_synonym._refs_key	mgi_synonym__refs_key_fkey R
mld_expts._refs_key	mld_expts__refs_key_fkey R
mld_notes._refs_key	mld_notes__refs_key_fkey R
mrk_do_cache._refs_key	mrk_do_cache__refs_key_fkey C
mrk_history._refs_key	mrk_history__refs_key_fkey R
mrk_reference._refs_key	mrk_reference__refs_key_fkey C
mrk_strainmarker._refs_key	mrk_strainmarker__refs_key_fkey R
prb_marker._refs_key	prb_marker__refs_key_fkey R
prb_reference._refs_key	prb_reference__refs_key_fkey R
prb_source._refs_key	prb_source__refs_key_fkey R
ri_summary_expt_ref._refs_key	ri_summary_expt_ref__refs_key_fkey R
seq_allele_assoc._refs_key	seq_allele_assoc__refs_key_fkey R
seq_marker_cache._refs_key	seq_marker_cache__refs_key_fkey C
seq_probe_cache._refs_key	seq_probe_cache__refs_key_fkey C
voc_evidence._refs_key	voc_evidence__refs_key_fkey R
voc_vocab._refs_key	voc_vocab__refs_key_fkey R

primary key

_referencetype_key

int4

voc_term._term_key

bib_refs__referencetype_key_fkey R

foreign key to VOC_Term where _Vocab_key = 131 (Reference Type)

authors

text

2147483647

√

null

reference authors

_primary

text

2147483647

√

null

primary author; extracted from authors field

title

text

2147483647

√

null

reference title

journal

text

2147483647

√

null

reference journal

vol

text

2147483647

√

null

reference volume number

issue

text

2147483647

√

null

reference issue

date

text

2147483647

√

null

reference date

year

int4

√

null

year of publication

pgs

text

2147483647

√

null

page range of reference

abstract

text

2147483647

√

null

NLM (Medline) abstract

isreviewarticle

int2

is this a review article?

_createdby_key

int4

1001

mgi_user._user_key

bib_refs__createdby_key_fkey R

user who created the record

_modifiedby_key

int4

1001

mgi_user._user_key

bib_refs__modifiedby_key_fkey R

user who last modified the record

creation_date

timestamp

29,6

now()

date record was created

modification_date

timestamp

29,6

now()

date record was last modified

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_refs_pkey
(md5(authors))	Performance	Asc	bib_refs_idx_authors
_createdby_key	Performance	Asc	bib_refs_idx_createdby_key
creation_date	Performance	Asc	bib_refs_idx_creation_date
_primary	Performance	Asc	bib_refs_idx_isprimary
journal	Performance	Asc	bib_refs_idx_journal
modification_date	Performance	Asc	bib_refs_idx_modification_date
_modifiedby_key	Performance	Asc	bib_refs_idx_modifiedby_key
_referencetype_key	Performance	Asc	bib_refs_idx_referencetype_key
title	Performance	Asc	bib_refs_idx_title
year	Performance	Asc	bib_refs_idx_year