Арм дежурного по станции

INSERT INTO Stations (StationId, StationName, Address) VALUES ('1', 'Красносельская', 'Казань. пр-кт Красноармейский. 54')

INSERT INTO Suppliers (SupplierId, SuplierName, Office, PostAddress, PhoneNumber) VALUES ('2', 'Росуголь пром', 'Москва. улица Сеччина. 87/7', 'Омск. улица Трали. 71/1', '+79031875646')

INSERT INTO Clients (ClientId, ClientName, OKPO, Office, PostAddress, PhoneNumber, StationId) VALUES ('1', 'Савин В. А.', '54', 'Москва. пр-кт Защитников Москвы. 12', 'Москва. пр-кт Кутузовский. 32к1', '88005553535', '2')

INSERT INTO Staff (StaffId, FullName, Post, PhoneNumber, Passport) VALUES ('3', 'Торин Генадий Дуринович', 'Глава отдела логистики', '89631597543', '4571912346')

SELECT * FROM Orders

SELECT * FROM Suppliers

SELECT * FROM Clients

SELECT * FROM Staff

Арм дежурного по сортировочной горке

INSERT INTO Wagons (WagonId, LiftingCapacity, StationId) VALUES ('3', '120', '2')

SELECT * FROM Wagons

SELECT * FROM Product

SELECT * FROM Orders

Арм товарного кассира

INSERT INTO Product (ProductId, ProductName, Volume, Weight, SupplierId) VALUES ('2', 'Уголь древесный', '100', '54', '2')

INSERT INTO Orders (OrderId, Date, Price, WagonId, ArrivalStationId, DepartureStationId, StaffId, ClientId) VALUES ('2', '2021-12-03 09:57:38', '2600000', '2', '1', '2', '3', '4')

INSERT INTO Clients (ClientId, ClientName, OKPO, Office, PostAddress, PhoneNumber, StationId) VALUES ('3', 'Францев А. Р.', '38', 'Москва. улица Алексея Дикого. 41', 'Москва. улица Охотинская. 21', '89321148456', '2')

SELECT * FROM Product

SELECT * FROM Orders

SELECT * FROM Clients

SELECT * FROM Suppliers

АРМ приемосдатчика грузов всех категорий

SELECT * FROM Product

SELECT * FROM Orders

SELECT * FROM Wagons

SELECT * FROM Stations

АРМ оператора пункта осмотра вагонов

INSERT INTO Wagons (WagonId, LiftingCapacity, StationId) VALUES ('1', '520', '1')

INSERT INTO Stations (StationId, StationName, Address) VALUES ('2', 'Нижегородская', 'Москва. улица Пушкина. 11')

SELECT * FROM Wagons

SELECT * FROM Product

SELECT * FROM Stations

АРМ специалиста по актово-претензионной работе

SELECT * FROM Orders

SELECT * FROM Product

SELECT * FROM Staff

SELECT * FROM Stations

SELECT * FROM Wagons

SELECT * FROM Clients

SELECT * FROM Suppliers

АРМ оператора СТЦ

INSERT INTO Orders (OrderId, Date, Price, WagonId, ArrivalStationId, DepartureStationId, StaffId, ClientId) VALUES ('1', '2018-10-08 18:01:55', '1800000', '3', '2', '1', '1', '1' )

INSERT INTO Product (ProductId, ProductName, Volume, Weight, SupplierId) VALUES ('1', 'Чипсы. Lays с луком. 200г', '34', '3', '1')

INSERT INTO Stations (StationId, StationName, Address) VALUES ('1', 'Красносельская', 'Казань. пр-кт Красноармейский. 54')

INSERT INTO Wagons (WagonId, LiftingCapacity, StationId) VALUES ('1', '520', '1')

INSERT INTO Clients (ClientId, ClientName, OKPO, Office, PostAddress, PhoneNumber, StationId) VALUES ('4', 'Юсифов Э. С.', '147', 'Москва. пр-кт Потапенько. 23/4', 'Москва. пр-кт Потапенько. 23/4', '89751642524', '1')

INSERT INTO Suppliers (SupplierId, SuplierName, Office, PostAddress, PhoneNumber) VALUES ('1', 'Lays. CO', 'St. Rithm. 41/7. USA. CA.', 'London. Maddison square. 108', '+38421567465')

SELECT * FROM Stations

SELECT * FROM Wagons

SELECT * FROM Orders