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. |
Index Name | Indexed Column Names | Index Type |
---|---|---|
SQL030416034838280 | ATTRTYPE_ID | Primary Key |
Constraint Name | Column Names | Foreign Table Name | Foreign Column Names | Constraint Type |
---|---|---|---|---|
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 |