Fix database action relation ship

[flvndvd]

We should set the right relation ships in our data base to prevent deleting data source views and vaults that would still be used by assistants.

The most likely forward path here is to set ON DELETE RESTRICT.

First occurence to fix is reverting: #6676.

[flvndvd]

Any progress on this @fontanierh?

[spolu]

What model are we talking about? AgentQueryTableConfigurationTable or something else?

[fontanierh]

TBH this slipped a bit, I need to understand if this is still relevant (a bunch of related code has moved quite a bit these past weeks)

[flvndvd]

The main one to fix was AgentDataSourceConfiguration but we wanted to run a proper check on all those recent updates to ensure they are not cascade.

[spolu]

The one that matters is **ConfigurationTable in the context of data sources and this one is aligned with the retrieval approach: restrict with explicit check and deletes AFAICT.

[spolu]

But maybe this is not a data source only convo?

[fontanierh]

@flvndvd I think this is OK to close no ?

[flvndvd]

Assigning to self, will do a final pass.