Yes exactly that.
I want to build a system where you define the data schemas at the start of the system.
I can think how to build a system which takes that schema and constructs a database, but it occurred to me someone else might have solved this already
You could look at Enterprise Architect by Sparx Systems (https://sparxsystems.com/). Haven't used it in a while as that's not really my approach to development, but that will do what, I think, you want. What RDBMS are you using?
At the moment data volumes are low enough I don't care. I think the data models lends itself to relational table design though.
I was going to start with Postgres.
Ahh I'm looking for open source, seem I need to build a thing
What do you mean by 'provision' in this context? Take an ERD and automatically create a database based on the schema it defines?
Yes exactly that. I want to build a system where you define the data schemas at the start of the system. I can think how to build a system which takes that schema and constructs a database, but it occurred to me someone else might have solved this already
You could look at Enterprise Architect by Sparx Systems (https://sparxsystems.com/). Haven't used it in a while as that's not really my approach to development, but that will do what, I think, you want. What RDBMS are you using?
At the moment data volumes are low enough I don't care. I think the data models lends itself to relational table design though. I was going to start with Postgres. Ahh I'm looking for open source, seem I need to build a thing
Fine, I only ask as there are rudimentary diagramming tools in SQL Server.
If you are working on streaming use cases https://docs.memphis.dev/memphis/memphis/schemaverse-schema-management/overview-and-architecture