Schema Browser
 Home  | About  | Help  | FAQ  
Table mgd.mgd.img_image 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
_image_key int4 10
img_cache._image_key Implied Constraint R
img_image._thumbnailimage_key img_image__thumbnailimage_key R
img_imagepane._image_key Implied Constraint R
_mgitype_key int4 10
acc_mgitype._mgitype_key img_image__mgitype_key R
_imageclass_key int4 10
voc_term._term_key img_image__imageclass_key R
_imagetype_key int4 10
voc_term._term_key img_image__imagetype_key R
_refs_key int4 10
bib_refs._refs_key img_image__refs_key R
_thumbnailimage_key int4 10  √  null
img_image._image_key img_image__thumbnailimage_key R
xdim int4 10  √  null
ydim int4 10  √  null
figurelabel varchar 255
_createdby_key int4 10
mgi_user._user_key img_image__createdby_key R
_modifiedby_key int4 10
mgi_user._user_key img_image__modifiedby_key R
creation_date timestamp 29,6
modification_date timestamp 29,6

Table contained 382,086 rows at Mon Sep 26 19:11 EDT 2011

Indexes:
Column(s) Type Sort Constraint Name
_image_key Primary key Asc img_image_pkey
_image_key Must be unique Asc img_image_idx_image_key
_createdby_key Performance Asc img_image_idx_createdby_key
_imageclass_key Performance Asc img_image_idx_imageclass_key
_imagetype_key Performance Asc img_image_idx_imagetype_key
_mgitype_key Performance Asc img_image_idx_mgitype_key
_modifiedby_key Performance Asc img_image_idx_modifiedby_key
_refs_key Performance Asc img_image_idx_refs_key
_thumbnailimage_key Performance Asc img_image_idx_thumbnailimage_key

Close relationships  within of separation: