MBRATTRVAL

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

Column Descriptions:

Name	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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	MBRATTRVAL_ID	Primary Key
I0000326	MEMBER_ID+MBRATTR_ID	Non-Unique Index
I0000327	STOREENT_ID	Non-Unique Index
I0000614	MBRATTR_ID	Non-Unique Index

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_439	STOREENT_ID	STOREENT	STOREENT_ID	Cascade
F_440	MEMBER_ID	MEMBER	MEMBER_ID	Cascade
F_441	ATTRTYPE_ID	ATTRTYPE	ATTRTYPE_ID	Cascade
F_442	MBRATTR_ID	MBRATTR	MBRATTR_ID	Cascade

Related reference
Member data model