WebSphere Commerce database table: ACPOLGRP

This table stores all the access control policy groups in the system. Each row in this table represents a policy group.


Column Description(s):
Column NameColumn TypeDescription
ACPOLGRP_ID INTEGER NOT NULL The generated unique ID of this access control policy group record.
NAME VARCHAR(128) NOT NULL The name of the access control policy group.
MEMBER_ID BIGINT NOT NULL The member ID of the owner of the access control policy group. It is a foreign key to the MEMBER table.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
I0000306 NAME+MEMBER_ID Unique Index
SQL050212031153870 ACPOLGRP_ID Primary Key
I0000439 MEMBER_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1005 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint NameReferenced Column NameForeign Table NameForeign Column Name(s)Constraint Type
F_1009 ACPOLGRP_ID ACPLGPDESC ACPOLGRP_ID Cascade
F_1012 ACPOLGRP_ID ACPLGPSUBS ACPOLGRP_ID Cascade
F_1011 ACPOLGRP_ID ACPOLGPPOL ACPOLGRP_ID Cascade
F_1006 PARENT_ID ACPOLSUBGP ACPOLGRP_ID Cascade
F_1007 CHILD_ID ACPOLSUBGP ACPOLGRP_ID Cascade

Feedback