collectingeventattachment

Table info.

Title Collecting Event Attachment
Description Collecting Event Attachment

Fields

Name Type Required Index Hidden On form Title Pick list Description
CollectingEventAttachmentID 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 or position of the attachment.
Remarks text Remarks Additonal comments.
CollectingEventID int(11) MUL
ModifiedByAgentID int(11) MUL
AttachmentID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
CEAColMemIDX CollectionMemberID
FK32C365C55327F942 ModifiedByAgentID
FK32C365C57699B003 CreatedByAgentID
FK32C365C5B237E2BC CollectingEventID
FK32C365C5C7E55084 AttachmentID
PRIMARY CollectingEventAttachmentID

Many-to-one relationships

Name Field Related table Related field
FK32C365C55327F942 ModifiedByAgentID agent AgentID
FK32C365C57699B003 CreatedByAgentID agent AgentID
FK32C365C5B237E2BC CollectingEventID collectingevent CollectingEventID
FK32C365C5C7E55084 AttachmentID attachment AttachmentID