ATTRTYPE
Type identifier for product attributes.
Column Descriptions:
Name Type Description ATTRTYPE_ID CHAR (16) NOT NULL The ID of the attribute type. Valid values: INTEGER, STRING, FLOAT, DATETIME, FREEFORM or BIGINT. Extended member attributes support the following data types only: INTEGER, STRING, DATETIME, or FLOAT. DESCRIPTION VARCHAR (254) The description of the attribute type. OID VARCHAR (64) 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> ATTRTYPE_ID Primary Key
Referenced By Child Tables:
Constraint Columns Child Table Child Columns Type F_3551 ATTRTYPE_ID ATTR ATTRTYPE_ID Cascade F_3557 ATTRTYPE_ID ATTRDESC ATTRTYPE_ID Cascade F_3681 ATTRTYPE_ID ATTRDICTSRCHCONF ATTRTYPE_ID Cascade F_3684 ATTRTYPE_ID CLSATTRSRCHCONF 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 F_70 ATTRTYPE_ID ATTRIBUTE ATTRTYPE_ID Cascade F_73 ATTRTYPE_ID ATTRVALUE ATTRTYPE_ID Cascade
Related reference
Attribute data model
Member data model
Request for Quote (RFQ) data model