Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ACPLGPSUBS
This table stores the association between access control policy groups and organizational entities. An organizational entity that is associated with a policy group is said to subscribe to that policy group. The access control policies belonging to that policy group will apply to that organization. An organization can subscribe to multiple policy groups and multiple organizations can subscribe to the same policy group.
Column Name Column Type Description ACPOLGRP_ID INTEGER NOT NULL The ID of the access control policy group to which the organizational entity is subscribing. It is a foreign key to ACPOLGRP table. ORGENTITY_ID BIGINT NOT NULL The organizational entity ID of the organization that is subscribing to a policy group. It is a foreign key to the ORGENTITY table. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030252430 ORGENTITY_ID+ACPOLGRP_ID Primary Key I0000437 ACPOLGRP_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_1012 ACPOLGRP_ID ACPOLGRP ACPOLGRP_ID Cascade F_1013 ORGENTITY_ID ORGENTITY ORGENTITY_ID Cascade
Related reference
_vcc_freeselect_bottom_