Behaviour on deletion

[callmekatootie]

When a record is deleted, the behaviour expected is as follows:

Safe to delete

No checks will be carried out here:

• achievement
• externalProfile
• organizationSkillsProvider
• usersAttribute
• usersRole
• usersSkill

These exist as sub documents under the user / organizationn and thus are safe to delete

Dependencies

Check if the model is referenced by other models

• achievementsProvider (see if any achievement uses it)
• attributeGroup (see if any attribute uses it)
• attribute (see if any user attribute uses it)
• organization (see if any external profile or organization skills provider references it)
• role (see if any user role references it)
• skill (see if any user skill uses it)
• skillsProvider (see if any skill uses it)

If yes, prevent deletion and instruct to delete dependent records first

Cascade

If these records are deleted, ensure that there is a cascade deletion on the child records too

• user (delete achievement, externalProfile, usersAttribute, usersRole and usersSkill)
• organization (delete organizationSkillsProvider records)

[callmekatootie]

This is now resolved

[callmekatootie]

Changes were taken up in the pgsql migration