RelationDesign: populate_v6.sql

insert into dealership (Tax_Nr, D_Name, Brands, Email, Pass, Director, Telephones, Addres) values
('BM15153', 'BMW M-Kar', array['BMW', 'MINI'], 'contact@bmwmcar.com', 'zyzkeq123', 'Ivan Stojanovski', array['077135651'], 'Kacanicki pat bb'),
('ME15645', 'Mak Auto Star', array['Mercedes', 'SMART'], 'contact@merc.com', '523895nge9g908', 'Ace Nojkov', array['077551311'], 'Bulevar MK 13'),
('PO16262', 'Porsche MK', array['Porsche', 'Audi', 'Volkswagen'], 'porsche@vwmk.com', 'prsc512532g', 'Stefan Videv', array['071311311', '071898351'], 'Rastanska 55');

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

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 (A_Id, Price, Status, Datum, Tax_Nr, VIN, EMBG) values
('13A533B', 16600, true, '2023-01-11', 'BM15153', 'WZZ04124124', '1507995410210'),
('16C533B', 21600, true, '2023-05-15', 'BM15153', 'WZZ04164123', '1507995410210'),
('13A674A', 28500, true, '2023-08-01', 'BM15153', 'WZZ04574121', '2010997410030'),
('13543HH', 120000, true, '2023-11-15', 'BM15153', 'WUS05215125', '2010997410030'),
('19832H8', 38700, true, '2023-12-22', 'BM15153', 'WZOWR126612', '1107975510760'),
('1870G8F', 55100, true, '2023-07-02', 'BM15153', 'WZWTR176789', '1108456710760'),
('12223G3', 98600, true, '2023-02-11', 'PO16262', 'BE131935SSS', '1306999410160'),
('189523G', 144500, true, '2023-10-10', 'PO16262', 'BE135135RES', '1107977410760'),
('2532G7G', 11300, true, '2023-11-22', 'PO16262', 'WQT4124215E', '1107975510760'),
('83252GG', 4000, true, '2023-01-06', 'ME15645', 'PEZ513532RE', '1507995410210'),
('67FAS55', 22000, true, '2023-04-26', 'ME15645', 'PEZ778532MS', '1176552310760'),
('43F77FD', 13300, true, '2023-08-01', 'ME15645', 'PEZ711532TT', '1108456710760'),
('38G843F', 25000, true, '2023-09-16', 'ME15645', 'TSR1225331E', '1306999410160');

insert into payment (Bank, IBAN, Amount, EMBG, A_Id) values
('NLB', 'TUTMK22-152356135893', 16000, '1507995410210', '13A533B'),
('NLB', 'TUTMK22-152356135893', 21600, '1507995410210', '16C533B'),
('NLB', 'TUTMK22-155236137493', 28500, '2010997410030', '13A674A'),
('Sparkasse', 'SPKMK33-174545747793', 120000, '2010997410030', '13543HH'),
('Stopanska', 'STPMK77-175845667451', 38700, '1107975510760', '19832H8'),
('Stopanska', 'STPMK77-145745745791', 55100, '1108456710760', '1870G8F'),
('Stopanska', 'STPMK77-197886478491', 98600, '1306999410160', '12223G3'),
('Stopanska', 'STPMK77-156865865891', 144500, '1107977410760', '189523G'),
('Stopanska', 'STPMK77-198679345566', 11300, '1107975510760', '2532G7G'),
('Stopanska', 'STPMK77-664568735476', 4000, '1507995410210', '83252GG'),
('Stopanska', 'STPMK77-454745745775', 22000, '1176552310760', '67FAS55'),
('Stopanska', 'STPMK77-463463466436', 13300, '1108456710760', '43F77FD'),
('NLB', 'TUTMK22-152356665773', 25000, '1306999410160', '38G843F');