Reference > Database > WebSphere Commerce database tables > S
WebSphere Commerce database table: STOREMBRGP
Each row of this table indicates that a Store recognizes a MemberGroup as a customer group.
Column Name Column Type Description MBRGRP_ID BIGINT NOT NULL The MemberGroup. STORE_ID INTEGER NOT NULL The Store. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030434540 MBRGRP_ID+STORE_ID Primary Key I0000793 STORE_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_801 MBRGRP_ID MBRGRP MBRGRP_ID Cascade F_802 STORE_ID STORE STORE_ID Cascade
Related reference
- Calculation rule - discount data model
- Store data model
- Offers data model
- Calculation rule data model
- Calculation code data model
_vcc_freeselect_bottom_