Table IWA_CaseCustomTextField

Case Custom Text Fields

Columns

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

Constraints

Constraint	Name	Columns	Hints	Comment
UNIQUE	IWA_CaseCstmTextFldIdNmIdx	CaseId , Name

Indexes

Name	Columns	Hints	Comment
IWA_CaseCstmTextFldNameIdx	Name
IWA_CaseCstmTextFld_CaseIdIndex	CaseId

Cache

Object	Strategy
IWA_CaseCustomTextField	ALL_REMOVE_UNUSED

Java

Object	AsParent	DataType
CaseId	true
Value		String