Answer the question
In order to leave comments, you need to log in
How to expand a table in a database without changing the table itself?
I have a Clients table in my database. Contains a certain minimum of data - full name and date of birth. In this version, it uses several unrelated modules.
For one of the modules, it was necessary to add a couple more fields to this table. For example height and weight. And for another module, you need a field - Region.
How can I "expand" the Clients table for these modules? Make additional many-to-many in each module?
An entry can be added from any module in Clients, but each module must only see its own "extension".
Answer the question
In order to leave comments, you need to log in
What's wrong with changing the table? You don't use * in your queries, but the exact list of fields?
Well, the protection of personal data is also organized?
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question