Table IWA_SignalEvent

Signals that have been sent

Columns

Primary Key	Name	Type	Length	Precision	Can Be Null	Default	References	Action	Hints	Comment
true	SignalEventId	BIGINT			false
false	SecuritySystemId	BIGINT			false		IWA_SecuritySystem(SecuritySystemId)		Java
false	ApplicationId	BIGINT			true		IWA_Application(ApplicationId)	ON DELETE CASCADE	Oracle
false	SignalCode	VARCHAR	200		false					The signal code that was received
false	SentTimestamp	DATETIME			false
false	SentById	VARCHAR	210		true		IWA_SecurityMember(SecurityMemberId)
false	SentByTaskId	BIGINT			true		IWA_Task(TaskId)	ON DELETE SET NULL	MsSqlServer , MySql
false	SentByProcessElementPid	VARCHAR	200		true					PID of process element that sent the signal

Indexes

Name	Columns	Hints	Comment
IWA_SignalEvent_SecuritySystemId	SecuritySystemId
IWA_SignalEvent_ApplicationId	ApplicationId
IWA_SignalEvent_SignalCode	SignalCode
IWA_SignalEvent_SentTimestamp	SentTimestamp
IWA_SignalEvent_SentByTaskId	SentByTaskId
IWA_SignalEvent_SentById	SentById

Referenced By

Foreign Table	Column	Comment
IWA_SignaledTask	ReceivedSignalEventId	Signal that was received and matched this pattern
IWA_SignalEventData	SignalEventId	Identifies the signal event the entity belongs to

Java

Object	AsParent	BusinessClass
IWA_SignalEvent		ch.ivyteam.ivy.workflow.signal.ISignalEvent
SecuritySystemId	true

Cache

Object	Strategy
IWA_SignalEvent	ALL_REMOVE_UNUSED

Oracle

Object	NoReferenceUseTrigger
ApplicationId	true

MySql

Object	NoReferenceUseTrigger
SentByTaskId	true

MsSqlServer

Object	NoReferenceUseTrigger
SentByTaskId	true