WebSphere Commerce database table: ACRESREL

This table associates an access control resource with the relationships that it supports. Given a resource, you can find out the possible relationships that it can have and also the table and the columns in which these relationships are stored.

Column Descriptions
Column Name Column Type Description
ACRELATION_ID INTEGER NOT NULL The relationship ID. It is a primary key, and a foreign key to the ACRELATION table.
ACRESCGRY_ID INTEGER NOT NULL The resource category ID. It is a primary key, and a foreign key to the ACRESCGRY table.
RESRELTABLE VARCHAR(64) NOT NULL The name of the table that stores the member relationships for a given resource.
RESRELMEMCOL VARCHAR(64) NOT NULL The column in the relationship table that stores the member ID.
RESRELKEYCOL VARCHAR(64) The column in the relationship table that stores the resource ID.
RESRELCOL VARCHAR(64) The column in the relationship table that stores the resource relationship.
RESJOINCOL VARCHAR(64) The column in the main resource table that can be joined with the RESRELKEYCOL column.
FIELD1 VARCHAR(128) This column is customizable.
RESOURCETYPE VARCHAR(64) The column name in the relationship table that stores the resource type for which the relationship applies. This field is used for relationship tables that capture relationships for more than one type of resource. It would be the string "ACRESCGRY_ID" for ACRESMEMRL table.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL060903235121290 ACRELATION_ID+ACRESCGRY_ID Primary Key
I0000448 ACRESCGRY_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_51 ACRELATION_ID ACRELATION ACRELATION_ID Cascade
F_52 ACRESCGRY_ID ACRESCGRY ACRESCGRY_ID Cascade
Related reference