taxonattachment

Table info.

Title Taxon Attachment
Description Taxon Attachment

Fields

Name Type Required Index Hidden On form Title Pick list Description
TaxonAttachmentID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Ordinal int(11) Ordinal ordinal
Remarks text Remarks remarks
ModifiedByAgentID int(11) MUL
TaxonID int(11) MUL
AttachmentID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKF523736D1D39F06C TaxonID
FKF523736D5327F942 ModifiedByAgentID
FKF523736D7699B003 CreatedByAgentID
FKF523736DC7E55084 AttachmentID
PRIMARY TaxonAttachmentID

Many-to-one relationships

Name Field Related table Related field
FKF523736D1D39F06C TaxonID taxon TaxonID
FKF523736D5327F942 ModifiedByAgentID agent AgentID
FKF523736D7699B003 CreatedByAgentID agent AgentID
FKF523736DC7E55084 AttachmentID attachment AttachmentID