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 Descriptions
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 |
SQL060903235115460
| 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