Table IWA_CaseCustomTimestampField

Case Custom Timestamp Fields

Columns

Primary Key Name Type Length Precision Can Be Null Default References Action Hints Comment
true CaseCustomTimestampFieldId 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 DATETIME false The value of the custom field

Constraints

Constraint Name Columns Hints Comment
UNIQUE IWA_CaseCstmTmstmpFldIdNmIdx CaseId , Name

Indexes

Name Columns Hints Comment
IWA_CaseCstmTmstmpFldNmValIdx Name , Value
IWA_CaseCstmTmstmpFld_CaseIdIndex CaseId

Cache

Object Strategy
IWA_CaseCustomTimestampField ALL_REMOVE_UNUSED

Java

Object AsParent
CaseId true