WebSphere Commerce database table: ACRESGPRES

This table associates access control resource groups with resource categories (or the classes of resources). Use this table to group various resources together based on their class names.

Column Descriptions
Column Name Column Type Description
ACRESGRP_ID INTEGER NOT NULL The resource group ID. It is a foreign key to the ACRESGRP_ID column in the ACRESGRP table.
ACRESCGRY_ID INTEGER NOT NULL The resource category ID. It is a foreign key to the ACRESCGRY table.
FIELD1 VARCHAR(128) This column is customizable.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235119890 ACRESGRP_ID+ACRESCGRY_ID Primary Key
I0000445 ACRESCGRY_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_45 ACRESCGRY_ID ACRESCGRY ACRESCGRY_ID Cascade
F_44 ACRESGRP_ID ACRESGRP ACRESGRP_ID Cascade
Related reference