Reference > Database > WebSphere Commerce database tables > A
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 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 SQL100520030252880 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
Referenced By 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
_vcc_freeselect_bottom_