D
D
Dmitry Sokolov2020-05-10 13:08:47
Database design
Dmitry Sokolov, 2020-05-10 13:08:47

How to create a database with user registration for courses?

How to create a database with user registration for courses? The site has been published .
Table with users (id, name, email, balance and password)
Table with training programs:
5eb7d2176e1a2867227535.png
When registering for a specific day of the program, it should appear in the student's personal account.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
V
VyachH, 2020-05-10
@VyachH

Make a third table, where there will be id_user, id_lessons, then make a selection only for relevant ones with a date condition.
Upd. And I would change the table with classes, there is not enough field for the date of the lesson.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question