AnsweredAssumed Answered

Question on ACT_RU_IDENTITYLINK for DBA adding constraints and indexes

Question asked by jwestra on Mar 21, 2016
Latest reply on Mar 25, 2016 by jbarrez

My DBA is adding more constraints and indexes to the standard postgresql scripts.

Is it valid to say, ACT_RU_IDENTITYLINK rows will have "either" a user_id or a group_id, but never both?

Here is an example, our DBA wants to add:
alter table act_ru_identitylink
add constraint act_ru_identitylink_check_ids
check ((user_id_ is not null or group_id_ is not null)
   and not (user_id_ is not null and group_id_ is not null));

2.) What operations in Activiti would cause the "ACT_RU_IDENTITYLINK.rev_" column be updated beyond 1?  It seems like an insert or delete table only.