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 Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031155330 ACRESGRP_ID+ACRESCGRY_ID Primary Key
I0000445 ACRESCGRY_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_45 ACRESCGRY_ID ACRESCGRY ACRESCGRY_ID Cascade
F_44 ACRESGRP_ID ACRESGRP ACRESGRP_ID Cascade

Feedback