Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ACORGPOL
This table stores all the access control policies in the system. Every policy refers to an action group, a member group, a resource group and optionally, a relationship.
Column Name Column Type Description ACPOLICY_ID INTEGER NOT NULL The ID of the template policy. It is a foreign key to the ACPOLICY table. MEMBER_ID BIGINT NOT NULL The ID of the organizational entity that does not want the template policy applied to it. It is a foreign key to the MEMBER table. OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030252130 ACPOLICY_ID+MEMBER_ID Primary Key I0000436 MEMBER_ID Non-Unique Index
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_26 ACPOLICY_ID ACPOLICY ACPOLICY_ID Cascade F_25 MEMBER_ID MEMBER MEMBER_ID Cascade
Related reference
_vcc_freeselect_bottom_