Table IWA_CaseCustomStringField

Case Custom String Field

Columns

Primary Key	Name	Type	Length	Precision	Can Be Null	Default	References	Action	Hints	Comment
true	CaseCustomStringFieldId	BIGINT			false					Identifies this custom field
false	CaseId	BIGINT			false		IWA_Case(CaseId)	ON DELETE CASCADE	Java	Identifies the task this custom field belongs to
false	Name	VARCHAR	200		false					The name of the custom field
false	Value	VARCHAR	2000		false					The value of the custom field

Constraints

Constraint	Name	Columns	Hints	Comment
UNIQUE	IWA_CaseCstmStringFldIdNmIdx	CaseId , Name

Indexes

Name	Columns	Hints	Comment
IWA_CaseCstmStringFld_CaseIdIndex	CaseId
IWA_CaseCstmStringFld_CaseIdNameValueIndex	CaseId , Name , Value	MySql
IWA_CaseCstmStringFld_CaseIdNameLowerValueIndex	CaseId , Name , lower(Value)
IWA_CaseCstmStringFld_NameValueCaseIdIndex	Name , Value , CaseId	MySql
IWA_CaseCstmStringFld_NameLowerValueCaseIdIndex	Name , lower(Value) , CaseId
IWA_CaseCstmStringFldNmValIdx	Name , Value	MySql

Cache

Object	Strategy
IWA_CaseCustomStringField	ALL_REMOVE_UNUSED

Java

Object	AsParent
CaseId	true

MySql

Object	IndexColumnLength
IWA_CaseCstmStringFld_CaseIdNameValueIndex	,,200
IWA_CaseCstmStringFld_NameValueCaseIdIndex	,200,
IWA_CaseCstmStringFldNmValIdx	55,200