WebSphere Commerce database table: ACORGPOL

WebSphere Commerce database table: ACORGPOL

This table enables an organization to be exempted from one or more of the template policies. This table is deprecated and is provided for backward compatibility only.
Column Descriptions
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
SQL060903235114790 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

Access control data model

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.

Index Name	Indexed Column Names	Index Type
SQL060903235114790	ACPOLICY_ID+MEMBER_ID	Primary Key
I0000436	MEMBER_ID	Non-Unique Index

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