Reference > Database > WebSphere Commerce database tables > A
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 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 SQL100520030254230 ACRESCGRY_ID Primary Key
Referenced By 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
_vcc_freeselect_bottom_