How to specify availability

[gmourant]

How will the tutor's hours be specified? I propose tutor's weekly hours than a list of exceptions associated with a specific date (such as no work or special hours for December 3 for example). But how would this work in practice in terms of databases and RESTful services.

[gmourant]

I propose a weekly schedule database table with the following columns:

• tutor_id
• day_of_the_week
• start_time
• end_time

Each tutor could have as many entries in this table as needed to specify their schedule.

Additionally, there would be another database table with the following columns:

• tutor_id
• date
• start_end
• end_time
• no_work (boolean)

Thoughts?

[gmourant]

@ImaneChafi @sofiiad