To ensure the whole team understands what data structures are being created and what they're used for, definitions for tables, views, etc should be housed in a build script, and additions/changes to those data structures on prod should be made by editing that script, rather than using the PGAdmin UI.
This would necessitate a lot of systematization of code review and pull requests for database changes, and should be discussed and scoped with the team. It will be a big project! Putting this here to act as a placeholder for this discussion sometime in the future.
To ensure the whole team understands what data structures are being created and what they're used for, definitions for tables, views, etc should be housed in a build script, and additions/changes to those data structures on prod should be made by editing that script, rather than using the PGAdmin UI.
This would necessitate a lot of systematization of code review and pull requests for database changes, and should be discussed and scoped with the team. It will be a big project! Putting this here to act as a placeholder for this discussion sometime in the future.