Use-case 0008 - Book Photographer

Initiating actor: Bride / Groom (Wedding owner)

Other actors: Wedding Organizer (Assistant)

Description

The user reserves a photographer for the wedding day. The booking is recorded with date, time range, status and links the photographer to a wedding.

Scenario

1. The user opens the "Photographers" section.
2. The system lists photographers.

SET search_path TO project;

SELECT photographer_id, name, email, phone_number, price_per_hour
FROM photographer
ORDER BY name;

3. The user selects a photographer and clicks "Book".
4. The system displays a booking form.
5. The user submits booking.
6. The system saves the booking in the database.

SET search_path TO project;

INSERT INTO photographer_booking("date", start_time, end_time, status, photographer_id, wedding_id)
VALUES (:date, :start_time, :end_time, :status, :photographer_id, :wedding_id)
RETURNING booking_id;

7. The system confirms booking and displays booking details.