WebSphere Commerce database table: ACPOLGPPOL

This table stores the association between access control policy groups and access control policies. An access control policy that belongs to a policy group will be applied to all the organizations that subscribe to that policy group.


Column Description(s):
Column NameColumn TypeDescription
ACPOLICY_ID INTEGER NOT NULL The ID of the access control policy. It is a foreign key to the ACPOLICY table.
ACPOLGRP_ID INTEGER NOT NULL The ID of the access control policy group to which the access control policy belongs. It is a foreign key to the ACPOLGRP table.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031153750 ACPOLICY_ID+ACPOLGRP_ID Primary Key
I0000438 ACPOLGRP_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1011 ACPOLGRP_ID ACPOLGRP ACPOLGRP_ID Cascade
F_1010 ACPOLICY_ID ACPOLICY ACPOLICY_ID Cascade

Feedback