nr_com

Standard comments table

Column Name Column Datatype Column Null Option Column Comment
id integer not null Primary key of this table
com_par_id byte(16) not null Asset. Foreign key to the id field of the ca_owned_resource table
com_dt integer not null Pointer to parent row (nr_did) dt comment written
com_userid nvarchar(40) not null Userid id of comment author
com_comment nvarchar(1000) with null Comment text
writer_id byte(16) with null Primary key. Unique identifier.
attr_name nvarchar(60) with null For ITIL, contains the Asset attribute that has changed
old_value nvarchar(1000) with null For ITIL, contains the old value of the Assets attribute that has changed
new_value nvarchar(1000) with null For ITIL, contains the new value of the Assets attribute that has changed

Product Name: Unicenter Service Desk

Table Type: Table


Copyright © 2006 CA. All rights reserved.