CREATE TABLE categories (
id INT PRIMARY KEY,
title VARCHAR(64)
);
INSERT INTO categories VALUES (1, 'Cat1'),(2, 'Cat2');
CREATE TABLE prices (
id INT PRIMARY KEY,
title VARCHAR(64),
price DECIMAL(9, 2),
type VARCHAR(64),
category_id INT REFERENCES categories(id)
);
INSERT INTO prices VALUES
(1, 'Price1', 10.2, 'kg', 1),
(2, 'Price2', 20.2, 'm2', 2);