Answer the question
In order to leave comments, you need to log in
Is there a simplified DBMS-independent language for describing the structure of a relational database?
Sometimes you want to quickly outline the database structure for a simple CRUD application, but too lazy to write all these CREATE TABLEs and all that in SQL, which, moreover, will only be suitable for one particular DBMS (SQL dialect). I would like something simple and concise and compiled into the dialect of any DBMS, and maybe at the same time into model code blanks for many languages / ORM. For example, I came up with such an option offhand, we will describe, for example, the basis of relationships between people, the meaning, I think, is intuitive:
people
pk: id int
c: name varchar (45)
c: surname varchar (45)
relations
pk: id int
c: name varchar (45) ["firend", "spouse", "boss"]
relationships
fk: person1 ~ people -> id
fk: person2 ~ people -> id
fk: relation ~ relations -> id
c: since dt
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question