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

khanimranm's avatar

Suggestion needed for tables and relationship

Appointment Booking Tables

Groups
Locations
Users - These are the service providers
Services
Fees
And some more tables.

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.