ModLogTable

(PK) ModTableKey

int NOT NULL

The unique numerical identifier for the modification. This value is automatically generated by the system when a new modification record is added.

(FK) id

int NOT NULL

The unique identifier for the object that was modified. id is a foreign key from the HistorianSysObjects table.

ModType

char(1) NOT NULL

The type of modification. U = Update; I = Insert; D = Delete; 1 = SQL insert; 2 = SQL original insert; 3 = SQL update; 4 = CSV insert; 5 = CSV original insert; 6 = CSV update; 7 = CSV multi-point update; 8 = CSV "fast load" insert.

RowKey

sql_variant NOT NULL

The key identifier for the column modified in the table. For example, TagName for the Tag table, Name for the Topic table, and so on.

UserKey

int NOT NULL

The unique numerical identifier for a database user as defined in the UserDetail table. This value is from the UserDetail table. Currently not used.

DateTime

datetime2(7) NOT NULL

The timestamp of when the modification occurred.

UserName

nvarchar(256) NOT NULL

The name of the database user that made the modification. The value of this column reflects the Windows authentication user name (for example, DOMAIN\user_login_name) or the SQL Server authentication user name (for example, dbo), depending on how the user is logged into the SQL Server when the modification is made. In the case of a CSV file import, this column contains the user name as it appears in the CSV file.