Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.

khanimranm's avatar

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?

0 likes
0 replies

Please or to participate in this conversation.