Schema Browser
 Home  | About  | Help  | FAQ  
Table mgd.mgd.bib_citation_cache 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 R
numericpart int4 10
jnumid varchar 30
mgiid varchar 30
pubmedid varchar 30  √  null
reviewstatus varchar 40
journal varchar 100  √  null
citation varchar 255
short_citation varchar 255
isreviewarticle int2 5
isreviewarticlestring bpchar 3

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_citation_cache_pkey
_refs_key Must be unique Asc bib_citation_cache_idx_refs_key
journal Performance Asc bib_citation_cache_idx_journal

Close relationships  within of separation: