RelationModel: polnenje_v3.sql

insert into lokacii (adresa,cena)
values ('adresa1',1000), ('adresa2',200), ('adresa3',500);

insert into korisnici (datum_kreiran, ime, username, lozinka, tel_broj)
values ('01.01.2021', 'user1', 'user1', 'lozinka1', '072456511'),
( '03.29.2019', 'admin1', 'admin1', 'lozinka2', '072455693'),
( '04.21.2020', 'admin2', 'admin2', 'lozinka3', '078135667'),
( '10.01.2020', 'user2', 'user2', 'lozinka4', '071345678'),
( '03.12.2018', 'bend1', 'bend1', 'lozinka5', '075266631'),
('07.03.2022', 'ketering3', 'ketering3', 'lozinka6', '075211566'),
( '09.12.2021', 'fotograf1', 'fotogoraf1', 'lozinka7', '076346213'),
( '02.02.2019', 'user3', 'user3', 'lozinka8', '073098178'),
( '02.12.2020', 'ketering2', 'ketering2', 'lozinka9', '072455693'),
( '04.24.2020', 'bend2', 'bend2', 'lozinka10', '075266631'),
( '03.01.2011', 'kelner1', 'kelner1', 'lozinka11', '073098178'),
( '09.22.2003', 'kelner2', 'kelner2', 'lozinka12', '072455693'),
( '01.29.2015', 'fotograf2', 'fotograf2', 'lozinka13', '075266631'),
( '03.29.2016', 'admin3', 'admin3', 'lozinka14', '078135667'),
( '09.10.2013', 'kelner3', 'kelner3', 'lozinka15', '075266631'),
( '05.26.2010', 'fotograf3', 'fotograf3', 'lozinka16', '071345678'),
( '03.17.2016', 'ketering1', 'ketering1', 'lozinka17', '078135667'),
( '08.30.2019', 'bend3', 'bend3', 'lozinka18', '073098178');

insert into keterinzi (korisnik_id, cena, adresa)
values (6, 300, 'ulica1_ketering'),
(9, 400,'ulica2_ketering'),
(17, 500, 'ulica 3_ketering');

insert into klienti (korisnik_id_korisnici, br_organizirani_nastani, korisnik_id_keterinzi)
values (1, 1, 9), (4, 6, 17),(8, 0, 6);

insert into admini (korisnik_id, br_organizirani_nastani)
values (2, 1), (3, 10), (14, 4);

insert into nastani (status, vreme, tip, datum, opis,adresa, korisnik_id_admini,korisnik_id_klienti)
values ('zapocnat', '20:00', 'rodenden', '05.26.2010', 'rodenden na otvoreno', 'adresa1', 2, 1), 
('potvrden', '19:00', 'svadba',  '08.30.2019', 'svadbena proslava', 'adresa2', 3, 4),
('zapocnat', '20:00', 'matura', '01.29.2015', 'SUGS Georgi Dimitrov', 'adresa3', 14, 8);

insert into bendovi (korisnik_id, cena)
values (5, 1000),
(10, 500),
(18, 800);

insert into fotografi (korisnik_id, cena, portfolio)
values (7, 200, 'Corporate photography'),
(13, 300, 'Wedding photography'),
(16, 180, 'Sports photography');

insert into kelneri (korisnik_id_korisnici, slobodni_denovi, god_iskustvo, korisnik_id_keterinzi)
values (11, 2, 1, 6), 
(15, 1, 4, 9),
(12, 3, 10, 17);

insert into produkti (produkt_id, ime)
values ('1', 'salata'),
('2', 'vino'),
('3', 'viski'),
('4', 'torta'),
('5', 'piroshki'),
('6', 'sok');

insert into hrana (produkt_id, vegetarijansko, kalorii, vegan)
values (1, true, '100', true),
(4, true, null, false),
(5, false, null, false);

insert into pijaloci (produkt_id, dali_alkoholen, procenti_alkohol)
values (2, true, 13),
(3, true, 35),
(6, false, null);

insert into tel_broj (adresa, tel_broj)
values ('adresa2', '072156632'), 
('adresa3', '077112356'),
('adresa1','074211238');

insert into alergeni (produkt_id, alergeni)
values ('1', 'null'), ('4', 'mleko'), ('5','kashkaval');

insert into bend_sviri_nastan (korisnik_id, nastan_id, status)
values (5,1,'zapocnat'), (10,3,'zapocnat'),(18,2,'potvrden')

insert into fotograf_slika_nastan (korisnik_id, nastan_id, status)
values (7,1,'zapocnat'), (16,2,'potvrden'), (13,3,'potvrden')

insert into kelner_raboti_na_nastan (korisnik_id, nastan_id, status)
values (12,1,'potvrden'), (15,1,'potvrden'), (11,2,'potvrden')

insert into ketering_nudi_produkt (korisnik_id, produkt_id)
values (17,2), (6,2), (9,3), (17,1), (6,4), (9,5), (17,3), (6,6), (9,2)

insert into ketering_rezervira_nastan (korisnik_id, nastan_id, status, kolicina)
values (6,1,'potvrden',1), (9,2,'potvrden',1), (17,3,'potvrden',1)