WebSphere Commerce database table: ACRSCGDES

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


Column Description(s):
Column NameColumn TypeDescription
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.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031156170 LANGUAGE_ID+ACRESCGRY_ID Primary Key
I0000449 ACRESCGRY_ID Non-Unique Index
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_55 ACRESCGRY_ID ACRESCGRY ACRESCGRY_ID Cascade
F_56 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade

Feedback