一个简单的会议CRUD（创建/读取/更新/删除）PHP应用程序：最佳实践

Question

In a PHP application i am developing, I would like to know which way of the following is a good approach to create a meeting based on availability.

Option 1 - I am planing to keep predefined types of time slots such as, 8:00 am to 9:00 am (SLOT 1), 9:00 am to 10.00 am (SLOT 2) and etc. in a separate table called meeting_intervals

Option 2 - Letting a user to provide a FROM and TO time. i.e From 8:00 am to 9:30 pm. i feel this way its much more flexible.

Which of this can be useful in the long term plan ?

Answer 1

Both options are viable in my opinion, given that a user can book more than one slot at a time in option 1. Furthermore, if you decide for option 1 I suggest to use shorter intervals (maybe 15 minutes) so you can have flexibility and simplicity. What are you most concerned with?