Reference > Database > WebSphere Commerce database tables > P
WebSphere Commerce database table: PATTRVALUE
The personalization attribute value table. This table holds the values associated with personalization attributes.
Column Name Column Type Description PATTRVALUE_ID BIGINT NOT NULL The internal reference number of the personalized attribute value. PATTRIBUTE_ID BIGINT NOT NULL The internal reference number of the personalized attribute. ATTRTYPE_ID CHAR(16) NOT NULL The data type of the Attribute. For example, STRING, INTEGER, FLOAT, DATETIME, FREEFORM, or BIGINT. OPERATOR_ID INTEGER NOT NULL The internal reference number of the Operator. The Operator determines the relationship between the Name and Value. For example, equal; not equal; or greater than;. TERMCOND_ID BIGINT The internal reference number of the TermAndCondition for this value. Only one of the columns ORDERITEMS_ID, TERMCOND_ID, RFQPROD_ID, or RFQRSPPROD_ID must be specified. QTYUNIT_ID CHAR(16) The internal reference number of the QTYUNIT. INTEGERVALUE INTEGER Contains the value if the data type of the Attribute is set to INTEGER. FLOATVALUE DOUBLE Contains the value if the data type of the Attribute is set to FLOAT. STRINGVALUE VARCHAR(254) Contains the value if the Attribute data type is set to STRING. DATEVALUE TIMESTAMP Contains the value if the data type of the Attribute is set to DATETIME. BIGINTVALUE BIGINT Contains the value if the data type of the Attribute is set to DOUBLE. SEQUENCE INTEGER Reserved for IBM internal use. ENCRYPTFLAG INTEGER NOT NULL DEFAULT 0 Set to 1 if personalized attribute value is encrypted. The default is 0. ORDERITEMS_ID BIGINT The order item that this personalized attribute value describes. MANDATORY INTEGER NOT NULL DEFAULT 0 Indicates whether the personalization attribute is mandatory or not. ATTACHMENT_ID BIGINT The internal reference number of the Attachment. CHANGEABLE INTEGER NOT NULL DEFAULT 0 Indicates whether the personalization attribute is changeable or not. RFQPROD_ID BIGINT The RFQ Product that this personalized attribute value describes. RFQRSPPROD_ID BIGINT The RFQ Response Product that this personalized attribute value describes. CORRELATIONGROUP BIGINT Any personalization attribute values that are part of the same group will have the same CORRELATIONGROUP values. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030407760 PATTRVALUE_ID Primary Key I0000354 TERMCOND_ID Non-Unique Index I0000355 RFQPROD_ID Non-Unique Index I0000356 RFQRSPPROD_ID Non-Unique Index I0000367 CORRELATIONGROUP Non-Unique Index I0000682 PATTRIBUTE_ID Non-Unique Index I0000683 ORDERITEMS_ID Non-Unique Index I0001270 ATTACHMENT_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1004 ATTACHMENT_ID ATTACHMENT ATTACHMENT_ID Cascade F_569 ATTRTYPE_ID ATTRTYPE ATTRTYPE_ID Cascade F_570 OPERATOR_ID OPERATOR OPERATOR_ID Cascade F_987 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade F_573 PATTRIBUTE_ID PATTRIBUTE PATTRIBUTE_ID Cascade F_572 QTYUNIT_ID QTYUNIT QTYUNIT_ID Cascade F_989 RFQPROD_ID RFQPROD RFQPROD_ID Cascade F_988 RFQRSPPROD_ID RFQRSPPROD RFQRSPPROD_ID Cascade F_571 TERMCOND_ID TERMCOND TERMCOND_ID Cascade
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_990 RFQRSPPATTRVAL_ID RFQRSPPARL PATTRVALUE_ID Cascade F_993 RFQPATTRVALUE_ID RFQRSPPARL PATTRVALUE_ID Cascade
Related reference
_vcc_freeselect_bottom_