✨ Add archived event handling for event reviews

Implement logic to transfer event reviews to archived events and update database schema accordingly. Ensure event reviews can exist without an associated event.