RelationalDesign: Dodavanje1.sql

set
search_path = project;


INSERT INTO project.cities
("name", adress, phonenumber)
VALUES('Skopje', 'Nikola Parapunov 27', '+389(0)23161019'),
('Ohrid', 'Bulevar Makedonski Prosvetiteli', '070575881'),
('Skopje', 'Blvd. Partizanski Odredi 62', '077 698 250');

INSERT INTO project.vet_centers
("name", description, adress, phonenumber, latitude, longitude, workinghours, citiesid)
VALUES( 'Vet Svet', 'Тhe best for your pets', 'Nikola Parapunov 27', '+389(0)23161019', 41.9966401, 21.41712, 'Monday-Friday 10-19, Saturday 10-15', 1),
( 'Veterinarian Ambulance - Dr.Tonit', 'Your pets are safe with us', 'Bulevar Makedonski Prosvetiteli', '070575881', 41.1196292, 20.7996689, 'Monday-Thursday 08-20, Friday-Saturday 08-07', 2),
( 'Vet In', 'We exist for you and your pets', 'Blvd. Partizanski Odredi 62', '077 698 250', 42.0030601, 21.395752, 'Monday-Friday 9-12, 14-19', 3);

INSERT INTO project.jobs
(description, predictedsalery, vetcentersid)
VALUES('doctor', '1500 EUR', 1),
('secretary', '800 EUR', 1),
('doctor', '1400 EUR', 3),
('developer', '1800 EUR', 2);

INSERT INTO project.roles
("type")
VALUES('admin'),
('standard'),
('manager'),
('employee');

INSERT INTO project.users
("name", lastname, email, password, "number", role_id, jobs_id)
VALUES('Ana', 'Kirova', 'ana.kirova99@gmail.com', 'Ana@123', '071220234', 2, 2),
('Riste', 'Rizov', 'riste.rizov01@hotmail.com', 'Riste$11', '075450290', 2, 3),
('Keti', 'Atanasova', 'keti.atanasovaaa@gmail.com', 'Keti12@', '078760330', 2, 1),
('Elena', 'Rizova', 'elena.rizova05@gmail.com', 'Rizova12!', '071762110', 3, null),
('Marina', 'Abrasheva', 'marina.abrashevaa@hotmail.com', 'Marina!1', '072324112', 4, null),
('Angela', 'Pavlova', 'angela.pavlova07@hotmail.com', 'Angela@12', '078765240', 1, null),
('Marija', 'Kortova', 'marija.kortova199@gmail.com', 'Marija123&', '072231129', 2, 4);
        

INSERT INTO project.blog_post_for_consultations
(date_askes, title, description, users_id)
VALUES('2023-12-11', 'Urinary food', 'Can you recommend a urinary food because my kitten has urinary problems.', 1),
('2023-06-12', 'Frequent vomiting', 'Мy dog is vomiting a lot, despite the therapy from the vet, please advise.', 2),
('2023-04-10', 'Sterilization', 'When is the best time to sterilize a dog, before or after a period.', 3),
('2023-05-09', 'Panleukopenia', 'Мy kitten got sick, he does not want to eat or drink water. The vet suspects panleukopenia despite the negative test. I am asking for your experience.', 7);

INSERT INTO project.blog_post_answers
(parent_id, reply, blogpostconsid, usersid)
VALUES(1, 'Royal Canin', 1, 2),
(2, 'Did you change his food?', 2, 1),
(3, 'before a period', 3, 7),
(4, 'seek advice from another vet!', 4, 2);

INSERT INTO project.pet_cares
(title, description, dateending, usersid, vetcentersid)
VALUES('Аccommodation for a pet', 'I am looking for accommodation for my pet during the summer holidays. From July 12 to July 19', '2023-07-19', 1, 1),
('Аccommodation for a pet', 'I will be moving to another apartment so I am looking for 2 weeks accommodation for my kitten', '2023-08-10', 2, 2),
('Veterinary care', 'Мy dog is sick so he needs constant care. I need accommodation for him from 5 days', '2023-06-18', 3, 3);

INSERT INTO project.type_of_pets
(description, "name")
VALUES('cat', 'Lana'),
('dog', 'Roki'),
('dog', 'Fifi'),
('cat', 'Mimi'),
('dog', 'Dzina');

INSERT INTO project.pets
(color, description, dateofbirthday, usersid, typeofpetsid)
VALUES('white', 'Scottish Fold silver chincilla', '2022-05-20', 1, 1),
('grey', 'Persian long hair', '2021-06-16', 2, 4),
('brown', 'Large brown eyes, hanging ears,', '2020-12-30', 3, 2),
('black', 'Toy poodle', '2018-04-24', 7, 3),
('white', 'Toy poodle', '2019-10-20', 1, 5);

INSERT INTO project.pet_galery
(picture, petsid)
VALUES('https://thumbs.dreamstime.com/z/scottish-fold-cat-special-friendly-cat-breed-famous-their-folded-little-ears-their-extremely-affectionate-139562562.jpg', 1),
('https://cyprusanimals.files.wordpress.com/2011/08/persian.jpg',2),
('https://encrypted-tbn2.gstatic.com/images?q=tbn:ANd9GcTHiFuem-8UxpTNsp3uo1tFYNScsL7CBOPO6hIn5-2XIwzVVI7N',3),
('https://www.pupvine.com/wp-content/uploads/2021/12/Black-Toy-Poodle-An-Honest-Guide-To-The-Tiny-Teddy-Bear-Dog.jpg',4),
('https://media.istockphoto.com/id/176894002/photo/close-up-of-white-toy-poodle-sitting.jpg?s=612x612&w=0&k=20&c=o12N6niEkm0AVip1KAk8_b66SFy92nwjhnq0hcg0CDM=',5);

INSERT INTO project.reports
(description, usersid, petsid)
VALUES('Аfter receiving therapy for vomiting and diarrhea, the kitten is better, we will monitor his condition', 1, 1),
('Тhe dog passed the castration well', 3, 3),
('the kitten had urinary problems, next month he should eat only urine food', 2, 2);

INSERT INTO project."diagnostics"
(description, usersid)
VALUES('Diarrhea and vomiting', 1),
('Castration', 3),
('Urinary problems', 2),
('Urinary problems', 7);

INSERT INTO project.manufacturers
(name,description, city, state)
VALUES('Sunvet PharmaPrivate','We are themanufacturer of Pharmaceutical Injection', 'Belgrade', 'Serbian'),  
('Macwell Pharmaceuticals Pvt. Ltd','we believe to work according to international quality standards and process reliable','Frankfurt', 'Germany'), --FORTAN,
('SAM S FIELD','Top quality', 'Nuremberg', 'Germany'),
('MMG Healthcare','We are offering Veterinary Injections in both wet and dry formulations. ', 'Nuremberg', 'Germany');



INSERT INTO project.medecines
(name,description, diagnosticsid, manufacturersid)
VALUES('Biomix','Vitamin concentrate for cats with a high content of essential amino acids, vitamins, minerals, trace elements, as ideal as a supplement when feeding cats with raw food.', 1, 1),
('Fortan','For quality, shiny and beautiful fur',3,2),
('Sam ''s field','Functional semi-moist soft snacks for dogs with a reduced percentage of fat, to stimulate the digestive system and to improve skin and fur',1,3);

INSERT INTO project.pet_status
("type", node)
VALUES('received', 'admitted for examination'),
('weiting','waiting for his turn'),
('weiting','waiting for surgery'),
('received','admitted to surgery'),
('recovers','');

INSERT INTO project.therapy
(description, appoitmentdate, diagnosticsid, pet_statusid)
VALUES('antibiotic', '2023-12-12', 3, 1),
('anesthesiac', '2022-10-09', 2, 3),
('vitamins', '2023-07-06', 1, 5),
('antibiotic', '2023-10-12', 3, 1);


INSERT INTO project.breeds
("name")
VALUES('scottishfold'),
('beagle'),
('poodle'),
('persian'),
('poodle');

INSERT INTO project.products
("name", description, price, isactive, dateadded, category)
VALUES('CAT ROYALE','High quality premium clamping cat litter ', '7 euro', true, '2022-10-09', 'Hygiene and cosmetics'),
('Superior Care','Intended for white breed dogs to support full vision function', '3.50 euro', true, '2022-10-08', 'Dietary supplements'),
('Lifestyle','Intended for adult cats over 1 year of age with a sensitive digestive system', '4.40 euro', true, '2022-10-09', 'Dietary supplements'),
('Veterinary necklacke', 'for protection', '2 euro', 'false', '2022-10-09', 'Hygiene and cosmetics');

INSERT INTO project.orders
(quantity)
VALUES(3),
(10),
(5);

INSERT INTO project.pets_visit_vet_centers
(id_pets, id_vet_centers)
VALUES(1, 1),
(2,2),
(3,3),
(4,1);


INSERT INTO project.product_are_made_orders
(id_products, id_orders)
VALUES(1, 1),
(2,2),
(3,3);
INSERT INTO project.products_available_type_of_pets
(id_products, id_type_of_pets)
VALUES(1, 1),
(2,5),
(3,1);

INSERT INTO project.products_there_are_for_pets
(id_products, id_pets)
VALUES(1, 1),
(2, 5),
(3, 1);


INSERT INTO project.therapy_takes_pets
(id_therapy, id_pets)
VALUES(1, 3),
(2, 2),
(1, 1),
(3, 2);