| 1 |
CREATE TABLE reports ( |
| 2 |
id UUID PRIMARY KEY DEFAULT gen_random_uuid(), |
| 3 |
reporter_user_id UUID NOT NULL REFERENCES users(id), |
| 4 |
target_type TEXT NOT NULL, |
| 5 |
target_id UUID NOT NULL, |
| 6 |
report_type TEXT NOT NULL, |
| 7 |
reason TEXT NOT NULL DEFAULT '', |
| 8 |
status TEXT NOT NULL DEFAULT 'open', |
| 9 |
admin_notes TEXT, |
| 10 |
resolved_by UUID REFERENCES users(id), |
| 11 |
created_at TIMESTAMPTZ NOT NULL DEFAULT NOW(), |
| 12 |
resolved_at TIMESTAMPTZ |
| 13 |
); |
| 14 |
|
| 15 |
CREATE INDEX idx_reports_status ON reports(status); |
| 16 |
CREATE INDEX idx_reports_target ON reports(target_type, target_id); |
| 17 |
|