dcon

Domain Constraint definitions

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)
del integer not null Deleted flag (0=active 1=inactive/marked as deleted)
alias integer with null The alias value for this Domain_Constraint.
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
dom_id integer not null Unique (to the table) Numeric ID
tbl_id integer not null Unique (to the table) Numeric ID
type integer not null Enumerated value for this entry - specifies ordering in lists and relative values
constraint_majic nvarchar(4000) with null Constraint (Majic)
constraint_sql nvarchar(4000) with null Constraint (SQL)
error_msg nvarchar(150) with null Message on violation

Product Name: Unicenter Service Desk

Table Type: Table


Copyright © 2006 CA. All rights reserved.