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 (
id SERIAL PRIMARY KEY,
instructor_id INT NOT NULL REFERENCES users(user_id),
pay_month DATE NOT NULL,
amount NUMERIC(12, 2) NOT NULL,
currency CHAR(3) NOT NULL DEFAULT 'USD',
paid_at TIMESTAMP WITHOUT TIME ZONE DEFAULT NOW(),
payment_method TEXT,
CONSTRAINT uniq_instructor_monthly_pay UNIQUE (instructor_id, pay_month)
);