This table is a master list of the attributes based on which some resources can be grouped. These attributes can be used to form implicit groups of resources.
Column Name | Column Type | Column Description |
---|---|---|
ACATTR_ID | BIGINT NOT NULL |
Attribute ID. This is the Primary Key. |
ATTRNAME | VARCHAR (128) NOT NULL |
Name of this attribute. This has to be unique. |
DATATYPE | INTEGER NOT NULL |
The data type of this attribute. Foreign key to the REFID in ICDATAREG. |
FIELD1 | VARCHAR (128) NULL |
Customizable. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
I0000003 | ATTRNAME | Unique Index |
SQL030416034824650 | ACATTR_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_8 | DATATYPE | ICDATAREG | REFID | Cascade |
Constraint Name | Referenced Column Name | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
F_10 | ACATTR_ID | ACATTRDESC | ACATTR_ID | Cascade |
F_40 | ACATTR_ID | ACRESATREL | ACATTR_ID | Cascade |