WebSphere Commerce database table: ACCMBRGRP

This table is used to assign an administrative user to various access groups for a particular store owner. This table is deprecated and is provided for backward compatibility only.

Column Descriptions

Column Name	Column Type	Description
MBRGRP_ID	BIGINT NOT NULL	This column defines the member group that a user belongs to. The values that are valid are defined in the MBRGRP table.
USERS_ID	BIGINT NOT NULL	This column defines an administrative user in the USERS table.
OWNER_ID	BIGINT NOT NULL	This column defines the resource owner ID. A value of 0 indicates that the user belongs to the MBRGRP_ID for all owners.
FIELD1	VARCHAR(254)	Reserved for IBM internal use.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
SQL060903235114140	USERS_ID+MBRGRP_ID+OWNER_ID	Primary Key
I0000432	MBRGRP_ID	Non-Unique Index
I0000433	OWNER_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_20	MBRGRP_ID	MBRGRP	MBRGRP_ID	Cascade
F_19	OWNER_ID	MEMBER	MEMBER_ID	Cascade
F_21	USERS_ID	USERS	USERS_ID	Cascade