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 the same policy group can be subscribed to by multiple organizations.

Column Name Column Type Column Description
ACPOLGRP_ID INTEGER
NOT NULL
ID of the access control policy group to which the organizational entity is subscribing. Foreign key to ACPOLGRP table.
ORGENTITY_ID BIGINT
NOT NULL
Organizational entity ID of the organization that is subscribing to a policy group. Foreign key to ORGENTITY table.
Indexes:
Index Name Indexed Column Names Index Type
SQL030416034828340 ORGENTITY_ID, ACPOLGRP_ID Primary Key
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

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
Not Applicable