Answer the question
In order to leave comments, you need to log in
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.
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
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:
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 questionAsk a Question
731 491 924 answers to any question