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_


+

Search Tips   |   Advanced Search