Previous Topic: Domain TableNext Topic: Domain_Constraint_Type Table


Domain_Constraint Table

Lists the constraints associated with a particular data partition and controlled table.

Field

Data Type

Reference

Remarks

alias

INTEGER

 

Identifies the alias value for this Domain_Constraint.

constraint_majic

nvarchar
(4000)

 

Specifies Constraint (Majic).

constraint_ SQL

nvarchar
(4000)

 

Specifies Constraint (SQL).

del

INTEGER

Active_Boolean_
Table::enum

Indicates the Delete flag, as follows:
0—Active
1—inactive/marked as deleted)

dom_id

INTEGER

Domain::id

Identifies the unique (to the table) numeric ID.

error_msg

nvarchar
(150)

 

Specifies the message on violation.

id

INTEGER

 

Primary key to this table, it is a unique numeric ID.

last_mod_by

byte(16)

ca_contact::uuid

Specifies the UUID of the contact who last modified this record.

last_mod_dt

INTEGER

 

Indicates the timestamp of when this record was last modified.

persid

nvarchar(30)

 

Persistent ID (SystemObjectName:id).

tbl_id

INTEGER

ctab::id

Indicates the unique (to the table) numeric ID.

type

INTEGER

Domain_ Constraint_Type ::enum

Enumerated value for this entry, this specifies ordering in lists and relative values.