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 Descriptions
Column Name Column Type Description
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.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235116150 ACPOLICY_ID+ACPOLGRP_ID Primary Key
I0000438 ACPOLGRP_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1011 ACPOLGRP_ID ACPOLGRP ACPOLGRP_ID Cascade
F_1010 ACPOLICY_ID ACPOLICY ACPOLICY_ID Cascade
Related reference