Description
The audits table stores the history of changes made by users.
Columns
The table contains the following columns:
DateCreated : datetime, allows null: no, default: Current date and time
The date and time the change was made.
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 code of the module where the change was made.
You can find correspondences between entity code values and related modules and features in Table of Entity Code Values.
FKId : int, allows null: no
The unique numeric identifier of the changed item.
NewValue : varchar (max 1000 chars), allows null: yes
The new value.
This column may correspond to a field that is available for rich editing.
OldValue : varchar (max 1000 chars), allows null: yes
The original value that was changed.
This column may correspond to a field that is available for rich editing.
ProjId : int, allows null: no
The ID of the project that contains the item.
Title : varchar (max 100 chars), allows null: no
The description of the change.
UpdateUserId : int, allows null: no
The ID of the user who made the change.