The user can input a text/subject-name for each lesson via many HTML text-fields (maybe there is also a better solution). In conclusion: What would be the best design of a MySQL table for a typical school timetable (with user_id)? Now I want to create a MySQL table for this application. | 2 | SCIENCE | MATHS | ENGLISH | FRENCH | ART | | 1 | SCIENCE | MATHS | ENGLISH | FRENCH | ART |
| h | Monday | Tuesday | Wednesday | Thursday | Friday | The end product should look like this: +-+-+-+-+-+-+ I want to create a typical school timetable for each user.