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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000003 ATTRNAME Unique Index
SQL050212031151940 ACATTR_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_8 DATATYPE ICDATAREG REFID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_10 ACATTR_ID ACATTRDESC ACATTR_ID Cascade
F_40 ACATTR_ID ACRESATREL ACATTR_ID Cascade

Feedback