Reference > Database > WebSphere Commerce database tables > M
WebSphere Commerce database table: MBRATTRVAL
This table stores the values of attributes which are defined in the MBRATTR table for members.
Column Name Column Type Description 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.
Indexes Index Name Indexed Column Names Index Type SQL100520030353500 MBRATTRVAL_ID Primary Key I0000326 MEMBER_ID+MBRATTR_ID Non-Unique Index I0000327 STOREENT_ID Non-Unique Index I0000614 MBRATTR_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names 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
Related reference
_vcc_freeselect_bottom_