SchemaSpy - Table mgd.mgd.bib

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

acc_accessionreference._refs_key	acc_accessionreference__refs_key R
all_cellline_derivation._refs_key	all_cellline_derivation__refs_key R
all_marker_assoc._refs_key	all_marker_assoc__refs_key R
bib_books._refs_key	bib_books__refs_key R
bib_citation_cache._refs_key	bib_citation_cache__refs_key R
bib_dataset_assoc._refs_key	bib_dataset_assoc__refs_key R
bib_notes._refs_key	bib_notes__refs_key R
crs_references._refs_key	crs_references__refs_key R
dag_dag._refs_key	dag_dag__refs_key R
gxd_antibodyalias._refs_key	gxd_antibodyalias__refs_key R
gxd_assay._refs_key	gxd_assay__refs_key R
gxd_expression._refs_key	gxd_expression__refs_key R
gxd_index._refs_key	gxd_index__refs_key R
hmd_homology._refs_key	hmd_homology__refs_key R
img_cache._refs_key	Implied Constraint R
img_image._refs_key	img_image__refs_key R
mgi_reference_assoc._refs_key	mgi_reference_assoc__refs_key R
mgi_synonym._refs_key	mgi_synonym__refs_key R
mlc_reference._refs_key	mlc_reference__refs_key R
mld_expts._refs_key	mld_expts__refs_key R
mld_notes._refs_key	mld_notes__refs_key R
mrk_history._refs_key	mrk_history__refs_key R
mrk_homology_cache._refs_key	Implied Constraint R
mrk_omim_cache._refs_key	Implied Constraint R
mrk_reference._refs_key	mrk_reference__refs_key R
prb_marker._refs_key	prb_marker__refs_key R
prb_reference._refs_key	prb_reference__refs_key R
prb_source._refs_key	prb_source__refs_key R
ri_summary_expt_ref._refs_key	ri_summary_expt_ref__refs_key R
seq_allele_assoc._refs_key	seq_allele_assoc__refs_key R
seq_marker_cache._refs_key	Implied Constraint R
seq_probe_cache._refs_key	seq_probe_cache__refs_key R
voc_evidence._refs_key	voc_evidence__refs_key R
voc_vocab._refs_key	voc_vocab__refs_key R

_reviewstatus_key

int4

bib_reviewstatus._reviewstatus_key

bib_refs__reviewstatus_key R

reftype

bpchar

authors

varchar

255

√

null

authors2

varchar

255

√

null

_primary

varchar

√

null

title

varchar

255

√

null

title2

varchar

255

√

null

journal

varchar

100

√

null

vol

varchar

√

null

issue

varchar

√

null

date

varchar

√

null

year

int4

√

null

pgs

varchar

√

null

nlmstatus

bpchar

abstract

text

2147483647

√

null

isreviewarticle

int2

_createdby_key

int4

mgi_user._user_key

bib_refs__createdby_key R

_modifiedby_key

int4

mgi_user._user_key

bib_refs__modifiedby_key R

creation_date

timestamp

29,6

modification_date

timestamp

29,6

Table contained 169,860 rows at Mon Sep 26 19:11 EDT 2011

Indexes:

Column(s)	Type	Sort	Constraint Name
_refs_key	Primary key	Asc	bib_refs_pkey
_refs_key	Must be unique	Asc	bib_refs_idx_refs_key
authors	Performance	Asc	bib_refs_idx_authors
journal	Performance	Asc	bib_refs_idx_journal
_primary	Performance	Asc	bib_refs_idx_primary
_reviewstatus_key	Performance	Asc	bib_refs_idx_reviewstatus_key
title	Performance	Asc	bib_refs_idx_title
year	Performance	Asc	bib_refs_idx_year