R
R
REDkiy2016-10-13 10:46:52
Database design
REDkiy, 2016-10-13 10:46:52

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

2 answer(s)
R
Rsa97, 2016-10-13
@Rsa97

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?

R
REDkiy, 2016-10-13
@REDkiy

Есть вероятность, что через какое-то время этих полей будет под сотню. Также есть вероятность, что модули для хранения "своих" данных будут использовать отдельную БД.
Также мне хочется думать, что при подобном подходе мне удастся облегчить в том числе и защиту ПД.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question