Description
For any item that has attachments uploaded, the Attachments table identifies the item by the ID and entity code, and identifies the associated file by FileName and FileNameZipped. The actual attachments are stored in the system, and the Attachments table tells the system what attachment is related to what item.
Columns
The table contains the following columns:
AttachmentId : int, allows null: no, default: auto-generated
The unique numeric identifier of the item.
AttachmentTypeCode : varchar (max 100 chars), allows null: no
The column is reserved for system use only.
Comments : varchar (max 8000 chars), allows null: yes
The attachment comments, as displayed on the Files tab.
This column corresponds to a field that can be available for rich editing.
DateCreated : datetime, allows null: yes, default: Current date and time
The date the attachment was first uploaded.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
DateUpdated : datetime, allows null: yes, default: Current date and time
The date the attachment was reuploaded.
The stored date and time are based on the server’s time zone. For more information, see Date and Time Fields.
EntityCode : varchar (max 100 chars), allows null: no
The type of the item with which the attachment is associated.
You can find correspondences between entity code values and related modules or features in Table of Entity Code Values.
FileFormatCode : varchar (max 100 chars), allows null: no, default: N/A
The type of the file, such as Image, Other, and so on.
FileName : varchar (max 255 chars), allows null: no
The attachment’s file name.
FileNameZipped : varchar (max 255 chars), allows null: no
The attachment’s zipped file name.
FKId : int, allows null: no
The ID of the item the attachment is associated with.
IsInternalUseOnly : varchar (max 1 char), allows null: yes
The column is reserved for system use only.
Seq : int, allows null: no, default: 0
The sequence of the attachment, as it appears on the Files tab of the associated item.
Title : varchar (max 255 chars), allows null: no
The attachment title, as displayed on the Files tab.
UpdateUserId : int, allows null: yes
The ID of the user who last updated the attachment info.