Table IWA_CaseNote

Relation between case and note

Columns

Primary Key Name Type Length Precision Can Be Null Default References Action Hints Comment
true CaseId BIGINT false IWA_Case(CaseId) ON DELETE SET NULL MsSqlServer , MySql Identifies the case, the note belongs to.
true NoteId BIGINT false IWA_Note(NoteId) ON DELETE THIS CASCADE MsSqlServer , MySql , Oracle Identifies the note that belongs to the case.

Indexes

Name Columns Hints Comment
IWA_CaseNote_CaseIdIndex CaseId
IWA_CaseNote_NoteIdIndex NoteId

Java

Object AsAssociation
IWA_CaseNote true

MySql

Object NoReferenceUseTrigger
CaseId true
NoteId true

MsSqlServer

Object NoReferenceUseTrigger
CaseId true
NoteId true

Oracle

Object NoReferenceUseTrigger
NoteId true