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