Database Table: MBRATTRVAL

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

Column Name Column Type Column Description
ATTRTYPE_ID CHARACTER (16)
NOT NULL
Type of the member attribute value. Foreign key to the ATTRTYPE table.
DATETIMEVALUE TIMESTAMP
NULL
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.
FLOATVALUE DOUBLE
NULL
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
NULL
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.
MBRATTRVAL_ID BIGINT
NOT NULL
Primary key for this table.
MBRATTR_ID BIGINT
NOT NULL
The attribute that this value is associated with. Foreign key to the MBRATTR table.
MEMBER_ID BIGINT
NOT NULL
The member to which this attribute value applies. Foreign key to the MEMBER table.
STOREENT_ID INTEGER
NULL
The store entity to which this attribute value for this member applies.
STRINGVALUE VARCHAR (4000)
NULL
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.
Indexes:
Index Name Indexed Column Names Index Type
I0000326 MEMBER_ID, MBRATTR_ID Non-Unique Index
I0000327 STOREENT_ID Non-Unique Index
SQL030416034956820 MBRATTRVAL_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint 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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable