attr_name

nvarchar(60)

For ITIL, this contains the Asset attribute that has changed.

com_comment

nvarchar(1000)

Identifies the comment text.

com_dt

INTEGER

Acts as the pointer to the parent row (nr_did), for the dt_ comment written.

com_par_id

byte(16)

ca_owned_ resource::uuid

Foreign key to the id field of the ca_owned_resource table, this is the Asset.

com_userid

nvarchar(40)

Identifies the userid of the commenting author.

id

INTEGER

Primary key of this table, this is a unique numeric ID.

new_value

nvarchar(1000)

For ITIL, this contains the new value of the Asset's attribute that has changed.

old_value

nvarchar(1000)

For ITIL, this contains the old value of the Asset's attribute that has changed.

writer_id

byte(16)

Primary key to the table, this is a unique identifier.