MBRATTRVAL

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

Column Descriptions:

NameTypeDescription
MBRATTRVAL_IDBIGINT NOT NULLPrimary key for this table.
STOREENT_IDINTEGERThe store entity to which this attribute value for this member applies.
MEMBER_IDBIGINT NOT NULLThe member to which this attribute value applies. Foreign key to the MEMBER table.
ATTRTYPE_IDCHAR (16) NOT NULLType of the member attribute value. Foreign key to the ATTRTYPE table.
MBRATTR_IDBIGINT NOT NULLThe attribute that this value is associated with. Foreign key to the MBRATTR table.
FLOATVALUEDOUBLEIf 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.
INTEGERVALUEINTEGERIf 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.
STRINGVALUEVARCHAR (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.
DATETIMEVALUETIMESTAMPIf 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.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>MBRATTRVAL_IDPrimary Key
I0000326MEMBER_ID+MBRATTR_IDNon-Unique Index
I0000327STOREENT_IDNon-Unique Index
I0000614MBRATTR_IDNon-Unique Index

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_439STOREENT_IDSTOREENTSTOREENT_IDCascade
F_440MEMBER_IDMEMBERMEMBER_IDCascade
F_441ATTRTYPE_IDATTRTYPEATTRTYPE_IDCascade
F_442MBRATTR_IDMBRATTRMBRATTR_IDCascade