Implement chain soft delete

[ggarri]

Deleting chain's information might cause the loss of important information regarding faucets, jobs, transactions, and artifacts. The goal of this task is to support the soft deletion of chains.

• Implement soft delete in Chain table
• Allow users query including deleted chains
• Internal calls can still use deleted chains for internal execution flows if it is required

In addition, once soft delete is ready we should restrict chain hard delete if there are jobs linked to it:

ALTER TABLE jobs
	ADD CONSTRAINT jobs_chain_uuid_fkey FOREIGN KEY (chain_uuid) REFERENCES chains (uuid) ON DELETE RESTRICT;