SQL Generation

Create a new table where I can store how much we pay instructors each month.

CREATE TABLE instructor_payouts ( instructor_id INT REFERENCES users(user_id), payout_month DATE, amount DECIMAL(10, 2), PRIMARY KEY (instructor_id, payout_month) );

CREATE TABLE instructor_payments (
    payment_id SERIAL PRIMARY KEY,
    instructor_id INT REFERENCES users(user_id) NOT NULL,
    payment_month DATE NOT NULL,
    amount DECIMAL(10, 2) NOT NULL,
    status TEXT CHECK (status IN ('pending', 'paid')) DEFAULT 'pending',
    paid_at TIMESTAMP,
    created_at TIMESTAMP DEFAULT NOW(),
    UNIQUE (instructor_id, payment_month)
);