Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PKGATTRVAL
This table holds the values assigned to package attributes. Package attribute values are inherited from the attribute values of the products that are contained within packages.
Column Name Column Type Description PKGATTRVAL_ID BIGINT NOT NULL The internal reference number of the package attribute value. ATTRVALUE_ID BIGINT NOT NULL The reference to an attribute value of a product attribute. LANGUAGE_ID INTEGER NOT NULL The language that this attribute value pertains to. For a list of language components, see the LANGUAGE table. CATENTRY_ID BIGINT NOT NULL The package that this attribute value describes. OID CHAR(32) Reserved for IBM internal use. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000188 CATENTRY_ID+LANGUAGE_ID+ATTRVALUE_ID Unique Index SQL100520030409590 PKGATTRVAL_ID+LANGUAGE_ID Primary Key I0001272 ATTRVALUE_ID+LANGUAGE_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_593 ATTRVALUE_ID LANGUAGE_ID ATTRVALUE ATTRVALUE_ID Cascade F_592 CATENTRY_ID CATENTRY CATENTRY_ID Cascade F_591 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Related reference
_vcc_freeselect_bottom_