WebSphere Commerce database table: MBRATTR

This table contains an attribute definition dictionary for members.


Column Description(s):
Column NameColumn TypeDescription
MBRATTR_ID BIGINT NOT NULL Primary key of this MBRATTR table.
ATTRTYPE_ID CHAR(16) NOT NULL Type of the member attribute. Foreign key to the ATTRTYPE table.
NAME VARCHAR(254) NOT NULL Name of the member attribute.
DESCRIPTION VARCHAR(254) Description of the member attribute.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000151 NAME Unique Index
SQL050212031238010 MBRATTR_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_438 ATTRTYPE_ID ATTRTYPE ATTRTYPE_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_442 MBRATTR_ID MBRATTRVAL MBRATTR_ID Cascade

Feedback