ALTER TABLE destructionnotice
ADD COLUMN product_id INTEGER;

ALTER TABLE destructionnotice
ADD CONSTRAINT fk_destruction_product
FOREIGN KEY (product_id)
REFERENCES crops (id)
ON DELETE SET NULL;

ALTER TABLE destructionnotice
ADD COLUMN weight_destroyed FLOAT;