DB structure

[ahmadmnaa]

Aleen DB:

• Clients - id -> client details

  • Full name
  • Email
  • Mobile num
  • Birthday
  • General Notes
  • Profile image
  • Metadata
    • Discount
    • Trust

• Clients appointments:

  • All appointments
    • List of full appointment
  • Details of visits/dismissed/cancelled/no show

• Appointment

  • ID
  • Status
  • Client name
  • Client ID
  • Client phone
  • Appointment date, start time, duration
    • Services
  • Notes
  • Creation date
  • Total $
  • Payment status
  • Booked by (client or business)

• Service

  • ID
  • Name
  • Price
  • Duration
  • Color
  • Description
  • List of images
  • Notes
  • Permissions
    • Can be booked by user

• Appointments

  • List of all appointments

• Services

  • List of all services

• Settings collection

  • Document per settings category
    • Schedule management
      • Working days -
        • Opening hours per day
        • Status per day (opened/closed)
        • Break time (start -> end)
        • Notes
      • Unavailable
        • Date
        • Hours (start - end)
        • Reason
    • Business details
      • Info:
        • Name
        • Phone number
        • Email
        • Social media
        • Description
        • Location
      • Images
        • Logo
        • Cover
        • Workplace photos