CREATE TABLE current_schedule (
    tm_id INT NOT NULL,
    tm_name VARCHAR(100) NOT NULL,
    tm_listed_job VARCHAR(100),
    shift_start TIME NOT NULL,
    break_1_time TIME,
    lunch_time TIME,
    break_2_time TIME,
    shift_end TIME NOT NULL,
    current_area INT,
    unassigned CHAR(1) GENERATED ALWAYS AS (CASE WHEN current_area IS NULL THEN 'Y' ELSE 'N' END) STORED,
    PRIMARY KEY (tm_id, shift_start)
);
