dbt=> CREATE TABLE dates (
id SERIAL PRIMARY KEY,
device VARCHAR,
inventory VARCHAR,
office INT,
quantity INT,
date TIMESTAMP
);
CREATE TABLE
dbt=> INSERT INTO dates (device, inventory, office, quantity, date)
VALUES ('ATC', '0675', '10', '1', '2017-12-12 12:12:12'),
('Интерактивная доска', '8988', '10', '1', '2017-12-12 12:12:12'),
('Колонки', '4557', '10', '1', '2017-12-12 12:12:12'),
('Компьютер', '7867', '10', '1', '2017-12-12 12:12:12'),
...
('Компьютер', '2344', '104', '1', '2022-02-12 12:12:12'),
('Интерактивная доска', '6768', '104', '1', '2017-12-12 12:12:12'),
('Колонки', '4557', '104', '1', '2017-12-12 12:12:12'),
('Сетевой фильтр', NULL, '104', '1', '2017-12-12 12:12:12');
dbt=> SELECT * FROM dates;
id | device | inventory | office | quantity | date
----+----------------------------------------+--------------------+--------+----------+---------------------
1 | ATC | 0675 | 10 | 1 | 2017-12-12 12:12:12
2 | Интерактивная доска | 8988 | 10 | 1 | 2017-12-12 12:12:12
3 | Колонки | 4557 | 10 | 1 | 2017-12-12 12:12:12
...
36 | Интерактивная доска | 6768 | 104 | 1 | 2017-12-12 12:12:12
37 | Колонки | 4557 | 104 | 1 | 2017-12-12 12:12:12
38 | Сетевой фильтр | | 104 | 1 | 2017-12-12 12:12:12
(38 строк)
CREATE TABLE devices (
id SERIAL PRIMARY KEY,
device VARCHAR,
inventory VARCHAR
);
CREATE TABLE buildings (
id SERIAL PRIMARY KEY,
buildings VARCHAR
);
CREATE TABLE offices (
id SERIAL PRIMARY KEY,
building_id INT REFERENCES buildings(id),
office VARCHAR,
inventory VARCHAR
);
CREATE TABLE inventories (
device_id INT REFERENCES devices(id),
office_id INT REFERENCES offices(id),
quantity INT,
updated_at DATE,
PRIMARY KEY (device_id)
);