Deleting a tag shared between two agreements throws an error

Deleting a tag thats assigned to two or more agreements throws an error.

It looks like the referential integrity on the backend prevents this from happening, wherein it is saying that the tag is being used in another agreement, so it can't be deleted.

update or delete on table "tag" violates foreign key constraint "FKe306eyrll9tc7oxd3dataogyj" on table "subscription_agreement_tag" is the error log on the server. please find the full error log in the text file attached.

A fix to this bug should also be handling the case where the tag assigned to a particular agreement should still persist on it irrespective of the same tag being deleted on an other agreement