D
D
Dmitry Bay2017-06-12 02:46:01
Software design
Dmitry Bay, 2017-06-12 02:46:01

Structure of the table at the same data?

Good morning.
The next question, I sit, I think whether it is necessary to invent.
There is a table containing information about the object. And there is a complete set of data of the same type, for example, as properties here: https://www.airbnb.ru/rooms/432044?s=QQulq1Q8&chec...
How should data be stored?
1) In the same table
2) In a separate table.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
N
nirvimel, 2017-06-12
@kawabanga

It is a rare case when the data is immediately presented in almost normal form , therefore it fits perfectly into one database table.
Only fields with an enumerated type (for example, you have "Placement Type"), of course, need to be made keys to external tables (well, this is obvious).
The only exception is that "Sleepers" must go in a separate table and be connected to the main table as Many-to-One, since their number is variable, and they themselves represent a separate data type. Well, comments (if you keep them), then, obviously, they will go through Many-to-one.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question