Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ACRESGPRES
This table associates access control resource groups with resource categories (or the classes of resources). You can use this table to group various resources together based on their class names.
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 SQL100520030254520 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
_vcc_freeselect_bottom_