Database Table: PATTRVALUE

The personalization Attribute Value table. This table holds the values associated with personalization attributes.

Column Name Column Type Column Description
ATTACHMENT_ID BIGINT
NULL
The internal reference number of the Attachment.
ATTRTYPE_ID CHARACTER (16)
NOT NULL
The data type of the Attribute. For example, STRING, INTEGER, FLOAT, DATETIME, FREEFORM, or BIGINT.
BIGINTVALUE BIGINT
NULL
Contains the Value if the data type of the Attribute is "DOUBLE".
CHANGEABLE INTEGER
NOT NULL, DEFAULT 0
Indicates whether the personalization attribute is changeable or not.
CORRELATIONGROUP BIGINT
NULL
Any personalization attribute values that are part of the same group will have the same CORRELATIONGROUP values.
DATEVALUE TIMESTAMP
NULL
Contains the value if the data type of the Attribute is "DATETIME".
ENCRYPTFLAG INTEGER
NOT NULL, DEFAULT 0
Set to 1 if personalized attribute value is encrypted. Default is 0.
FLOATVALUE DOUBLE
NULL
Contains the Value if the data type of the Attribute is "FLOAT".
INTEGERVALUE INTEGER
NULL
Contains the value if the data type of the Attribute is "INTEGER".
MANDATORY INTEGER
NOT NULL, DEFAULT 0
Indicates whether the personalization attribute is mandatory or not.
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;.
ORDERITEMS_ID BIGINT
NULL
The order item that this personalized attribute value describes.
PATTRIBUTE_ID BIGINT
NOT NULL
The internal reference number of the Personalized Attribute.
PATTRVALUE_ID BIGINT
NOT NULL
The internal reference number of the Personalized Attribute Value.
QTYUNIT_ID CHARACTER (16)
NULL
The internal reference number of the QTYUNIT.
RFQPROD_ID BIGINT
NULL
The RFQ Product that this personalized attribute value describes.
RFQRSPPROD_ID BIGINT
NULL
The RFQ Response Product that this personalized attribute value describes.
SEQUENCE INTEGER
NULL
Reserved for IBM internal use.
STRINGVALUE VARCHAR (254)
NULL
Contains the Value if the Attribute data type is "STRING".
TERMCOND_ID BIGINT
NULL
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.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416035028970 PATTRVALUE_ID Primary Key
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_571 TERMCOND_ID TERMCOND TERMCOND_ID Cascade
F_572 QTYUNIT_ID QTYUNIT QTYUNIT_ID Cascade
F_573 PATTRIBUTE_ID PATTRIBUTE PATTRIBUTE_ID Cascade
F_987 ORDERITEMS_ID ORDERITEMS ORDERITEMS_ID Cascade
F_988 RFQRSPPROD_ID RFQRSPPROD RFQRSPPROD_ID Cascade
F_989 RFQPROD_ID RFQPROD RFQPROD_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_990 PATTRVALUE_ID RFQRSPPARL RFQRSPPATTRVAL_ID Cascade
F_993 PATTRVALUE_ID RFQRSPPARL RFQPATTRVALUE_ID Cascade