attachmentmetadata

Table info.

Title Attachment MetadataMetadados
Description Attachment MetadataMetadados

Fields

Name Type Required Index Hidden On form Title Pick list Description
AttachmentMetadataID int(11) PRI
TimestampCreated datetime Timestamp Created The timestamp the record was created.
TimestampModified datetime Timestamp Modified The timestamp the record was last modified.
Version int(11) Version version
Name varchar(64) Name The name of the meta data field.
Value varchar(128) Value The value of the meta data field.
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
AttachmentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK991701525327F942 ModifiedByAgentID
FK991701527699B003 CreatedByAgentID
FK99170152C7E55084 AttachmentID
PRIMARY AttachmentMetadataID

Many-to-one relationships

Name Field Related table Related field
FK991701525327F942 ModifiedByAgentID agent AgentID
FK991701527699B003 CreatedByAgentID agent AgentID
FK99170152C7E55084 AttachmentID attachment AttachmentID