WebSphere Commerce database table: ATTRTYPE

This table holds the type identifier for product attributes.

Column Descriptions
Column Name Column Type Description
ATTRTYPE_ID CHAR(16) NOT NULL The ID of the attribute type. Valid values: INTEGER, STRING, FLOAT, DATETIME, FREEFORM or BIGINT.
DESCRIPTION VARCHAR(254) The description of the attribute type.
OID VARCHAR(64) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235127910 ATTRTYPE_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_70 ATTRTYPE_ID ATTRIBUTE ATTRTYPE_ID Cascade
F_73 ATTRTYPE_ID ATTRVALUE ATTRTYPE_ID Cascade
F_438 ATTRTYPE_ID MBRATTR ATTRTYPE_ID Cascade
F_441 ATTRTYPE_ID MBRATTRVAL ATTRTYPE_ID Cascade
F_566 ATTRTYPE_ID PATTRIBUTE ATTRTYPE_ID Cascade
F_569 ATTRTYPE_ID PATTRVALUE ATTRTYPE_ID Cascade
Related reference