my

Tables (5)

Appointment

  • AppointmentID — INT
  • AppointmentDate — DATE — NOT NULL
  • AppointmentTime — TIME — NOT NULL
  • CustomerID — INT — NOT NULL
  • BarberID — INT — NOT NULL
  • ServiceID — INT — NOT NULL

Barber

  • BarberID — INT
  • FirstName — VARCHAR(50) — NOT NULL
  • LastName — VARCHAR(50) — NOT NULL
  • ExperienceYears — INT
  • PhoneNumber — VARCHAR(20) — NOT NULL

Customer

  • CustomerID — INT
  • FirstName — VARCHAR(50) — NOT NULL
  • LastName — VARCHAR(50) — NOT NULL
  • PhoneNumber — VARCHAR(20) — NOT NULL
  • Email — VARCHAR(100)

Payment

  • PaymentID — INT
  • AppointmentID — INT — NOT NULL
  • PaymentDate — DATE — NOT NULL
  • Amount — DECIMAL(10,2)
  • PaymentMethod — VARCHAR(30)

Service

  • ServiceID — INT
  • ServiceName — VARCHAR(100) — NOT NULL
  • Price — DECIMAL(10,2)
  • DurationMinutes — INT