Reference > Database > WebSphere Commerce database tables > A


WebSphere Commerce database table: ACCMBRGRP

This table is deprecated and is provided for backward compatibility only.

Column Name Column Type Description
MBRGRP_ID BIGINT NOT NULL Reserved for IBM internal use.
USERS_ID BIGINT NOT NULL Reserved for IBM internal use.
OWNER_ID BIGINT NOT NULL Reserved for IBM internal use.
FIELD1 VARCHAR(254) Reserved for IBM internal use.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030251850 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

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search