prp

Propertyvalue pairs for an object

Column Name Column Datatype Column Null Option Column Comment
id integer not null Primary key of this table
persid nvarchar(30) with null Persistent ID (SystemObjectName:id)
object_type nvarchar(30) not null short name of object to which this property belongs
object_id integer not null Unique (to the table) Numeric ID
sequence integer not null The sequence value for this Property.
property integer with null Template. Foreign key to the id field of the prptpl table.
value nvarchar(240) with null Value of the property
last_mod_dt integer with null Timestamp of when this record was last modified
last_mod_by byte(16) with null Specifies the UUID of the contact who last modified this record
required integer with null 0 = not req, 1 = required
sample nvarchar(240) with null The sample value for this Property.
description nvarchar(240) with null Textual description of this property
label nvarchar(80) with null The label value for this Property.

Product Name: Unicenter Service Desk

Table Type: Table


Copyright © 2006 CA. All rights reserved.