Case Custom Timestamp Fields
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 |
Constraint | Name | Columns | Hints | Comment |
---|---|---|---|---|
UNIQUE | IWA_CaseCstmTmstmpFldIdNmIdx | CaseId , Name |
Name | Columns | Hints | Comment |
---|---|---|---|
IWA_CaseCstmTmstmpFldNmValIdx | Name , Value | ||
IWA_CaseCstmTmstmpFld_CaseIdIndex | CaseId |
Object | Strategy |
---|---|
IWA_CaseCustomTimestampField | ALL_REMOVE_UNUSED |
Object | AsParent |
---|---|
CaseId | true |