Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ATTRVAL
This table holds an attribute value that can be a shaable global attribute value or a local attribute value defined for a catalog entry.
Column Name Column 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 attibute value. VALUSAGE INTEGER 1 - Predefined allowed value. (For example, one of the allowed values of Color is Blue) 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 Reserved IBM Internal Use
Indexes Index Name Indexed Column Names Index Type I0001205 ATTR_ID+IDENTIFIER Unique Index SQL100520030300260 ATTRVAL_ID Primary Key I0001206 ATTR_ID+STOREENT_ID+VALUSAGE Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_3554 ATTR_ID ATTR ATTR_ID Cascade F_3555 STOREENT_ID STOREENT STOREENT_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_3560 ATTRVAL_ID ATTRVALDESC ATTRVAL_ID Cascade F_3568 ATTRVAL_ID CATENTRYATTR ATTRVAL_ID Cascade _vcc_freeselect_bottom_