WebSphere Commerce database table: ACACTGRP

This table stores all the access control action groups. An action group can contain one or more actions. The association between actions and action groups is captured in the ACACTACTGP table.

Column Descriptions

Column Name	Column Type	Description
ACACTGRP_ID	INTEGER NOT NULL	The action group ID. This is a primary key.
GROUPNAME	VARCHAR(128) NOT NULL	The name of the action group.
MEMBER_ID	BIGINT NOT NULL	The foreign key to the MEMBER table for the owner of this action group. All action groups should be owned by the root organization.
FIELD1	VARCHAR(128)	This column is customizable.
OPTCOUNTER	SMALLINT	Reserved for IBM internal use.

Indexes

Index Name	Indexed Column Names	Index Type
I0000001	GROUPNAME	Unique Index
SQL060903235112460	ACACTGRP_ID	Primary Key
I0000427	MEMBER_ID	Non-Unique Index

Constraints

Constraint Name	Column Names	Foreign Table Name	Foreign Column Names	Constraint Type
F_7	MEMBER_ID	MEMBER	MEMBER_ID	Cascade

Constraint Name	Referenced Column Name	Foreign Table Name	Foreign Column Names	Constraint Type
F_2	ACACTGRP_ID	ACACGPDESC	ACACTGRP_ID	Cascade
F_3	ACACTGRP_ID	ACACTACTGP	ACACTGRP_ID	Cascade
F_32	ACACTGRP_ID	ACPOLICY	ACACTGRP_ID	Cascade

Related reference

• Access control data model