INSERT INTO unitate_medicala(id,nume,adresa)
VALUES
('1','SebiMed','Targu Neamt'),
('2','DragosMed','Cluj Napoca'),
('3','AndreiMed','Oradea'),
('4','FlaviuMed','Bucuresti'),
('5','LarisaMed','Iasi'),
('6','AnaMed','Brasov');

INSERT INTO program_unitate_medicala(id,ora_deschidere,ora_inchidere,zi_saptamana)
VALUES
('1','10:00:00','19:00:00','luni'),
('1','10:00:00','19:00:00','marti'),
('1','10:00:00','19:00:00','miercuri'),
('1','10:00:00','19:00:00','joi'),
('1','10:00:00','19:00:00','vineri'),
('1','10:30:00','17:00:00','sambata'),
('1','11:00:00','16:30:00','duminica'),

('2','09:30:00','18:30:00','luni'),
('2','09:30:00','18:30:00','marti'),
('2','09:30:00','18:30:00','miercuri'),
('2','09:30:00','18:30:00','joi'),
('2','09:30:00','18:30:00','vineri'),
('2','10:00:00','18:00:00','sambata'),
('2','12:00:00','17:00:00','duminica'),

('3','08:00:00','19:00:00','luni'),
('3','08:00:00','19:00:00','marti'),
('3','08:00:00','19:00:00','miercuri'),
('3','08:00:00','19:00:00','joi'),
('3','08:00:00','19:00:00','vineri'),
('3','10:00:00','14:00:00','sambata'),
('3','10:00:00','13:00:00','duminica'),

('4','10:00:00','19:00:00','luni'),
('4','10:00:00','19:00:00','marti'),
('4','10:00:00','19:00:00','miercuri'),
('4','10:00:00','19:00:00','joi'),
('4','10:00:00','19:00:00','vineri'),
('4','10:00:00','19:00:00','sambata'),
('4','10:00:00','19:00:00','duminica'),

('5','10:00:00','20:00:00','luni'),
('5','10:00:00','20:00:00','marti'),
('5','10:00:00','20:00:00','miercuri'),
('5','10:00:00','20:00:00','joi'),
('5','10:00:00','20:00:00','vineri'),
('5','08:00:00','13:30:00','sambata'),
('5','08:00:00','12:00:00','duminica'),

('6','08:45:00','21:00:00','luni'),
('6','08:45:00','21:00:00','marti'),
('6','08:45:00','21:00:00','miercuri'),
('6','08:45:00','21:00:00','joi'),
('6','08:45:00','21:00:00','vineri'),
('6','09:45:00','12:00:00','sambata'),
('6','09:45:00','12:00:00','duminica');


INSERT INTO utilizator(CNP,nume,prenume,adresa,nr_tel,email,IBAN,nr_contact,data_angajare,functie)
VALUES
('001','Arsine','Sebastian','Bucuresti','0745413934','arsine@eamil.com','1234','0745413934','2014-03-11','administrator'),
('002','Chis','Dragos','Cluj Napoca','0755833699','chis@email.com','3256','0755833699','2014-03-08','super administrator'),
('003','Comsa','Mihai','Alba','0725515900','comsa@email.com','4141','0725515900','2015-01-02','inspector hr'),
('004','Flaviu','Bura','Satu Mare','0741678233','bura@email.com','2567','0741678233','2014-08-14','medic'),
('005','Dascalu','Cosmin','Piatra Neamt','0733456763','dascalu@email.com','6675','0733456763','2016-06-22','asistent medical'),
('006','Mihali','Mihai','Zalau','0758831944','mihali@email.com','9876','0758831944','2017-04-29','contabil'),
('007','Cobzaru','Paul','Pitesti','0736182225','cobzaru@email.com','1934','0736182225','2015-10-11','receptioner');

INSERT INTO angajat(CNP,salariu,nr_ore)
VALUES
('003','4000','40'),
('004','8000','52'),
('005','5000','52'),
('006','3500','48'),
('007','3000','50');

INSERT INTO asistent(CNP,tip_asistent,grad_asistent)
VALUES
('005','generalist','principal');

INSERT INTO user(CNP,username,password)
VALUES
('001','Arsine','Arsine1'),
('002','Chis','Chis2'),
('003','Comsa','Comsa3'),
('004','Flaviu','Flaviu4'),
('005','Dascalu','Dascalu5'),
('006','Mihali','Mihali6'),
('007','Cobzaru','Combzaru7');

INSERT INTO medic(CNP,grad_medic,cod_parafa,titlu_stiintific,post_didactic,procent_servicii)
VALUES
('004','specialist','0340','doctorand','profesor','44');


INSERT INTO competenta(id,denumire_competenta)
VALUES
('1','ecografie'),
('2','endoscopie digestiva'),
('3','chirurgie spinala');

INSERT INTO competente_medic(CNP_medic,id_competenta)
VALUES
('004','1'),
('004','3');


INSERT INTO serviciu_medical(id,grad_medic,denumire,specialitate,pret,durata)
VALUES
(1,'specialist','consultatie','ortopedie',100,100);

INSERT INTO concediu(CNP,data_inceput,data_sfarsit)
VALUES
('003','2018-03-10','2018-03-27'),
('004','2018-07-10','2018-08-10'),
('005','2018-02-15','2018-02-28'),
('006','2018-04-22','2018-05-11'),
('007','2018-10-10','2018-11-11');

INSERT INTO pacient(id,nume,prenume)
VALUES
('1','Asaftei','Andrei'),
('2','Oancea','Raul'),
('3','Micle','Flavian');

INSERT INTO programare(id,id_pacient,data,ora,CNP_medic,durata)
VALUES
('1','1','2018-02-16','12:00:00','004','120'),
('2','2','2018-02-17','13:00:00','004','70'),
('3','3','2018-02-18','08:00:00','004','80');

INSERT INTO SM_programare(id_programare,id_SM)
VALUES
('1','1');


INSERT INTO raport(id,id_pacient,CNP_medic,id_programare,simptome,investigatii,diagnostic,recomandari,parafa)
VALUES
('1','1','004','1',' ',' ',' ',' ',' '),
('2','2','004','2',' ',' ',' ',' ',' '),
('3','3','004','3',' ',' ',' ',' ',' ');