Table IWA_CaseLocalized

Localized data of cases. E.g., name and description

Columns

Primary Key Name Type Length Precision Can Be Null Default References Action Hints Comment
true CaseLocalizedId BIGINT false
false CaseId BIGINT false IWA_Case(CaseId) ON DELETE CASCADE Java References the case this name and description belongs to
false LanguageId BIGINT false IWA_Language(LanguageId) References the language this name and description are in
false Name VARCHAR 200 false Java , Oracle The name of a case
false Description CLOB false Java The description of the case.

Constraints

Constraint Name Columns Hints Comment
UNIQUE IWA_CaseLocalized_CaseLanguageUniqueIndex CaseId , LanguageId

Indexes

Name Columns Hints Comment
IWA_CaseLocalized_NameIndex Name
IWA_CaseLocalized_CaseIdIndex CaseId
IWA_CaseLocalized_LanguageIdIndex LanguageId

Cache

Object Strategy
IWA_CaseLocalized ALL_REMOVE_UNUSED

Java

Object AsParent DataType Truncate
CaseId true
Name true
Description String true

Oracle

Object ConvertEmptyStringToNull
Name true