Data Partition Constraints and Controlled Table

This article contains the following topics:
casm1401
This article contains the following topics:
Domain Table
Lists the names and descriptions of the data partitions themselves.
  • SQL Name
    -- dmn
  • Object
    -- dmn
Field
Data Type
Reference
Remarks
del
INTEGER
Active_Boolean_Table::enum
Specifies the Deleted flag, as follows:
0
-- Active
1
-- Inactive/marked as deleted
id
INTEGER
 
Primary key of 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.
nx_desc
nvarchar(40)
 
Identifies the data partition description.
persid
nvarchar(30)
 
Persistent ID (SystemObjectName:id).
sym
nvarchar(30)
 
Identifies the data partition name.
Domain_Constraint Table
Lists the constraints associated with a particular data partition and controlled table.
  • SQL Name
    -- dcon
  • Object
    -- dcon
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.
Domain_Constraint_Type Table
Lists the types of constraints that can be associated with a particular data partition and controlled table.
  • SQL Name
    -- dcon_typ
  • Object
    -- dcon_typ
Field
Data Type
Reference
Remarks
del
INTEGER
Active_Boolean_Table::enum
Specifies the Deleted flag, as follows:
0
-- Active
1
-- Inactive/marked as deleted
enum
INTEGER
 
Enumerated value for this entry, this specifies ordering in lists and relative values.
id
INTEGER
 
Indicates the unique (to the table) numeric ID.
nx_desc
nvarchar(40)
 
Specifies the description of the domain contraint type.
persid
nvarchar(30)
 
Persistent ID (SystemObjectName:id).
sym
nvarchar(12)
 
Identifies the symbolic name of this constraint type.