WebSphere Commerce database table: ROLEDESC

Stores translateable descriptions for the roles.


Column Description(s):
Column NameColumn TypeDescription
ROLE_ID INTEGER NOT NULL Role ID. Foreign key to the ROLE table.
LANGUAGE_ID INTEGER NOT NULL Language ID. Foreign key to the LANGUAGE table. For a list of language components, see the LANGUAGE table.
DISPLAYNAME VARCHAR(254) NOT NULL Locale specific description of the role.
DESCRIPTION VARCHAR(4000) The description of the role.
OPTCOUNTER SMALLINT Reserved for IBM internal use.
Index(es):
Index NameIndexed Column NamesIndex Type
SQL050212031307630 ROLE_ID+LANGUAGE_ID Primary Key
Constraint(s):
Constraint NameColumn Name(s)Foreign Table NameForeign Column Name(s)Constraint Type
F_1029 LANGUAGE_ID LANGUAGE LANGUAGE_ID Cascade
F_1028 ROLE_ID ROLE ROLE_ID Cascade

Feedback