Putting a foreign key on the table 'extensions' for the field 'context'

Description

Fact: when a tenant is deleted, their contexts are deleted too.

But we may have an issue with the ‘extensions’ => the extensions resources are not properly removed when the tenant is deleted.

The table ‘extensions' contains a field context without a foreign key pointing to the table ‘context’.

Setting up a foreign key here will allow the database to automatically delete the extensions when a context is deleted.

With a foreign key, the extensions will be deleted when the related context will be deleted

Zendesk Ticket IDs

None

has to be done after

Activity

Show:
Done

Details

Priority

Assignee

Reporter

Approvers

Sébastien Duthil

Fix versions

Sprint

Zendesk Support

Created July 26, 2023 at 1:08 PM
Updated September 20, 2023 at 5:57 PM
Resolved September 18, 2023 at 8:18 PM

Flag notifications