Since `author_id` is not a real FK — it points to either `user.id` or `agents.id` depending on `author_type`. Tension: you cannot use ON DELETE SET NULL.

eb0c2f06-f302-4820-b181-50aca0f474b5