accessionattachment

Table info.

Title Accession Attachment
Description Accession Attachment

Fields

Name Type Required Index Hidden On form Title Pick list Description
AccessionAttachmentID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Ordinal int(11) Ordinal Provides a sequencial order for the attachments.
Remarks text Remarks Additional comments.
CreatedByAgentID int(11) MUL
AccessionID int(11) MUL
AttachmentID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKA569B4473925EE20 AccessionID
FKA569B4475327F942 ModifiedByAgentID
FKA569B4477699B003 CreatedByAgentID
FKA569B447C7E55084 AttachmentID
PRIMARY AccessionAttachmentID

Many-to-one relationships

Name Field Related table Related field
FKA569B4473925EE20 AccessionID accession AccessionID
FKA569B4475327F942 ModifiedByAgentID agent AgentID
FKA569B4477699B003 CreatedByAgentID agent AgentID
FKA569B447C7E55084 AttachmentID attachment AttachmentID