Manager creates and assigns shift

Actors

• Manager

Steps in the Scenario

1. Manager logs in.

SELECT u.email, u.password FROM users u WHERE u.email = ?; -- and password application check

2. Manager sees the created shifts.

SELECT date, start_time, end_time FROM shifts WHERE manager_id = %s AND date >= current_date

3. Manager creates shift for the following week for employees.

INSERT INTO shifts(id, date, start_time, end_time, manager_id) VALUES (1, '2025-01-05', '08:00:00', '17:00:00', 3)

4. Manager assigns shifts to employees

INSERT INTO assignments(id, manager_id, employee_id, shift_id) VALUES (1, 3, 1, 1)