ATTRTYPE

This table holds the type identifier for product attributes.

Column Descriptions:

NameTypeDescription
ATTRTYPE_IDCHAR (16) NOT NULLThe ID of the attribute type. Valid values: INTEGER, STRING, FLOAT, DATETIME, FREEFORM or BIGINT.
DESCRIPTIONVARCHAR (254)The description of the attribute type.
OIDVARCHAR (64)Reserved for IBM internal use.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ATTRTYPE_IDPrimary Key

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3551ATTRTYPE_IDATTRATTRTYPE_IDCascade
F_3557ATTRTYPE_IDATTRDESCATTRTYPE_IDCascade
F_3681ATTRTYPE_IDATTRDICTSRCHCONFATTRTYPE_IDCascade
F_3684ATTRTYPE_IDCLSATTRSRCHCONFATTRTYPE_IDCascade
F_438ATTRTYPE_IDMBRATTRATTRTYPE_IDCascade
F_441ATTRTYPE_IDMBRATTRVALATTRTYPE_IDCascade
F_566ATTRTYPE_IDPATTRIBUTEATTRTYPE_IDCascade
F_569ATTRTYPE_IDPATTRVALUEATTRTYPE_IDCascade
F_70ATTRTYPE_IDATTRIBUTEATTRTYPE_IDCascade
F_73ATTRTYPE_IDATTRVALUEATTRTYPE_IDCascade