WebSphere Commerce database table: MBRATTRVAL

This table stores the values of attributes which are defined in the MBRATTR table for members.


Column Description(s):
Column NameColumn TypeDescription
MBRATTRVAL_ID BIGINT NOT NULL Primary key for this table.
STOREENT_ID INTEGER The store entity to which this attribute value for this member applies.
MEMBER_ID BIGINT NOT NULL The member to which this attribute value applies. Foreign key to the MEMBER table.
ATTRTYPE_ID CHAR(16) NOT NULL Type of the member attribute value. Foreign key to the ATTRTYPE table.
MBRATTR_ID BIGINT NOT NULL The attribute that this value is associated with. Foreign key to the MBRATTR table.
FLOATVALUE DOUBLE If the type of the attribute value is FLOAT, then this column will hold the attribute value. If the type is not FLOAT then this column will be NULL.
INTEGERVALUE INTEGER If the type of the attribute value is INTEGER, then this column will hold the attribute value. If the type is not INTEGER then this column will be NULL.
STRINGVALUE VARCHAR(4000) If the type of the attribute value is STRING, then this column will hold the attribute value. If the type is not STRING then this column will be NULL.
DATETIMEVALUE TIMESTAMP If the type of the attribute value is TIMESTAMP, then this column will hold the attribute value. If the type is not TIMESTAMP then this column will be NULL.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031238160 MBRATTRVAL_ID Primary Key
I0000326 MEMBER_ID+MBRATTR_ID Non-Unique Index
I0000327 STOREENT_ID Non-Unique Index
I0000614 MBRATTR_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_441 ATTRTYPE_ID ATTRTYPE ATTRTYPE_ID Cascade
F_442 MBRATTR_ID MBRATTR MBRATTR_ID Cascade
F_440 MEMBER_ID MEMBER MEMBER_ID Cascade
F_439 STOREENT_ID STOREENT STOREENT_ID Cascade

Feedback