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 serial 10  √  nextval('img_image_seq'::regclass)
img_image._thumbnailimage_key img_image__thumbnailimage_key_fkey C
img_imagepane._image_key img_imagepane__image_key_fkey C
primary key
_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 287,748 rows at Mon Mar 09 10:28 EDT 2020

Indexes:
Column(s) Type Sort Constraint Name
_image_key Primary key 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
_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: