Reference > Database > WebSphere Commerce database tables > A
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 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 SQL100520030255270 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
_vcc_freeselect_bottom_