Schema Browser
 Home  | About  | Help  | FAQ  
Table mgd.mgd.img_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
_cache_key int4 10
all_cre_cache._cache_key Implied Constraint R
_image_key int4 10
img_image._image_key Implied Constraint R
_thumbnailimage_key int4 10
_imagepane_key int4 10
img_imagepane._imagepane_key Implied Constraint R
_imagemgitype_key int4 10
acc_mgitype._mgitype_key img_cache__imagemgitype_key R
_object_key int4 10
_mgitype_key int4 10
acc_mgitype._mgitype_key img_cache__mgitype_key R
_imageclass_key int4 10
_refs_key int4 10
bib_refs._refs_key Implied Constraint R
_assaytype_key int4 10  √  null
gxd_assaytype._assaytype_key Implied Constraint R
numericpart int4 10
thumbnailnumericpart int4 10
sequencenum int4 10
assaytype varchar 80  √  null
figurelabel varchar 255
panelabel varchar 255  √  null

Table contained 226,742 rows at Mon Sep 26 19:11 EDT 2011

Indexes:
Column(s) Type Sort Constraint Name
_object_key + _mgitype_key + sequencenum Performance Asc/Asc/Asc img_cache_idx_cover1

Close relationships  within of separation: