Database Table: ACPOLGRP

This table stores all the access control policy groups in the system. Each a row in this table represents a policy group.

Column Name Column Type Column Description
ACPOLGRP_ID INTEGER
NOT NULL
Generated unique ID of this access control policy group record.
MEMBER_ID BIGINT
NOT NULL
Member ID of the owner of the access control policy group. Foreign key to MEMBER table.
NAME VARCHAR (128)
NOT NULL
Name of the access control policy group.
Indexes:
Index Name Indexed Column Names Index Type
I0000306 NAME, MEMBER_ID Unique Index
SQL030416034829300 ACPOLGRP_ID Primary Key
Constraints:
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1005 MEMBER_ID MEMBER MEMBER_ID Cascade

Referenced By:
Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_1006 ACPOLGRP_ID ACPOLSUBGP PARENT_ID Cascade
F_1007 ACPOLGRP_ID ACPOLSUBGP CHILD_ID Cascade
F_1009 ACPOLGRP_ID ACPLGPDESC ACPOLGRP_ID Cascade
F_1011 ACPOLGRP_ID ACPOLGPPOL ACPOLGRP_ID Cascade
F_1012 ACPOLGRP_ID ACPLGPSUBS ACPOLGRP_ID Cascade