WebSphere Commerce database table: ACRESCGRY

This table stores all the access control resource categories in the system and the metadata information about them. The metadata includes information about the table and the columns that store the resources belonging to the resource category.

Column Descriptions
Column Name Column Type Description
ACRESCGRY_ID INTEGER NOT NULL The ID assigned to this particular resource category. This is a primary key.
RESPRIMARYTABLE VARCHAR(64) The name of the table that stores the resource.
RESOWNERTABLE VARCHAR(64) The name of the table that stores the owner of the resource.
RESOWNERCOL VARCHAR(64) The name of the column that stores the owner of this resource.
RESKEYOWNCOL VARCHAR(64) The name of the column that has the resource ID in the table that stores the owner. This is null if the owner is stored in the same table as the resource itself.
FIELD1 VARCHAR(128) This column is customizable.
RESCLASSNAME VARCHAR(254) NOT NULL The class name of the bean that represents this resource. For commands, this is the fully-qualified name of the interface.
RESJOINKEY VARCHAR(64) The column in the resource table to which the key from the owner table can be joined. This is null if the owner is stored in the same table as the resource itself.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
I0000009 RESCLASSNAME Unique Index
SQL060903235119040 ACRESCGRY_ID Primary Key

Constraint Name Referenced Column Name Foreign Table Name Foreign Column Names Constraint Type
F_39 ACRESCGRY_ID ACRESACT ACRESCGRY_ID Cascade
F_41 ACRESCGRY_ID ACRESATREL ACRESCGRY_ID Cascade
F_45 ACRESCGRY_ID ACRESGPRES ACRESCGRY_ID Cascade
F_49 ACRESCGRY_ID ACRESMEMRL ACRESCGRY_ID Cascade
F_50 ACRESCGRY_ID ACRESPRIM ACRESCGRY_ID Cascade
F_52 ACRESCGRY_ID ACRESREL ACRESCGRY_ID Cascade
F_55 ACRESCGRY_ID ACRSCGDES ACRESCGRY_ID Cascade
Related reference