sqlite> .schema view_user_service
CREATE VIEW view_user_service as
  select us.rowid as rowid, us.*,
  (select value from plan_attribute where plan_id=p.id and arg='cost' and delete_date IS NULL) as cost,
  s.hw_type,s.hw_name,uc.number as contract,uc.id as contract_id,s.plan_id,p.provider_id,uc.user_id,s.name
  from user_service as us, service as s,user_contract as uc,plan as p
  where us.user_contract_id=uc.id and us.service_id=s.id and s.plan_id=p.id;
CREATE TRIGGER view_user_service_delete instead of delete on view_user_service
begin
  update user_service set delete_date=julianday('now') where id=OLD.id and delete_date is null;
  update user_service_hw set delete_date=julianday('now') where user_service_id=OLD.id and delete_date is null;
  update user_service_balance set delete_date=julianday('now') where user_service_id=OLD.id and delete_date is null;
end;
CREATE TRIGGER view_user_service_insert instead of insert on view_user_service
begin
  insert into user_service (user_contract_id,service_id,note,is_active,is_main)
    values (NEW.user_contract_id,NEW.service_id,NEW.note,NEW.is_active,NEW.is_main);
end;
CREATE TRIGGER view_user_service_update instead of update on view_user_service
begin
  update user_service set
    user_contract_id=NEW.user_contract_id,
    service_id=NEW.service_id,
    note=NEW.note,
    is_active=NEW.is_active,
    is_main=NEW.is_main
  where id=NEW.id;
end;