Table IWA_TaskLocalized

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

Columns

Primary Key	Name	Type	Length	Precision	Can Be Null	Default	References	Action	Hints	Comment
true	TaskLocalizedId	BIGINT			false
false	TaskId	BIGINT			false		IWA_Task(TaskId)	ON DELETE CASCADE	Java	References the task 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 task
false	Description	CLOB			false				Java	The description of the task.

Constraints

Constraint	Name	Columns	Hints	Comment
UNIQUE	IWA_TaskLocalized_TaskLanguageUniqueIndex	TaskId , LanguageId

Indexes

Name	Columns	Hints	Comment
IWA_TaskLocalized_NameIndex	Name
IWA_TaskLocalized_TaskIdLanguageIdNameIndex	TaskId , LanguageId , Name
IWA_TaskLocalized_TaskIdLanguageIdLowerNameIndex	TaskId , LanguageId , lower(Name)
IWA_TaskLocalized_LanguageIdNameTaskIdIndex	LanguageId , Name , TaskId
IWA_TaskLocalized_LanguageIdLowerNameTaskIdIndex	LanguageId , lower(Name) , TaskId
IWA_TaskLocalized_TaskIdIndex	TaskId
IWA_TaskLocalized_LanguageIdIndex	LanguageId

Cache

Object	Strategy
IWA_TaskLocalized	ALL_REMOVE_UNUSED

Java

Object	AsParent	DataType	Truncate
TaskId	true
Name			true
Description		String	true

Oracle

Object	ConvertEmptyStringToNull
Name	true