Put in place foreign keys for all the Wazo resources in the sqlalchemy models

Description

First direct benefit: the deletion process for a tenant could be simplified (with foreign keys between the Wazo resources, we would just need to delete the tenant and all the related resources would be deleted too)

Note: We must add Alembic scripts too for the DB migration.

Zendesk Ticket IDs

None

Activity

Show:

Charles Langlois April 4, 2024 at 6:59 PM

considerations

  • performance impact(indexes on candidate foreign keys)

  • remove existing logic for delete propagation

Details

Priority

Assignee

Reporter

Story Points

Labels

Zendesk Support

Created June 20, 2023 at 5:49 PM
Updated April 4, 2024 at 6:59 PM