Duration
17s
Input Tokens
1108
Output Tokens
1457
Cost
$0.00
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 NOT NULL REFERENCES users(user_id), payment_month DATE NOT NULL, amount DECIMAL(10, 2) NOT NULL, paid_at TIMESTAMP DEFAULT NOW(), notes TEXT, UNIQUE (instructor_id, payment_month));