Peachyforum

CREATE TABLE peaches ( id SERIAL PRIMARY KEY, user_id INT REFERENCES users(id), post_id INT REFERENCES posts(id), reason VARCHAR(20) CHECK (reason IN ('helpful', 'kind', 'insightful')), created_at TIMESTAMP DEFAULT NOW(), UNIQUE(user_id, post_id) -- One peach per user per post );