Clean up schema for table chat_teams

Everyone can contribute. Help move this issue forward while earning points, leveling up and collecting rewards.

  • Close this issue

From https://gitlab.com/gitlab-com/infrastructure/issues/1709 (private to GitLab employees):

  • Empty table
  • Wrong data type: created_at should be timestamptz
  • Wrong data type: updated_at should be timestamptz
  • Missing contraint: team_id NOT NULL
  • Missing contraint: name NOT NULL (if necessary)
  • Duplicate data: team_id implies name, might not be necessary?
  • Missing foreign key: team_id (with a cascading delete)
Edited Sep 13, 2025 by 🤖 GitLab Bot 🤖
Assignee Loading
Time tracking Loading