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
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
img_imagepane
primary key
_imageclass_key int4 10
voc_term
foreign key to VOC_Term where _Vocab_key = 83 (Image Class); 'Expression', 'Phenotypes', 'Molecular'
_imagetype_key int4 10
voc_term
foreign key to VOC_Term where _Vocab_key = 47 (Image Type)
_refs_key int4 10
bib_refs
foreign key to BIB_Refs
_thumbnailimage_key int4 10  √  null
img_image
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 who created the record
_modifiedby_key int4 10 1001
mgi_user
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 342,097 rows at Mon Sep 11 06:12 EDT 2023

Indexes:
Column(s) Type Sort
_image_key Primary key Asc
_createdby_key Performance Asc
creation_date Performance Asc
_imageclass_key Performance Asc
_imagetype_key Performance Asc
modification_date Performance Asc
_modifiedby_key Performance Asc
_refs_key Performance Asc
_thumbnailimage_key Performance Asc

Close relationships  within of separation: