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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000001 GROUPNAME Unique Index
SQL050212031151650 ACACTGRP_ID Primary Key
I0000427 MEMBER_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_7 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)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

Feedback