WebSphere Commerce database table: ATTRTYPE

This table holds the type identifier for product Attributes.


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031159120 ATTRTYPE_ID Primary Key

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)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

Feedback