Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PKGATTR
This table holds package attributes. Package attributes are inherited from the attributes of the products that are contained within packages.
Column Name Column Type Description PKGATTR_ID BIGINT NOT NULL The internal reference number of the package attribute. ATTRIBUTE_ID BIGINT NOT NULL The reference to an attribute of a product that is contained within the package. LANGUAGE_ID INTEGER NOT NULL The language that this attribute pertains to. For a list of language components, see the LANGUAGE table. CATENTRY_ID BIGINT The reference number of the package. OID CHAR(32) Reserved for IBM internal use. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type I0000187 CATENTRY_ID+LANGUAGE_ID+ATTRIBUTE_ID Unique Index SQL100520030409420 PKGATTR_ID+LANGUAGE_ID Primary Key I0001271 ATTRIBUTE_ID+LANGUAGE_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_590 ATTRIBUTE_ID LANGUAGE_ID ATTRIBUTE ATTRIBUTE_ID Cascade F_588 CATENTRY_ID CATENTRY CATENTRY_ID Cascade F_589 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Related reference
_vcc_freeselect_bottom_