SMB Catalog

Data model for an SMB providing services by staff

An SMB, like a hair salon, is a business.

A business has zero or more venues.

A venue is open for business hours.

A venue has zero or more staff.

Bookings and staff shifts at a venue are managed through a business calendar.

A staff is an employee or contractor who works at the venue for the business.

The staff's working hours are defined using their staff shift.

The products or services that the business offers at this venue are defined used a catalog made up of items grouped using categories.

Staff offer certain items in their staff shifts.

A booking is made by a customer where they pick a staff, and a set of items which must all fit within the availability as brought together in this business calendar.

data model for hair salon.drawio.png