ATTRVAL

This table holds an attribute value that can be a shareable global attribute value or a local attribute value defined for a catalog entry.

Column Descriptions:

NameTypeDescription
ATTRVAL_IDBIGINT NOT NULLThe unique identifier for this attribute value.
ATTR_IDBIGINT NOT NULLThe reference number of the attribute to which this attribute value applies.
IDENTIFIERVARCHAR (254)An external identifier for the attribute value.
VALUSAGEINTEGER
1
Predefined allowed value. (For example, one of the allowed values of Color is Blue)
2
Default predefined allowed value (When assign attribute to catalog entry, default predefined allowed value will be selected by default)
null
Assigned attribute value. (For example Product's Length is 30. Length attribute does not have allowed values).
STOREENT_IDINTEGER NOT NULLThe reference number of the store entity to which this attribute belongs.
FIELD1INTEGERCustomizable.
FIELD2INTEGERCustomizable.
FIELD3VARCHAR (254)Customizable.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The 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>ATTRVAL_IDPrimary Key
I0001205ATTR_ID+IDENTIFIERUnique Index
I0001206ATTR_ID+STOREENT_ID+VALUSAGENon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_3554ATTR_IDATTRATTR_IDCascade
F_3555STOREENT_IDSTOREENTSTOREENT_IDCascade

Referenced By Child Tables:

ConstraintColumnsChild TableChild ColumnsType
F_3560ATTRVAL_IDATTRVALDESCATTRVAL_IDCascade
F_3568ATTRVAL_IDCATENTRYATTRATTRVAL_IDCascade
F_3672ATTRVAL_IDCFCONDVALATTRVAL_IDCascade