Mouse Genome Informatics Schema Browser  
 Mouse Genome Informatics
MGI Home    Help
 
Table pub.mgd.img_image
A record in this table represents a full size or thumbnail Image. If the X dimension (width) and Y dimension (height) are non-null, then an Image file is associated with the Image (via the PIX accession ID).

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
gxd_isresultimage_view._image_key Implied Constraint R
img_image._thumbnailimage_key img_image__thumbnailimage_key_fkey C
img_image_view._image_key Implied Constraint R
img_imagepane._image_key img_imagepane__image_key_fkey C
img_imagepanegxd_view._image_key Implied Constraint R
primary key
_mgitype_key int4 10
acc_mgitype._mgitype_key img_image__mgitype_key_fkey R
foreign key to ACC_MGIType
_imageclass_key int4 10
voc_term._term_key img_image__imageclass_key_fkey R
foreign key to VOC_Term where _Vocab_key = 83 (Image Class); 'Expression', 'Phenotypes', 'Molecular'
_imagetype_key int4 10
voc_term._term_key img_image__imagetype_key_fkey R
foreign key to VOC_Term where _Vocab_key = 47 (Image Type)
_refs_key int4 10
bib_refs._refs_key img_image__refs_key_fkey R
foreign key to BIB_Refs
_thumbnailimage_key int4 10  √  null
img_image._image_key img_image__thumbnailimage_key_fkey C
foreign key to IMG_Image; if _ImageType_key is full size, then this refers to an IMG_Image object where _ImageType_key is thumbnail; it specifies that thumbnail image counterpart of the full size Image.
xdim int4 10  √  null X dimension of JPEG image
ydim int4 10  √  null Y dimensions of JPEG image
figurelabel text 2147483647 figure label
_createdby_key int4 10 1001
mgi_user._user_key img_image__createdby_key_fkey R
user who created the record
_modifiedby_key int4 10 1001
mgi_user._user_key img_image__modifiedby_key_fkey R
user who last modified the record
creation_date timestamp 29,6 now() date record was created
modification_date timestamp 29,6 now() date record was last modified

Table contained 280,239 rows at Mon Nov 20 05:26 EST 2017

Indexes:
Column(s) Type Sort Constraint Name
_image_key Primary key, Used to cluster data Asc img_image_pkey
_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: