E
E
Eugene2020-09-25 10:47:40
MySQL
Eugene, 2020-09-25 10:47:40

Whether correctly made communication of tables-2?

Hello!

This is a continuation of the question Did you make the connection of the tables correctly?
At that time, everything was clear ... now the concept has changed a bit.

In general, the initial data:
Service for training. The trainer makes programs - power, mass, aerobic. Each program is signed for every day, for morning, afternoon and evening.
Those. on the site you can see the tables - click on the Power and see for the next month, for each number, three blocks (morning, afternoon and evening) with a set of exercises.

5f6c22db3048d022938504.png

The user draws up a training diary based on these tables.
Those. this morning he chooses Aerobic, tomorrow, for example, in the evening he decides to stubbornly and chooses Power. Then aerobic, then skips a day ... well, and so he makes himself a training diary for the next few days.

Now there are such tables: The

5f6d9ec889197289717745.png

question is what.
How do I enter the date and part of the day (morning/afternoon/evening) here?

The only thing I came up with was to make another "timetable" table and add a column to the link table:

5f6d9fd273d9c802258319.png

or is there another way?

I searched the Internet for the keywords "database for lessons / schedule / training", but there everything is tied to the fact that the schedule repeats depending on the parity of the week or something else.
And there will be no dependencies.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question