ROLEDESC

Stores translateable descriptions for the roles.

Column Descriptions:

NameTypeDescription
ROLE_IDINTEGER NOT NULLRole ID. Foreign key to the ROLE table.
LANGUAGE_IDINTEGER NOT NULLLanguage ID. Foreign key to the LANGUAGE table. For a list of language components, see the LANGUAGE table.
DISPLAYNAMEVARCHAR (254) NOT NULLLocale specific description of the role.
DESCRIPTIONVARCHAR (4000)The description of the role.
OPTCOUNTERSMALLINTThe optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>ROLE_ID+LANGUAGE_IDPrimary Key

Constrained By Parent Tables:

ConstraintColumnsParent TableParent ColumnsType
F_1028ROLE_IDROLEROLE_IDCascade
F_1029LANGUAGE_IDLANGUAGELANGUAGE_IDCascade