ACATTR

This table stores all the access control policies in the system. Every policy refers to an action group, a member group, a resource group and optionally, a relationship.

Column Descriptions:

NameTypeDescription
ACATTR_IDBIGINT NOT NULLThe attribute ID. This is the primary key.
ATTRNAMEVARCHAR (128) NOT NULLThe name of this attribute. This has to be unique.
DATATYPEINTEGER NOT NULLThe data type of this attribute. It is a foreign key to the REFID column in the ICDATAREG table.
FIELD1VARCHAR (128)This column is customizable.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ACATTR_IDPrimary Key
I0000003ATTRNAMEUnique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_8DATATYPEICDATAREGREFIDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_10ACATTR_IDACATTRDESCACATTR_IDCascade
F_40ACATTR_IDACRESATRELACATTR_IDCascade