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_


+

Search Tips   |   Advanced Search