Design the table to store the actual civic issues reported by the public.
- Create a reports table (id, category_id, subcategory_id, description, image_url, latitude, longitude, status, entity_id, created_at).
- Note: entity_id should be nullable for now, as the Agentic System will populate this later. status should default to pending.
- Write the up and down SQL migration files.
Design the table to store the actual civic issues reported by the public.