

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'),
('PEZ513532RE', 'Car', 'Mercedes E350 CDI', 2001, '3000cc', 'red', 4000, false, 'OM15645'),
('TZZ04124124', 'Van', 'Mercedes Viano', 2020, '2500cc', 'silver', 30000, true, 'OM15645'),
('BE135135RES', 'Car', 'Porsche 911 GT3', 2016, '4000cc', 'white', 80600, true, 'OP16262'),
('TSR122533E', 'Truck', 'Mercedes Actros', 2013, '12000cc', 'black', 25000, true, 'OM15645'),
('WQT412421E', 'Car', 'Volkswagen Passat', 2010, '2000cc', 'magenta', 11300, true, 'OP16262'),
('WZOTR12421', 'Car', 'Mini Cooper', 2023, '1500cc', 'yellow', 35600, true, 'OB15153'),
('WPY532532EW', 'Motorcycle', 'BMW GS600', 2009, '650cc', 'blue', 8000, true, 'OB15153'),
('WVCR5332531', 'Van', 'VW Crafter', 2007, '3000cc', 'white', 15100, true, 'OP16262'),
('WUS05215125', 'Truck', 'Scania 770', 2020, '13000cc', 'purple', 120000, false, 'OB15153');

insert into payment (Bank, Account, Amount, EMBG, A_Id) values
('NLB', 'TUTMK22-152356135893', 16000, '1507995410210', 1),
('Sparkasse', 'SPKMK33-162316155793', 110000, '2010997410030', 2),
('Stopanska', 'STPMK77-158316637991', 500, '0501987410360', 3),
('NLB', 'TUTMK22-152356135893', 4000, '1507995410210', 4);

insert into agreement (Price, Dependent, Status, Datum, Tax_Nr, P_Id, VIN, EMBG) values
(16000, array['Ivan Miladinov', 'Radica Miladinova'], true, '2023-07-01', 'OB15153', '1', 'WZZ04124124', '1507995410210'),
(110000, array['Risto Mirnovski'], true, '2022-03-15', 'OB15153', '2', 'WUS05215125', '2010997410030'),
(14500, array['Marina Bogoeva'], false, '2021-11-22', 'OP16262', '3', 'WVCR5332531', '0501987410360'),
(4000, array['Stojanka Popova', 'Ana Ancevska'], true, '2019-12-06', 'OM15645', '4', 'PEZ513532RE', '1507995410210');