RelationDesign: populate_v5.sql

insert into dealership (Tax_Nr, D_Name, Email, Pass, CEO, Telephones, Addresses) values
('OB15153', 'BMW M-Kar', 'contact@bmwmcar.com', 'zyzkeq123', 'Ivan Stojanovski', array['077135651'], array['Kacanicki pat bb']),
('OM15645', 'Mak Auto Star', 'contact@merc.com', '523895nge9g908', 'Ace Nojkov', array['077551311'], array['Bulevar MK 13']),
('OP16262', 'Porsche MK', 'porsche@vwmk.com', 'prsc512532g', 'Stefan Videv', array['071311311', '071898351'], array['Rastanska 55']);

insert into vehicle (VIN, Body, Model, P_Year, Engine, Color, Price, Status, Tax_Nr) values
('WZZ04124124', 'Motorcycle', 'BMW S1000RR', 2015, '999cc', 'white', 16600, false, 'OB15153'),
('WZZ04164123', 'Motorcycle', 'BMW S1000R', 2021, '999cc', 'blue', 21600, false, 'OB15153'),
('WZZ04574121', 'Motorcycle', 'BMW S1000RR', 2024, '999cc', 'red', 28500, false, 'OB15153'),
('WZZ13124666', 'Motorcycle', 'BMW GS310', 2017, '310cc', 'white', 8600, true, 'OB15153'),
('WPY532532EW', 'Motorcycle', 'BMW GS600', 2009, '650cc', 'blue', 5000, true, 'OB15153'),
('PEZ513532RE', 'Car', 'Mercedes E350CDI', 2001, '2998cc', 'red', 4000, false, 'OM15645'),
('PEZ778532MS', 'Car', 'Mercedes C220CDI', 2017, '1999cc', 'purple', 22000, false, 'OM15645'),
('PEZ711532TT', 'Car', 'Mercedes B180CDI', 2012, '1800cc', 'white', 13300, false, 'OM15645'),
('TZZ64127778', 'Van', 'Mercedes Viano', 2020, '2499cc', 'silver', 30000, true, 'OM15645'),
('TZZ04124124', 'Van', 'Mercedes Sprinter', 2020, '3399cc', 'white', 21000, true, 'OM15645'),
('BE135735TTW', 'Car', 'Porsche 911GT3', 2016, '3999cc', 'white', 113600, true, 'OP16262'),
('BE135175XXT', 'Car', 'Porsche 911S', 2012, '2999cc', 'blue', 80600, true, 'OP16262'),
('BE131935SSS', 'Car', 'Porsche Cayman', 2021, '2688cc', 'red', 98600, false, 'OP16262'),
('BE135135RES', 'Car', 'Porsche Cayenne', 2024, '3999cc', 'green', 144500, false, 'OP16262'),
('WQT4124215E', 'Car', 'Volkswagen Passat', 2010, '2000cc', 'magenta', 11300, false, 'OP16262'),
('WZOTY124488', 'Car', 'Mini Cooper', 2023, '1500cc', 'yellow', 35600, true, 'OB15153'),
('WZOTX129991', 'Car', 'Mini Clubman', 2007, '1800cc', 'red', 6600, true, 'OB15153'),
('WZOWR126612', 'Car', 'Mini Cooper', 2024, '1500cc', 'white', 38700, false, 'OB15153'),
('WZOTR121111', 'Car', 'Mini One', 2009, '1999cc', 'blue', 5100, true, 'OB15153'),
('WZOTW126311', 'Car', 'BMW 123d', 2009, '1999cc', 'white', 8900, true, 'OB15153'),
('WZTTR112451', 'Car', 'BMW 330d', 2024, '2999cc', 'red', 87000, true, 'OB15153'),
('WZWTR176789', 'Car', 'BMW 530d', 2017, '2999cc', 'white', 55100, false, 'OB15153'),
('WVCR5332531', 'Van', 'VW Crafter', 2007, '3000cc', 'white', 15100, true, 'OP16262'),
('WUS05215125', 'Truck', 'Scania 770', 2020, '13000cc', 'purple', 120000, false, 'OB15153'),
('TSR1225331E', 'Truck', 'Mercedes Actros', 2013, '12000cc', 'black', 25000, false, 'OM15645'),
('WUS05266546', 'Truck', 'Scania 113', 2008, '13000cc', 'purple', 21000, true, 'OB15153');

insert into client (EMBG, C_Name, Email, Pass, Telephone) values
('1507995410210', 'Stefan Petrov', 'stefan123@gmail.com', 'najjakiot512', null),
('2010997410030', 'Ivana Ristevska', 'ivanar12@gmail.com', 'ristevska123', '077512421'),
('0501987410360', 'Rozana Peralova', 'rozanaper6@hotmail.com', 'rozita553', '075151931'),
('1107977410760', 'Artan Fejzulovski', 'fejzulot9@outlook.com', 'porschekola11', null),
('1107975510760', 'Marina Lazarova', 'martinalaz@gmail.com', 'toysrus123', 0765529856),
('1107357440760', 'Andrea Kapri', 'kaprito@outlook.com', 'kaprihotelnajdobar123', 075437652),
('1176552310760', 'Hristina Kovacevska', 'hristinakova4@outlook.com', 'jassumtukadojdena4123', 077654655),
('1108456710760', 'Andrej Videvski', 'videvski@outlook.com', 'gornatajbt12jbt', 078551273),
('1306999410160', 'Marija Stojanovska', 'marijastojanovska124@gmail.com', 'marijatatata455', '078551831');


insert into agreement (Price, Dependent, Status, Datum, Tax_Nr, VIN, EMBG) values
(16600, array['Ivan Miladinov', 'Radica Miladinova'], true, '2023-01-11', 'OB15153', 'WZZ04124124', '1507995410210'),
(21600, array['Radica Kurcievska'], true, '2023-05-15', 'OB15153', 'WZZ04164123', '1507995410210'),
(28500, array['Ivan Stojanovski'], true, '2023-08-01', 'OB15153', 'WZZ04574121', '2010997410030'),
(120000, array['Risto Mirnovski'], true, '2023-11-15', 'OB15153', 'WUS05215125', '2010997410030'),
(38700, array['Risto Kasapski'], true, '2023-12-22', 'OB15153', 'WZOWR126612', '1107975510760'),
(55100, array['Ratko Korlevski'], true, '2023-07-02', 'OB15153', 'WZWTR176789', '1108456710760'),
(98600, array['Marina Bogoeva'], true, '2023-02-11', 'OP16262', 'BE131935SSS', '1306999410160'),
(144500, array['Marina Bogoeva'], true, '2023-10-10', 'OP16262', 'BE135135RES', '1107977410760'),
(11300, array['Ivan Nasev'], true, '2023-11-22', 'OP16262', 'WQT4124215E', '1107975510760'),
(4000, array['Stojanka Ancevska'], true, '2023-01-06', 'OM15645', 'PEZ513532RE', '1507995410210'),
(22000, array['Ivan Ancevski'], true, '2023-04-26', 'OM15645', 'PEZ778532MS', '1176552310760'),
(13300, array['Ognen Popov'], true, '2023-08-01', 'OM15645', 'PEZ711532TT', '1108456710760'),
(25000, array['Arden Omerit'], true, '2023-09-16', 'OM15645', 'TSR1225331E', '1306999410160');

insert into payment (Bank, Account, Amount, EMBG, A_Id) values
('NLB', 'TUTMK22-152356135893', 16000, '1507995410210', 1),
('NLB', 'TUTMK22-152356135893', 21600, '1507995410210', 2),
('NLB', 'TUTMK22-155236137493', 28500, '2010997410030', 3),
('Sparkasse', 'SPKMK33-174545747793', 120000, '2010997410030', 4),
('Stopanska', 'STPMK77-175845667451', 38700, '1107975510760', 5),
('Stopanska', 'STPMK77-145745745791', 55100, '1108456710760', 6),
('Stopanska', 'STPMK77-197886478491', 98600, '1306999410160', 7),
('Stopanska', 'STPMK77-156865865891', 144500, '1107977410760', 8),
('Stopanska', 'STPMK77-198679345566', 11300, '1107975510760', 9),
('Stopanska', 'STPMK77-664568735476', 4000, '1507995410210', 10),
('Stopanska', 'STPMK77-454745745775', 22000, '1176552310760', 11),
('Stopanska', 'STPMK77-463463466436', 13300, '1108456710760', 12),
('NLB', 'TUTMK22-152356665773', 25000, '1306999410160', 13);