Re: Dynamic Table

Take a look at EAV. It's a method of storing a user defined schema. A Django project called wq has that as an option:

https://wq.io/guides/eav-vs-relational

On May 23, 2023 9:21:25 PM AKDT, Helly Modi <hellymodi02@gmail.com> wrote:

I have to create dynamic table at runtime where user enters the details of table name,table column,table fields,constraints.take this input in backend and create table dynamically without creating schemas of tables as tables are created at runtime .first approach is that we will create one table where all the fields are mentioned where primary key,secondary key,unique,not niull and all the constraints are mentioned in horizontal column.now we have to create table 2 where user will select whild field id he want to select .suppose if user wants to create primary key then it will select field 1 in second table so it is refered from main table.and then table is created do you know how this works in django from backend side