WebSphere Commerce database table: ACATTR
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 Descriptions
| Column Name
| Column 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
| Reserved for IBM internal use.
|
Indexes
| Index Name
| Indexed Column Names
| Index Type |
| I0000003
| ATTRNAME
| Unique Index
|
| SQL060903235112760
| ACATTR_ID
| Primary Key
|
Constraints
| 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
|
Related reference