Do you just have every table in the same schema but start with the project name?
No, I generally name database elements by their purpose, not which project is involved. Because all projects can see all DB connections, and might have a reason to.
If you really need isolation, use two gateways.
1 Like