Создать триггер на мутацию

CREATE TABLE producers
 (ID_producer NUMBER(4) CONSTRAINT pk_producer PRIMARY KEY,
   country_producer VARCHAR2(100),
   producer_brend VARCHAR2(30),
   contact_information VARCHAR2(100) );
 
 
 
CREATE TABLE category_commodity(ID_category NUMBER(4) CONSTRAINT pk_category PRIMARY KEY,
  category_commodity VARCHAR2(100),
  inform_commodity VARCHAR2(100))
 
 
CREATE TABLE catalog
(ID_commodity NUMBER (4) CONSTRAINT pk_catalog PRIMARY KEY,
 id_category NUMBER (4) CONSTRAINT ref_catalog_category_commodity REFERENCES category_commodity(id_category),
 name_commodity VARCHAR2(100),
 article  VARCHAR2(100),
 id_producer NUMBER (4) CONSTRAINT ref_catalog_producers REFERENCES producers(id_producer),
 color  VARCHAR2(100),
 information_commodity  VARCHAR2(100))
 
 
 
CREATE TABLE purchase
( id_purchase  NUMBER (4) CONSTRAINT pk_purchase PRIMARY KEY,
  date_purchase DATE,
  discount NUMBER (4))
 
 
CREATE TABLE boughtcom(
id_bought_com NUMBER(4) CONSTRAINT pk_boughtcom PRIMARY KEY,
id_purchase NUMBER(4)CONSTRAINT ref_boughtcom_purchase REFERENCES purchase(id_purchase),
ID_commodity NUMBER(4)CONSTRAINT ref_boughtcom_catalog REFERENCES catalog(id_commodity),
size_com NUMBER(4),
amount_bought  NUMBER(4),
purchase_price  NUMBER(4),
information VARCHAR2(100))
 
 
 
CREATE TABLE sale (
id_sale NUMBER(4) CONSTRAINT pk_sale PRIMARY KEY,
date_sale DATE,
id_bought_com NUMBER(4)CONSTRAINT ref_sale_boughtcom REFERENCES boughtcom(id_bought_com),
amount_com  NUMBER(4),
discount  NUMBER(4))
 
 
 
CREATE TABLE markups (
id_mark NUMBER(4) CONSTRAINT pk_mark_ups PRIMARY KEY,
id_purchase NUMBER(4)CONSTRAINT ref_markups_purchase REFERENCES purchase(id_purchase),
id_category NUMBER(4)CONSTRAINT ref_markups_category_commodity REFERENCES category_commodity(id_category),
mark_ups_percent NUMBER(4),
information_marks VARCHAR2(100))
 
 
CREATE TABLE shop (
id_shop NUMBER(4) CONSTRAINT pk_shop  PRIMARY KEY,
id_sale NUMBER(4)CONSTRAINT ref_shop_sale REFERENCES sale(id_sale),
name_shop VARCHAR2(100),
location VARCHAR2(100),
proprietor VARCHAR2(100))