How to design the database structure of classroom timetable

This is how I design the field for every lesson from Monday to Friday, to design the records into a classroom number, so that there is no better solution.

Reply content:

This is how I design the field for every lesson from Monday to Friday, to design the records into a classroom number, so that there is no better solution.

A record can include: class, week, the first class, the subject. Suppose one day eight class, Five days a week, then a class week is 40 records.

Are you sure this is a database table? It looks so awkward ....

