ROLEDESC

Stores translatable descriptions for the roles.

Column Descriptions:

Name	Type	Description
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 NOT NULL DEFAULT 0	The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

Name	Column Names	Type
<SYSTEM-GENERATED>	ROLE_ID+LANGUAGE_ID	Primary Key

Constrained By Parent Tables:

Constraint	Columns	Parent Table	Parent Columns	Type
F_1028	ROLE_ID	ROLE	ROLE_ID	Cascade
F_1029	LANGUAGE_ID	LANGUAGE	LANGUAGE_ID	Cascade

Related reference
Authentication data model