1 -- @tag: assembly_inventory_part
2 -- @description: Tabelle für die wirklich verbauten Einzelteile eines Erzeugnis
3 -- @depends: warehouse release_3_5_6_1
6 CREATE TABLE assembly_inventory_part (
7 inventory_part_id INTEGER REFERENCES inventory(id),
8 inventory_assembly_id INTEGER REFERENCES inventory(id),
9 itime TIMESTAMP DEFAULT now(),
12 PRIMARY KEY (inventory_assembly_id, inventory_part_id)
15 CREATE TRIGGER mtime_assembly_inventory_part BEFORE UPDATE ON assembly_inventory_part FOR EACH ROW EXECUTE PROCEDURE set_mtime();