Description
Contains detailed information on the attachments.
Dependencies
- Attachments table
- Bugs table
- Contacts table
- FunctionalSpecs table
- Persons table
- ProjectPlans table
- ProjectPlanTasks view
- Tasks table
- TestCases table
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 Text Feature.
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.
ProjId : int, allows null: no
The ID of the project related to the associated item.
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.
UserName : varchar (max 78 chars), allows null: yes
The name of the user who last updated the attachment, in the Last name, First name format.