kivitendo/sql/Pg-upgrade2/stocktakings.sql @ 90b47258
| dc3382e8 | Bernd Bleßmann | -- @tag: stocktakings
|
||
-- @description: Tabelle für in einer Inventur gezählte Artikel
|
||||
| 13ef42d7 | Bernd Bleßmann | -- @depends: warehouse release_3_5_1
|
||
| dc3382e8 | Bernd Bleßmann | |||
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();
|