Reference > Database > WebSphere Commerce database tables > A
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 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 SQL100520030252730 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
_vcc_freeselect_bottom_