collectionobjectattachment

Table info.

Title Collection Object Attachment
Description Collection Object Attachment

Fields

Name Type Required Index Hidden On form Title Pick list Description
CollectionObjectAttachmentID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
CollectionMemberID int(11) MUL Collection Member Id collectionMemberId
Ordinal int(11) Ordinal The order in the attachment list.
Remarks text Comments remarks
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
CollectionObjectID int(11) MUL
AttachmentID int(11) MUL

Indexes

Name Fields Unique Nullable
COLOBJATTColMemIDX CollectionMemberID
FK9C00EC405327F942 ModifiedByAgentID
FK9C00EC4075E37458 CollectionObjectID
FK9C00EC407699B003 CreatedByAgentID
FK9C00EC40C7E55084 AttachmentID
PRIMARY CollectionObjectAttachmentID

Many-to-one relationships

Name Field Related table Related field
FK9C00EC405327F942 ModifiedByAgentID agent AgentID
FK9C00EC4075E37458 CollectionObjectID collectionobject CollectionObjectID
FK9C00EC407699B003 CreatedByAgentID agent AgentID
FK9C00EC40C7E55084 AttachmentID attachment AttachmentID