Untitled

CREATE TABLE Menu_Item_Price (
    id SERIAL PRIMARY KEY,
    menu_item_id INT NOT NULL,
    channel_id INT NOT NULL,
    store_type_id INT NOT NULL,
    daypart_id INT NOT NULL,
    weekpart_id INT NOT NULL,
    publish_price DECIMAL NOT NULL,
    base_price DECIMAL NOT NULL,
    created_at DATETIME NOT NULL,
    updated_at DATETIME NOT NULL,
    job_id INT,
    user_id INT,
    approved BOOLEAN DEFAULT FALSE,
    approved_by INT,
    approved_at DATETIME,
    published BOOLEAN DEFAULT FALSE,
    published_by INT,
    published_at DATETIME,
    FOREIGN KEY (menu_item_id) REFERENCES Menu_Item(id),
    FOREIGN KEY (channel_id) REFERENCES Channels(id),
    FOREIGN KEY (store_type_id) REFERENCES Store_Types(id),
    FOREIGN KEY (daypart_id) REFERENCES Dayparts(id),
    FOREIGN KEY (weekpart_id) REFERENCES Weekparts(id),
    FOREIGN KEY (job_id) REFERENCES Jobs(id),
    FOREIGN KEY (user_id) REFERENCES Users(id),
    FOREIGN KEY (approved_by) REFERENCES Users(id),
    FOREIGN KEY (published_by) REFERENCES Users(id)
);


CREATE TABLE Jobs (
    id SERIAL PRIMARY KEY,
    job_name VARCHAR(255) NOT NULL,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    status VARCHAR(50) NOT NULL
);

CREATE TABLE Users (
    id SERIAL PRIMARY KEY,
    username VARCHAR(255) NOT NULL,
    email VARCHAR(255) NOT NULL,
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
);