Jan 18, 2018
0
Level 2
Eloquent model for custom scenario
Appointment Booking Tables
Groups
Locations
Users - These are the service providers
Services
Fees
Relationship
Groups can have multiples of users, services, locations
A user can belong to multiple groups
A location belongs to one group
A service belongs to one or more locations of one group
A location can have multiple services
A user can provide multiple services
Scenarios
Fees can be charged for each/all service.
Fees can be charged for each/all location.
Fees can be charged for each/all user/provider.
Fees can be charged for any combination of the above.
What other tables and relationships are needed to handle these scenarios?
Please or to participate in this conversation.