CREATE TABLE tovar(
id SERIAL PRIMARY KEY,
mnozstvo INTEGER,
typ_tovaru_id INTEGER NOT NULL,
nazov_tovaru VARCHAR(50),
vaha_kusu FLOAT,
cena FLOAT,
znacka VARCHAR(50),
);

DROP TABLE tovar;

CREATE TABLE tovar_v_polici(
id SERIAL PRIMARY KEY,
polica_id INTEGER NOT NULL,
tovar_id INTEGER NOT NULL REFERENCES tovar(id) ON UPDATE CASCADE ON DELETE RESTRICT,
mnozstvo INTEGER
);

DROP TABLE tovar_v_polici;