ACRESATREL

This table stores the relationship between access control resources and attributes. These attributes are used to implicitly group resources. Given a resource, you can find out the supported attributes from this table. The metadata information about attributes is used in the GUI for defining resource groups and also for generating the SQL statements for filtering.

Column Descriptions:

NameTypeDescription
ACATTR_IDBIGINT NOT NULLThe attribute ID. It is a foreign key to the ACATTR_ID column in the ACATTR table. Together with the ACRESCGRY_ID column, it forms a primary key.
ACRESCGRY_IDINTEGER NOT NULLThe resource category ID. It is a foreign key to the ACRESCGRY_ID column in the ACRESCGRY table. Together with ACATTR_ID column, it forms a primary key.
ATTRTBLNAMEVARCHAR (64) NOT NULLMetadata about the attributes. This is the table name where this attribute can be found.
ATTRCOLNAMEVARCHAR (64) NOT NULLMetadata about attributes. This is the column name where this attribute is stored for a resource.
RESKEYCOLNAMEVARCHAR (64) NOT NULLThis is the column that stores the resource key in the table that stores the attribute.
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_ID+ACRESCGRY_IDPrimary Key
I0000444ACRESCGRY_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_40ACATTR_IDACATTRACATTR_IDCascade
F_41ACRESCGRY_IDACRESCGRYACRESCGRY_IDCascade