Description
The table contains additional information for other records on other core tables, in a one-to-one relationship. For example, a record on the Tests table will have one record on the ExtendedAttributes table.
Not all columns are used by all modules.
Columns
The table contains the following columns:
ExtendedAttributeId : int, primary key, allows null: no, default: Auto filled unique identifier
The unique numeric identifier of the item.
AssignedToName : varchar (max 78 chars), allows null: yes
The name of the user to whom the associated item is assigned, in the Last name, First name format.
AssigneeUserId : int, allows null: yes
The ID of the user to whom the associated item is assigned.
ClosedBy : int, allows null: yes
The ID of the user who closed the associated item.
ClosedByName : varchar (max 78 chars), allows null: yes
The name of the user who closed the associated item, in the Last name, First name format.
DateLastEscalated : datetime, allows null: yes
The date when the associated item was last affected by an escalation rule.
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, default: Module name of the related record
The name of the module that contains the associated item.
You can find correspondences between entity code values and related modules and features in Table of Entity Code Values.
FKId : int, allows null: no, default: Unique identifier of the related record (1:1 relationship)
The unique numeric identifier of the associated item.
FolderId : int, allows null: yes
The numeric identifier of the folder where the associated item is located.
FolderName : varchar (max 511 chars), allows null: yes
The name of the folder where the associated item is located.
LastEscalationRule : varchar (max 100 chars), allows null: yes
The name of the escalation rule that last affected the associated item.
LastEscalationRuleId : int, allows null: yes
The ID of the escalation rule that last affected the associated item.
LatestNotes : varchar (max), allows null: yes
A description of the latest note attached to the associated item.
NbrEscalations : int, allows null: yes
The number of times an escalation rule affected the associated item.
NbrEvents : int, allows null: yes
The number of events attached to the associated item.
NbrFiles : int, allows null: yes
The number of files attached to the associated item.
NbrFilesNotSecured : int, allows null: yes
The column is reserved for system use only.
NbrNotes : int, allows null: yes
The number of notes attached to the associated item.
NbrTasks : int, allows null: yes
The number of tasks attached to the associated item.
OpenedBy : int, allows null: yes
The ID of the user who added the associated item.
OpenedByName : varchar (max 78 chars), allows null: yes
The name of the user who added the associated item, in the Last name, First name format.
OwnerName : varchar (max 78 chars), allows null: yes
The name of the user who owns the associated item, in the Last name, First name format.
OwnerUserId : int, allows null: yes
The ID of the user who owns the associated item.
ResolvedBy : int, allows null: yes
The ID of the user who resolved the associated item.
ResolvedByName : varchar (max 78 chars), allows null: yes
The name of the user who resolved the associated item, in the Last name, First name format.
UpdateUserId : int, allows null: yes
The ID of the user who last updated the associated item.
UserName : varchar (max 78 chars), allows null: yes
The name of the user who last updated the associated item, in the Last name, First name format.