Answer the question
In order to leave comments, you need to log in
How to properly build the table architecture in my case? How not to produce tables?
It needs to be implemented using a relational data model.
Preferably compatible with MySQL capabilities.
I will give a simplified example of what needs to be implemented:
1. There are data of different types. Types (attributes) of data will constantly expand (types are not known in advance).
Example:
data_1 data_2 data_3 (в дальнейшем будут добавлятся) data_4 data_5 ...
Группа №1 data_1 data_2
Группа №2 data_1 data_2 data_3 data_4
Группа №3 data_5 data_6
(И группы могут расширятся по мере расширения данных)
Группа №4 data_3 data_4 data_7 data_8
Группа №1 Группа №2
Группа №3 Группа №4
Группа №1 Группа №2 Группа №3 Группа №4
(И группы могут расширятся по мере расширения данных)
Группа №3 Группа №4 Группа №5 Группа №6
Answer the question
In order to leave comments, you need to log in
1. I advise you to read it in full, well, and so the section "Vertical tables":
https://ruhighload.com/post/%D0%94%D0%B5%D0%BD%D0%...
and 2 and 3 are ordinary link tables . I think in this article you will find the answer to your questions.
Store groups in XML format in a separate table
, and in the line where you need to specify a certain set (Group), pass the Group ID
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question