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 |