attachmenttag

Table info.

Title Attachment Tag
Description Attachment Tag

Fields

Name Type Required Index Hidden On form Title Pick list Description
AttachmentTagID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Tag varchar(64) Tag Name of tag.
AttachmentID int(11) MUL
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKA62FAF975327F942 ModifiedByAgentID
FKA62FAF977699B003 CreatedByAgentID
FKA62FAF97C7E55084 AttachmentID
PRIMARY AttachmentTagID

Many-to-one relationships

Name Field Related table Related field
FKA62FAF975327F942 ModifiedByAgentID agent AgentID
FKA62FAF977699B003 CreatedByAgentID agent AgentID
FKA62FAF97C7E55084 AttachmentID attachment AttachmentID