Database Table: ATTRTYPE

This table holds the type identifier for product Attributes.

Column Name Column Type Column Description
ATTRTYPE_ID CHARACTER (16)
NOT NULL
The ID of the Attribute Type. Valid values: INTEGER, STRING, FLOAT, DATETIME, FREEFORM or BIGINT.
DESCRIPTION VARCHAR (254)
NULL
The description of the Attribute Type.
OID VARCHAR (64)
NULL
Reserved for IBM internal use.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034838280 ATTRTYPE_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
Not Applicable

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
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