Database model and admin action review

[drewbo]

It's relatively easy to create errors in the database when making manual changes. We can review two broad categories affecting this issue:

• Prevent data models from falling into "invalid" states by reviewing the sequelize Models for null conditions/cascade options
• Create new admin actions for common tasks that would otherwise require manual database changes (deleting users, reseting UAA user association, etc)

Acceptance Criteria

• [ ] Determine next steps and acceptance criteria
• [ ] Collect a series of actions that can be added to the admin UI or can be run as a cf task npm script
  • ie: Delete a user from the platform, update a sites live domain config,...

[apburnes]

Use this issue to research alternatives to our current admin experience?

[drewbo]

Noting one possible solution we've discussed: we could deploy an open-source "database admin UI" to replace 80% of our admin functionality and try to use custom hooks to cover the remaining 20%. This won't prevent invalid data model errors but will give us additional admin functionality and theoretically reduce our maintenance burden (or new feature burden) on the current admin-client. It would need SSO and role based access controls to match our current offering and be easier to slot into the SSP