agentattachment

Table info.

Title Agent Attachment
Description Agent Attachment

Fields

Name Type Required Index Hidden On form Title Pick list Description
AgentAttachmentID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Ordinal int(11) Ordinal This allows the attachments to be ordered.
Remarks text Remarks Additional comments.
CreatedByAgentID int(11) MUL
AttachmentID int(11) MUL
AgentID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK56FE59E8384B3622 AgentID
FK56FE59E85327F942 ModifiedByAgentID
FK56FE59E87699B003 CreatedByAgentID
FK56FE59E8C7E55084 AttachmentID
PRIMARY AgentAttachmentID

Many-to-one relationships

Name Field Related table Related field
FK56FE59E8384B3622 AgentID agent AgentID
FK56FE59E85327F942 ModifiedByAgentID agent AgentID
FK56FE59E87699B003 CreatedByAgentID agent AgentID
FK56FE59E8C7E55084 AttachmentID attachment AttachmentID