But one important thing I forgot to say is that I have no courses-table. 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)? You can also change the layout by putting in your own parts. My idea was this (but is this the best way because this table would have many many columns): +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- Our sample templates include school timetables, monthly, blank, revision, daily, hourly, monthly, colorful, university, schedule, pretty, creative, college, class schedule, primary school, time management, and 24-hour timetables. 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.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |