Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ATTRTYPE
This table holds the type identifier for product attributes.
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 SQL100520030300030 ATTRTYPE_ID Primary Key
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3551 ATTRTYPE_ID ATTR ATTRTYPE_ID Cascade F_3557 ATTRTYPE_ID ATTRDESC ATTRTYPE_ID Cascade 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
_vcc_freeselect_bottom_