Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.bib_refs
A record in this table represents a journal article, book or personal communication.

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
acc_accessionreference._refs_key acc_accessionreference__refs_key_fkey C
all_allele._refs_key all_allele__refs_key_fkey R
all_allele_view._refs_key Implied Constraint R
all_cellline_derivation._refs_key all_cellline_derivation__refs_key_fkey R
all_cellline_derivation_view._refs_key Implied Constraint R
bib_all2_view._refs_key Implied Constraint R
bib_all_view._refs_key Implied Constraint R
bib_associateddata_view._refs_key Implied Constraint R
bib_books._refs_key bib_books__refs_key_fkey C
bib_citation_cache._refs_key bib_citation_cache__refs_key_fkey C
bib_dataset_assoc._refs_key bib_dataset_assoc__refs_key_fkey C
bib_notes._refs_key bib_notes__refs_key_fkey C
bib_view._refs_key Implied Constraint R
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_antibodyalias_view._refs_key Implied Constraint R
gxd_antibodyaliasref_view._refs_key Implied Constraint R
gxd_antibodyantigen_view._refs_key Implied Constraint R
gxd_antigen_view._refs_key Implied Constraint R
gxd_assay._refs_key gxd_assay__refs_key_fkey R
gxd_assay_view._refs_key Implied Constraint R
gxd_expression._refs_key gxd_expression__refs_key_fkey C
gxd_index._refs_key gxd_index__refs_key_fkey R
gxd_index_view._refs_key Implied Constraint R
img_image._refs_key img_image__refs_key_fkey R
img_image_view._refs_key Implied Constraint R
img_imagepanegxd_view._refs_key Implied Constraint R
mgi_reference_allele_view._refs_key Implied Constraint R
mgi_reference_antibody_view._refs_key Implied Constraint R
mgi_reference_assoc._refs_key mgi_reference_assoc__refs_key_fkey R
mgi_reference_marker_view._refs_key Implied Constraint R
mgi_reference_sequence_view._refs_key Implied Constraint R
mgi_reference_strain_view._refs_key Implied Constraint R
mgi_relationship._refs_key mgi_relationship__refs_key_fkey R
mgi_synonym._refs_key mgi_synonym__refs_key_fkey R
mgi_synonym_allele_view._refs_key Implied Constraint R
mgi_synonym_goterm_view._refs_key Implied Constraint R
mgi_synonym_musmarker_view._refs_key Implied Constraint R
mgi_synonym_strain_view._refs_key Implied Constraint R
mld_expt_view._refs_key Implied Constraint R
mld_expts._refs_key mld_expts__refs_key_fkey R
mld_notes._refs_key mld_notes__refs_key_fkey R
mrk_accref1_view._refs_key Implied Constraint R
mrk_accref2_view._refs_key Implied Constraint R
mrk_accref3_view._refs_key Implied Constraint R
mrk_accref_view._refs_key Implied Constraint R
mrk_do_cache._refs_key mrk_do_cache__refs_key_fkey C
mrk_history._refs_key mrk_history__refs_key_fkey R
mrk_history_view._refs_key Implied Constraint R
mrk_reference._refs_key mrk_reference__refs_key_fkey C
mrk_reference_view._refs_key Implied Constraint R
prb_marker._refs_key prb_marker__refs_key_fkey R
prb_marker_view._refs_key Implied Constraint R
prb_reference._refs_key prb_reference__refs_key_fkey R
prb_reference_view._refs_key Implied Constraint R
prb_source._refs_key prb_source__refs_key_fkey R
prb_source_view._refs_key Implied Constraint R
pwi_all_allele_view._refs_key Implied Constraint R
pwi_bib_refs_view._refs_key Implied Constraint 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_allele_assoc_view._refs_key Implied Constraint R
seq_allele_view._refs_key Implied Constraint R
seq_marker_cache._refs_key seq_marker_cache__refs_key_fkey C
seq_marker_cache_view._refs_key Implied Constraint R
seq_probe_cache._refs_key seq_probe_cache__refs_key_fkey C
seq_probe_cache_view._refs_key Implied Constraint R
voc_evidence._refs_key voc_evidence__refs_key_fkey R
voc_evidence_view._refs_key Implied Constraint R
voc_vocab._refs_key voc_vocab__refs_key_fkey R
voc_vocab_view._refs_key Implied Constraint R
primary key
_referencetype_key int4 10
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 10  √  null year of publication
pgs text 2147483647  √  null page range of reference
abstract text 2147483647  √  null NLM (Medline) abstract
isreviewarticle int2 5 is this a review article?
isdiscard int2 5 is this a discarded reference?
_createdby_key int4 10 1001
mgi_user._user_key bib_refs__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 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 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_refs_pkey
(md5(authors)) Performance Asc bib_refs_idx_authors
_createdby_key Performance Asc bib_refs_idx_createdby_key
_primary Performance Asc bib_refs_idx_isprimary
journal Performance Asc bib_refs_idx_journal
_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

Close relationships  within of separation: