|
-- @tag: stocktakings
|
|
-- @description: Tabelle für in einer Inventur gezählte Artikel
|
|
-- @depends: warehouse release_3_5_1
|
|
|
|
|
|
CREATE TABLE stocktakings (
|
|
id INTEGER NOT NULL DEFAULT nextval('id'),
|
|
inventory_id INTEGER REFERENCES inventory(id),
|
|
warehouse_id INTEGER NOT NULL REFERENCES warehouse(id),
|
|
bin_id INTEGER NOT NULL REFERENCES bin(id),
|
|
parts_id INTEGER NOT NULL REFERENCES parts(id),
|
|
employee_id INTEGER NOT NULL REFERENCES employee(id),
|
|
qty NUMERIC(25,5) NOT NULL ,
|
|
comment TEXT,
|
|
chargenumber TEXT NOT NULL DEFAULT '',
|
|
bestbefore DATE,
|
|
cutoff_date DATE NOT NULL,
|
|
itime TIMESTAMP DEFAULT now(),
|
|
mtime TIMESTAMP,
|
|
|
|
PRIMARY KEY (id)
|
|
);
|
|
|
|
CREATE TRIGGER mtime_stocktakings BEFORE UPDATE ON stocktakings FOR EACH ROW EXECUTE PROCEDURE set_mtime();
|