SchemaSpy - Table mgd.mgd.img_cache

	Schema Browser
Home \| About \| Help \| FAQ

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

_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