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:
Name | Type | Description |
ACATTR_ID | BIGINT NOT NULL | The 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_ID | INTEGER NOT NULL | The 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. |
ATTRTBLNAME | VARCHAR (64) NOT NULL | Metadata about the attributes. This is the table
name where this attribute can be found. |
ATTRCOLNAME | VARCHAR (64) NOT NULL | Metadata about attributes. This is the column
name where this attribute is stored for a resource. |
RESKEYCOLNAME | VARCHAR (64) NOT NULL | This is the column that stores the resource key
in the table that stores the attribute. |
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+ACRESCGRY_ID | Primary Key |
I0000444 | ACRESCGRY_ID | Non-Unique Index |
Constrained By Parent Tables:
Constraint | Columns | Parent Table | Parent Columns | Type |
F_40 | ACATTR_ID | ACATTR | ACATTR_ID | Cascade |
F_41 | ACRESCGRY_ID | ACRESCGRY | ACRESCGRY_ID | Cascade |