Substitutes of users. A user can have a substitute for itself and /or for each of its roles.
The substitute owns the rights of the user during the time the user is absent (see table IWA_UserAbsence).
|
Primary Key
|
Name
|
Type
|
Length
|
Precision
|
Can Be Null
|
Default
|
References
|
Action
|
Hints
|
Comment
|
|
true
|
UserSubstituteId
|
BIGINT
|
|
|
false
|
|
|
|
|
Identifies this substitute.
|
|
false
|
SecurityMemberId
|
VARCHAR
|
210
|
|
false
|
|
IWA_User(SecurityMemberId)
|
ON DELETE CASCADE
|
Java
|
References the user this substitute belongs to.
|
|
false
|
SubstituteUserSecurityMemberId
|
VARCHAR
|
210
|
|
false
|
|
IWA_User(SecurityMemberId)
|
ON DELETE CASCADE
|
MsSqlServer
|
References the user which substitutes the user references by UserId in the case he is absent.
|
|
false
|
SubstituteRoleSecurityMemberId
|
VARCHAR
|
210
|
|
true
|
|
IWA_Role(SecurityMemberId)
|
ON DELETE CASCADE
|
|
References the role for which the substitute user substitutes the user referenced by UserId in case he is absent.
This field may be null. In this case the user references by SubstituteUserSecurityMemberId substitutes the user referenced by UserId for the tasks the user is responsible for. Which means he can see and work on the tasks the user he substitutes is responsible for because the user is the activator of the tasks.
If the field is not null. The user references by SubstituteUserSecurityMemberId substitutes the user referenced by UserId for the tasks the user is responsible for because he owns the role referenced by SubstituteForRoleSecurityMemberId. Which means he can see and work on the tasks the user he substitutes is responsible for because a role the user owns is the activator of the tasks.
|
|
false
|
Description
|
VARCHAR
|
200
|
|
false
|
|
|
|
Java
,
Oracle
|
Description of the user substitute.
|
|
false
|
SubstitutionType
|
INTEGER
|
|
|
false
|
0
|
|
|
Java
|
Is user permanent substitute. See java enumeration ch.ivyteam.ivy.security.SubstitutionType for possible values.
|