Reference > Database > WebSphere Commerce database tables > A


WebSphere Commerce database table: ACRSCGDES

This table stores locale-specific information for the ACRESCGRY table.

Column Name Column Type Description
LANGUAGE_ID INTEGER NOT NULL The language ID of the locale for which this display name is valid. For a list of language components, see the LANGUAGE table.
ACRESCGRY_ID INTEGER NOT NULL The resource ID.
DISPLAYNAME VARCHAR(700) NOT NULL The locale-specific display name.
DESCRIPTION VARCHAR(700) The description for this resource category. This field is optional.
OPTCOUNTER SMALLINT Reserved for IBM internal use.

Indexes
Index Name Indexed Column Names Index Type
SQL100520030255740 LANGUAGE_ID+ACRESCGRY_ID Primary Key
I0000449 ACRESCGRY_ID Non-Unique Index

Constraints
Constraint Name Column Names Foreign Table Name Foreign Column Names Constraint Type
F_55 ACRESCGRY_ID ACRESCGRY ACRESCGRY_ID Cascade
F_56 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade


Related reference

_vcc_freeselect_bottom_


+

Search Tips   |   Advanced Search