ATTRIBUTE
This table holds catalog entry attributes used for descriptive or SKU resolution purposes. An attribute stored in this table is for a single catalog entry and is not shared between catalog entries. Attribute dictionary attributes are stored in the ATTR table.
Column Descriptions:
Name Type Description ATTRIBUTE_ID BIGINT NOT NULL The internal reference number of the attribute. LANGUAGE_ID INTEGER NOT NULL The language to which this attribute pertains to For a list of language components, see the LANGUAGE table. ATTRTYPE_ID CHAR (16) NOT NULL The type of the corresponding attribute value. Foreign key to the ATTRTYPE table. NAME VARCHAR (254) The name given to this attribute. SEQUENCE DOUBLE NOT NULL DEFAULT 0 A sequence number that determines the display order of attributes for a given product. DESCRIPTION VARCHAR (254) The attribute description. CATENTRY_ID BIGINT The reference number of the product to which this attribute belongs. DESCRIPTION2 VARCHAR (254) An additional description field for this attribute. FIELD1 VARCHAR (254) Customizable. OID VARCHAR (64) Reserved for IBM internal use. USAGE CHAR (1) DEFAULT '1' A code that represents the purpose of the attribute. NULL or "1" indicates SKU-resolution. "2" indicates a descriptive attribute and should not be used to resolve SKUs. The values NULL and "0" through "9" are reserved for IBM internal use. QTYUNIT_ID CHAR (16) The units in which this attribute is measured. GROUPNAME VARCHAR (64) Specifies the name of the group of attributes. All related attributes should be created with the same group name. NOTEINFO VARCHAR (64) Auxiliary attribute data such as a footnote. MULTITYPE CHAR (1) Reserved for IBM internal use. 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> ATTRIBUTE_ID+LANGUAGE_ID Primary Key I0000019 CATENTRY_ID+LANGUAGE_ID+NAME Unique Index I0000298 GROUPNAME+SEQUENCE Non-Unique Index
Constrained By Parent Tables:
Constraint Columns Parent Table Parent Columns Type F_1018 QTYUNIT_ID QTYUNIT QTYUNIT_ID Cascade F_69 CATENTRY_ID CATENTRY CATENTRY_ID Cascade F_70 ATTRTYPE_ID ATTRTYPE ATTRTYPE_ID Cascade F_71 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Referenced By Child Tables:
Constraint Columns Child Table Child Columns Type F_590 ATTRIBUTE_ID+LANGUAGE_ID PKGATTR ATTRIBUTE_ID+LANGUAGE_ID Cascade F_75 ATTRIBUTE_ID+LANGUAGE_ID ATTRVALUE ATTRIBUTE_ID+LANGUAGE_ID Cascade
Related reference
Attribute data model
Package data model