conserveventattachment

Table info.

Title Conservator Event Attachment
Description Conservator Event Attachment

Fields

Name Type Required Index Hidden On form Title Pick list Description
ConservEventAttachmentID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Ordinal int(11) Ordinal The order or position
Remarks text Remarks remarks
ConservEventID int(11) MUL
CreatedByAgentID int(11) MUL
AttachmentID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKD3F7CFA55327F942 ModifiedByAgentID
FKD3F7CFA57699B003 CreatedByAgentID
FKD3F7CFA5C7E55084 AttachmentID
FKD3F7CFA5F849E7A2 ConservEventID
PRIMARY ConservEventAttachmentID

Many-to-one relationships

Name Field Related table Related field
FKD3F7CFA55327F942 ModifiedByAgentID agent AgentID
FKD3F7CFA57699B003 CreatedByAgentID agent AgentID
FKD3F7CFA5C7E55084 AttachmentID attachment AttachmentID
FKD3F7CFA5F849E7A2 ConservEventID conservevent ConservEventID