Skip to content

SysUser with mandatory unique Cooperator

Each SysUser record in GGCE should have a corresponding Cooperator record (1-1). Please update it to nullable = false and update liqibase.

Before adding the not-null constraint, liquibase needs to have a precondition check that all select count(sys_user_id) from sys_user where cooperator_id is null equals 0.

Also add a unique index on sys_user.cooperator_id, ensuring that each entry has its own Cooperator. Precondition select count(cooperator_id) from sys_user group by cooperator_id having count(cooperator_id) > 1 equals 0.

When this is ready, UI needs updating so that the list of users includes the link to Cooperator and the cooperator name.

Edited by Matija Obreza
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information