This table stores the attributes for a given resource on which it can be implicitly grouped. The metadata information about attributes is used in the GUI for defining resource groups and also for generating the SQL for prefiltering.
Column Name | Column Type | Column Description |
---|---|---|
ACATTR_ID | BIGINT NOT NULL |
Attribute ID. This is a Primary Key along with ACRESCGRY_ID. Foreign key to ACATTR_ID in the ACATTR table. |
ACRESCGRY_ID | INTEGER NOT NULL |
Resource category ID. This is a Primary Key along with the Attribute ID. Foreign key to ACRESCGRY_ID in the ACRESCGRY table. |
ATTRCOLNAME | VARCHAR (64) NOT NULL |
Metadata about attributes. This is the column name where this attribute is stored for a resource. |
ATTRTBLNAME | VARCHAR (64) NOT NULL |
Metadata about the attributes. This is the table name where this attribute can be found. |
FIELD1 | VARCHAR (128) NULL |
Customizable. |
RESKEYCOLNAME | VARCHAR (64) NOT NULL |
This is the column that stores the resource key in the table that stores the attribute. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034831590 | ACATTR_ID, ACRESCGRY_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_40 | ACATTR_ID | ACATTR | ACATTR_ID | Cascade |
F_41 | ACRESCGRY_ID | ACRESCGRY | ACRESCGRY_ID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|