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_CaseIdLanguageIdNameIndex	CaseId , LanguageId , Name
IWA_CaseLocalized_CaseIdLanguageIdLowerNameIndex	CaseId , LanguageId , lower(Name)
IWA_CaseLocalized_LanguageIdNameCaseIdIndex	LanguageId , Name , CaseId
IWA_CaseLocalized_LanguageIdLowerNameCaseIdIndex	LanguageId , lower(Name) , CaseId
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