Table IWA_UserAbsence

User absences

Columns

Primary Key	Name	Type	Length	Precision	Can Be Null	Default	References	Action	Hints	Comment
true	UserAbsenceId	BIGINT			false					Identifies this absence.
false	SecurityMemberId	VARCHAR	210		false		IWA_User(SecurityMemberId)	ON DELETE CASCADE	Java	References the user this absence belongs to
false	StartTimestamp	DATETIME			false					When starts this absence. The absence is from this timestamp on.
false	StopTimestamp	DATETIME			true					When ends this absence. This absence stops at this timestamp. If no stop timestamp is defined (NULL), the absence last foreever.
false	Description	VARCHAR	200		false				Java , Oracle	Description of the user absence.

Indexes

Name	Columns	Hints	Comment
IWA_UserAbsence_SecurityMemberIdIndex	SecurityMemberId

Cache

Object	Strategy
IWA_UserAbsence	ALL_REMOVE_UNUSED

Java

Object	AsParent	Truncate
SecurityMemberId	true
Description		true

Oracle

Object	ConvertEmptyStringToNull
Description	true