WebSphere Commerce database table: MBRATTR

This table contains an attribute definition dictionary for members.

Column Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
I0000151 NAME Unique Index
SQL060903235212300 MBRATTR_ID Primary Key

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_438 ATTRTYPE_ID ATTRTYPE ATTRTYPE_ID Cascade

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_442 MBRATTR_ID MBRATTRVAL MBRATTR_ID Cascade
Related reference