attachmentimageattribute

Table info.

Title Attachment Image Attribute
Description Attachment Image Attribute

Fields

Name Type Required Index Hidden On form Title Pick list Description
AttachmentImageAttributeID int(11) PRI
TimestampCreated datetime Created The date the Image attributes record was created
TimestampModified datetime Edited The date the Image attributes record was last edited
Version int(11) Version version
CreativeCommons varchar(500) Licence Licence
  • CC BY
  • CC BY-NC-SA
  • CC BY-SA
  • CC BY-ND
  • CC BY-NC
  • CC BY-NC-ND
  • Unknown
 The licence under which the image can be released
Height int(11) Height height
Magnification double Magnification magnification
MBImageID int(11) Mb Image Id mbImageId
Resolution double Resolution resolution
TimestampLastSend datetime Timestamp Last Send timestampLastSend
TimestampLastUpdateCheck datetime Timestamp Last Update Check timestampLastUpdateCheck
Width int(11) Width width
ModifiedByAgentID int(11) MUL
MorphBankViewID int(11) MUL
CreatedByAgentID int(11) MUL
ImageType varchar(80) Image type ImageType
  • SEM
  • Light microscope image
 The type of image, e.g. SEM, Light microscope image
Number1 double Number1 number1
Number2 double Number2 number2
Remarks text Remarks remarks
Text1 varchar(200) Category ImageCategory
  • Notes
  • Habitat
  • Handwriting
  • Herbarium specimen
  • Illustration
  • Label
  • Letter
  • Person/s
  • Specimen in field
  • Specimen
  • Field notes
  • Transactions paperwork
 The context of the image
Text2 varchar(200) Photographer The name of the person who photographed the specimen. Format the name as surname, comma, initials, e.g. 'Karunajeewa, N.G.'.
ViewDescription varchar(80) View Description viewDescription
YesNo1 bit(1) Do not publish to AVH Flag this field as 'Yes' if the image should not be published to AVH
YesNo2 bit(1) Yes No2 yesNo2

Indexes

Name Fields Unique Nullable
FK857D77845327F942 ModifiedByAgentID
FK857D77847699B003 CreatedByAgentID
FK857D7784FD8D2A2A MorphBankViewID
PRIMARY AttachmentImageAttributeID

One-to-many relationships

Name Field Related table Related field
FK8AF75923C620DBC6 AttachmentImageAttributeID attachment AttachmentImageAttributeID

Many-to-one relationships

Name Field Related table Related field
FK857D77845327F942 ModifiedByAgentID agent AgentID
FK857D77847699B003 CreatedByAgentID agent AgentID
FK857D7784FD8D2A2A MorphBankViewID morphbankview MorphBankViewID