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:

Name	Type	Description
ATTRVAL_ID	BIGINT NOT NULL	The unique identifier for this attribute value.
ATTR_ID	BIGINT NOT NULL	The reference number of the attribute to which this attribute value applies.
IDENTIFIER	VARCHAR (254)	An external identifier for the attribute value.
VALUSAGE	INTEGER	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_ID	INTEGER NOT NULL	The reference number of the store entity to which this attribute belongs.
FIELD1	INTEGER	Customizable.
FIELD2	INTEGER	Customizable.
FIELD3	VARCHAR (254)	Customizable.
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>	ATTRVAL_ID	Primary Key
I0001205	ATTR_ID+IDENTIFIER	Unique Index
I0001206	ATTR_ID+STOREENT_ID+VALUSAGE	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_3554	ATTR_ID	ATTR	ATTR_ID	Cascade
F_3555	STOREENT_ID	STOREENT	STOREENT_ID	Cascade

Referenced By Child Tables:

Constraint	Columns	Child Table	Child Columns	Type
F_3560	ATTRVAL_ID	ATTRVALDESC	ATTRVAL_ID	Cascade
F_3568	ATTRVAL_ID	CATENTRYATTR	ATTRVAL_ID	Cascade
F_3672	ATTRVAL_ID	CFCONDVAL	ATTRVAL_ID	Cascade