Input Tokens
0
Output Tokens
0
Duration
0
Cost
0
Context
Input
Create a new table where I can store how much we pay instructors each month.Expected output
CREATE TABLE instructor_payouts ( instructor_id INT REFERENCES users(user_id), payout_month DATE, amount DECIMAL(10, 2), PRIMARY KEY (instructor_id, payout_month) );Model output
CREATE TABLE instructor_monthly_payments (
payment_id SERIAL PRIMARY KEY,
instructor_id INT REFERENCES users(user_id),
payment_month INT CHECK (payment_month BETWEEN 1 AND 12) NOT NULL,
payment_year INT NOT NULL,
amount DECIMAL(10, 2) NOT NULL,
paid_at TIMESTAMP DEFAULT NOW(),
notes TEXT,
UNIQUE (instructor_id, payment_month, payment_year)
);