WebSphere Commerce database table: ACPOLGRP

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

Column Descriptions
Column Name Column Type Description
ACPOLGRP_ID INTEGER NOT NULL The generated unique ID of this access control policy group record.
NAME VARCHAR(128) NOT NULL The name of the access control policy group.
MEMBER_ID BIGINT NOT NULL The member ID of the owner of the access control policy group. It is a foreign key to the MEMBER table.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000306 NAME+MEMBER_ID Unique Index
SQL060903235116450 ACPOLGRP_ID Primary Key
I0000439 MEMBER_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_1005 MEMBER_ID MEMBER MEMBER_ID Cascade

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