Reference > Database > WebSphere Commerce database tables > M
WebSphere Commerce database table: MBRATTR
This table contains the custom member attributes available to be assigned to users and organizations.
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 SQL100520030353360 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
Referenced By Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type F_442 MBRATTR_ID MBRATTRVAL MBRATTR_ID Cascade
Related reference
_vcc_freeselect_bottom_