Reference > Database > WebSphere Commerce database tables > A
WebSphere Commerce database table: ACRELDESC
This table stores the relationship between access control resources and attributes. These attributes are used to implicitly group resources. Given a resource, you can find out the supported attributes from this table. The metadata information about attributes is used in the GUI for defining resource groups and also for generating the SQL statements for prefiltering.
Column Name Column Type Description ACRELATION_ID INTEGER NOT NULL The relation ID. It is a foreign key to the ACRELATION table. Together with the LANGUAGE_ID column, it forms a primary key.
DISPLAYNAME VARCHAR(254) NOT NULL A locale-specific display name of the relationship. Together with the LANGUAGE_ID column, it forms a unique key.
DESCRIPTION VARCHAR(254) The description of the relationship. LANGUAGE_ID INTEGER NOT NULL The language ID. It is a foreign key to the LANGUAGE table. Together with the ACRELATION _ID column, it forms a primary key. For a list of language components, see the LANGUAGE table.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Indexes Index Name Indexed Column Names Index Type SQL100520030253430 ACRELATION_ID+LANGUAGE_ID Primary Key
Constraints Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type F_36 ACRELATION_ID ACRELATION ACRELATION_ID Cascade F_35 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
Related reference
_vcc_freeselect_bottom_