1 -- @tag: requirement_spec_parts
2 -- @description: Artikelzuweisung zu Pflichtenheften
3 -- @depends: release_3_1_0
4 CREATE TABLE requirement_spec_parts (
6 requirement_spec_id INTEGER NOT NULL,
7 part_id INTEGER NOT NULL,
8 unit_id INTEGER NOT NULL,
9 qty NUMERIC(15, 5) NOT NULL,
10 description TEXT NOT NULL,
11 position INTEGER NOT NULL,
14 FOREIGN KEY (requirement_spec_id) REFERENCES requirement_specs (id),
15 FOREIGN KEY (part_id) REFERENCES parts (id),
16 FOREIGN KEY (unit_id) REFERENCES units (id)