LogicDesign: polnenje_podatoci_final.sql

insert into vraboteni (ime,prezime,embg,datum_ragjanje,obrazovanie)
values('Kjazim','Demirov','1205996649005',to_date('19960512','YYYYMMDD'),'Sredno Strucno Obrazovanie'),
('Trajko','Petkov','0203970560556',to_date('19700302','YYYYMMDD'),'Diplomiran Inziner'),
('Marko', 'Markov','1806985960665',to_date('19850618','YYYYMMDD'),'Sredno Strucno Obrazovanie'),
('Finki','Finkov','1204970123003',to_date('19700412','YYYYMMDD'),'Sredno Obrazovanie'),
('Petko','Trajkov','3004987234009',to_date('19870430','YYYYMMDD'),'Osnovno Obrazovanie'),
('Marija','Mariovska','2708978567002',to_date('19780827','YYYYMMDD'),'Magister za mebel i enterier'),
('Fatima','Fatimovska','2404988123008',to_date('19880424','YYYYMMDD'),'Dipromiran mashinski inziner');

insert into menadzeri (id_vraboten)
values
(2),
(3);
insert into direktor (id_vraboten)
values
(6);
insert into magacioneri (id_vraboten)
values(1);
insert into shefovi (id_vraboten)
values(7);
insert into vraboteni_vo_proizvodstvo (id_vraboten)
values(4),(5);
insert into korisnik (korisnicko_ime,lozinka,"role")
values('kdemirov','kd','ROLE_WAREHOUSEMAN'),
('tpetkov','tp','ROLE_MANAGER'),
('mmarkov','mm','ROLE_MANAGER'),
('mmariovska','mm','ROLE_DIRECTOR'),
('ffatimovska','ff','ROLE_CHIEF');
insert into delovi (vid_na_del,cena)
values('zadna noga houston',150),('predna noga houston',150),('sediste houston',150),('naslon houston',200),('sprosna gurga',50),('kapak gurga',50);
insert into materijali (velicina,naziv,dostapen_broj)
values
(10,'ramna ploca otpresok',300),
(15,'ramna ploca otrpesok',300),
(10,'tabu otpresok',150),
(15,'tabu otpresok',150),
(15,'luis otpresok',200),
(10,'napoli otpresok',200);
insert into mashini (naziv)
values
('cnc 530'),('banzik'),('cetkara'),('dreban'),('busalki'),('masina za glancanje');
insert into oddelenija (naziv)
values
('masinsko'),('tapacersko'),('lakirnica'),('sklopnica');
insert into mebel(tip,naziv,cena)
values('stol','semifredo',900),
('stol','gurga',1100),
('stol','houston',1200),
('masa','dinner table',15000);
insert into klienti (korisnicko_ime,lozinka,ime,prezime,"role")
values
('amedov','am','Ahmet','Amedov','ROLE_CLIENT'),
('jdoe','jd','John','Doe','ROLE_CLIENT'),
('rredington','rr','Reymond','Reddington','ROLE_CLIENT');

insert into nalozi(pocetna_data,krajna_data,id_vraboten)
values(to_date('20210312','YYYYMMDD'),to_date('20210319','YYYYMMDD'),2),
(to_date('20210301','YYYYMMDD'),to_date('20210308','YYYYMMDD'),3),
(now(),null,2);

insert into naracka (naslov,opis,id_klient,datum_napravena,datum_isporacana)
values
('Stolovi za bar cafe','Potrebni stolovi za bar cafe Houston',1,now(),null),
('Stolovi za meana','Potrebni stolovi za meana',2,to_date('20210312','YYYYMMDD'),null),
('Masa za vecera','Obicna masa za vecera boja so obicen lak',3,to_date('20210301','YYYYMMDD'),now());

insert into dogovori (id_vraboten,aktiven,pocetok,kraj,plata)
values
(1,1,to_date('12092018','DDMMYYYY'),to_date('12092022','DDMMYYYY'),14500),
(2,1,to_date('12092018','DDMMYYYY'),to_date('12092022','DDMMYYYY'),18500),
(3,1,to_date('12092018','DDMMYYYY'),to_date('12092022','DDMMYYYY'),18500),
(4,1,to_date('12092018','DDMMYYYY'),to_date('12092022','DDMMYYYY'),14500),
(5,1,to_date('12092018','DDMMYYYY'),to_date('12092022','DDMMYYYY'),14500),
(6,1,to_date('12092018','DDMMYYYY'),to_date('12092022','DDMMYYYY'),22500),
(7,1,to_date('12092018','DDMMYYYY'),to_date('12092022','DDMMYYYY'),18500);


insert into evidencija_na_naracki (datum,id_naracka)
values
(to_date('13032021','DDMMYYYY'),2),
(to_date('14032021','DDMMYYYY'),2),
(to_date('15032021','DDMMYYYY'),2),
(to_date('02032021','DDMMYYYY'),3),
(to_date('03032021','DDMMYYYY'),3),
(to_date('04032021','DDMMYYYY'),3),
(to_date('05032021','DDMMYYYY'),3);

insert into ima_napraveno_servis (id_mashina,datum,zabeleska,cena)
values
(1,to_date('12032021','DDMMYYYY'),'Popravka na motor na pumpa za vakum',18000),
(2,to_date('01022021','DDMMYYYY'),'Zamena na mehanizmot',9000),
(4,to_date('30012021','DDMMYYYY'),'Popravka na drzac za dreban',12000);

insert into naracka_se_sostoi_od_mebel (id_mebel,id_naracka,kolicina)
values(3,1,100),(2,2,120),(4,3,1);

insert into dopolniteli_delovi_za_naracka (id_naracka,id_del,kolicina)
values(1,1,2),(1,2,2),(2,1,2),(2,2,2);

insert into mebel_se_sostoi_od_delovi (id_mebel,id_del,kolicina)
values
(1,1,2),(1,2,2),(1,3,1),(1,4,1),(2,1,2),(2,2,2),(2,3,1),(2,4,1),(2,5,2),(2,6,1);

insert into evidencija_naracki_izraboteni_delovi (id_evidencija,id_del,br_na_zavrseni_delovi)
values (1,1,50),(1,2,50),(2,3,50),(2,4,50);

insert into nalozi_kreira_naracka (id_naracka,id_nalog)
values(1,3),(2,1),(3,2);
insert into evidencija_se_odnesuva_na_mebel (id_evidencija,id_mebel)
values
(1,2),(2,2),(3,2),(4,4),(5,4),(6,4),(7,4);

insert into delovi_izraboteni_od_materijal (id_del,id_materijal)
values
(3,2),(1,1),(2,3);
insert into delovi_izraboteni_od_mashina (id_del,id_mashina)
values(1,2),(1,1),(2,1),(2,2),(3,1),(4,1),(5,1),(6,1);

insert into mashina_pripaga_oddelenie (id_mashina ,id_oddelenie )
values(1,1),(2,1),(3,1),(4,1),(5,1),(6,1);

insert into vraboteni_se_korisnici (id_vraboten,id_korisnik)
values
(1,1),(2,2),(3,3),(6,4),(7,5);
insert into vraboteni_vo_proizvodstvo_raboti_vo_oddelenija (id_vraboten,id_oddelenie)
values(4,1),(5,1);

INSERT INTO vraboteni_vo_proizvodstvo_raboti_na_mashina (id_vraboten,id_mashina)
values(4,1),(5,2);