Replace invalid sharding key for ai_duo_chat_events table

The personal_namespace_id is currently used as a sharding key in the ai_duo_chat_events table. However, due to ongoing work to make UserNamespace optional (see Epic #12179), this field can be NULL and therefore cannot be used as a sharding key.

Proposed Solution

Replace the current sharding key with one of the following alternatives:

  • project_id
  • group_id
  • namespace_id (excluding user personal namespace)
  • organization_id

References

Description was generated using AI

Edited by Shane Maglangit