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:

Name	Type	Description
ACATTR_ID	BIGINT NOT NULL	The attribute ID. This is the primary key.
ATTRNAME	VARCHAR (128) NOT NULL	The name of this attribute. This has to be unique.
DATATYPE	INTEGER NOT NULL	The data type of this attribute. It is a foreign key to the REFID column in the ICDATAREG table.
FIELD1	VARCHAR (128)	This column is customizable.
OPTCOUNTER	SMALLINT NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	ACATTR_ID	Primary Key
I0000003	ATTRNAME	Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_8	DATATYPE	ICDATAREG	REFID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_10	ACATTR_ID	ACATTRDESC	ACATTR_ID	Cascade
F_40	ACATTR_ID	ACRESATREL	ACATTR_ID	Cascade