Table IWA_TaskNote

Relation between task and note

Columns

Primary Key Name Type Length Precision Can Be Null Default References Action Hints Comment
true TaskId BIGINT false IWA_Task(TaskId) ON DELETE CASCADE MsSqlServer , MySql Identifies the task, 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 task.

Indexes

Name Columns Hints Comment
IWA_TaskNote_TaskIdIndex TaskId
IWA_TaskNote_NoteIdIndex NoteId

Java

Object AsAssociation
IWA_TaskNote true

MySql

Object NoReferenceUseTrigger
TaskId true
NoteId true

MsSqlServer

Object NoReferenceUseTrigger
TaskId true
NoteId true

Oracle

Object NoReferenceUseTrigger
NoteId true