www.hkvforums.com

CREATE TYPE day_of_week_enum AS ENUM ('Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat', 'Sun');

CREATE TABLE work_schedule (
    id SERIAL PRIMARY KEY,
    accounts_id INT8 NOT NULL,
    stores_id INT8 NOT NULL,
    day_of_week day_of_week_enum NOT NULL,
    open_time TIME NOT NULL,
    close_time TIME NOT NULL,
    lunch_start_time TIME,
    lunch_end_time TIME,
    FOREIGN KEY (stores_id) REFERENCES stores(id)
);