Schema for imageFile
  Database: visiGene    Primary Table: imageFile    Row Count: 104,224   Data last updated: 2011-07-11
Format description: A biological image file
On download server: MariaDB table dump directory
fieldexampleSQL type info description
id 1int(11) range ID of imageFile
fileName 0001d.jpgvarchar(255) values Image file name, not including directory
priority 50float range Lower priorities are displayed first
imageWidth 1280int(11) range Width of image in pixels
imageHeight 1024int(11) range Height of image in pixels
fullLocation 1int(11) range Location of full-sized image
thumbLocation 2int(11) range Location of thumbnail-sized image
submissionSet 1int(11) range Submission set this is part of
submitId 1varchar(255) values ID within submission set
caption 0int(11) range Pointer to caption, or 0 for none

Connected Tables and Joining Fields
        visiGene.caption.id (via imageFile.caption)
      visiGene.fileLocation.id (via imageFile.fullLocation)
      visiGene.image.imageFile (via imageFile.id)
      visiGene.imageFileFwd.fromIf (via imageFile.id)
      visiGene.imageFileFwd.toIf (via imageFile.id)
      visiGene.image.submissionSet (via imageFile.submissionSet)
      visiGene.submissionContributor.submissionSet (via imageFile.submissionSet)
      visiGene.submissionSet.id (via imageFile.submissionSet)

Sample Rows
 
idfileNamepriorityimageWidthimageHeightfullLocationthumbLocationsubmissionSetsubmitIdcaption
10001d.jpg501280102412110
20004d.jpg501280102412140
30005d.jpg501280102412150
40006a.jpg5049665612160
50006b.jpg5053266812160
60008a.jpg5055669212180
70008b.jpg5062875612180
80009a.jpg5082893612190
90009b.jpg5058077612190
100010a.jpg50732892121100

Note: all start coordinates in our database are 0-based, not 1-based. See explanation here.