RelationalDesign: polnenje.sql

insert into user_table (date_created_user, name_user, email_user, password_user, telephone_user) values
(now(), 'Ekaterina Sazdova', 'sazdovaekaterina@gmail.com', 'very_str0ng_p@ssword', null),
(now(), 'Filip Corbeski', 'corbeski.filip@gmail.com', '123466', '223 305'),
(now(), 'Mila Trajceva', 'mila.trajceva@gmail.com', 'passWord1', null),
(now(), 'Trajko Petrov', 'trajko_petrovski98@yahoo.com', 'earyeraer', '077-894-928'),
(now(), 'Maja Hristovska', 'hristovskam@gmail.com', '453v3v', '+38977123456'),
(now(), 'Renata Todorovska', 'renata.todorovska@students.finki.ukim.mk', 'fgh123', '070/819-193'),
(now(),'Mihaela Sterjoska', 'mihela.sterjoska@gmail.com', 'MihSter', '075365276'),
(now(),'Filip Stojchevski', 'filip.stojchevski@gmail.com', 'FilStoj', '075365009'),
(now(),'Sara Trajkovikj', 'sara.trajkovikj@gmail.com', 'SarTraj', '070388276'),
(now(),'Ivana Mishev', 'ivana.mishev@gmail.com', 'IvaMish', '076093657'),
(now(),'Aleksandar Marijanov', 'aleksandar.marijanov@gmail.com', 'AleMari', '076093657'),
(now(),'Damjana Kirevska', 'damjana.kirevska@gmail.com', 'DamKir', '076097657'),
(now(),'Mihail Stefanovski', 'mihail.stefanovski@gmail.com', 'MihStef', '075398676'),
(now(),'Kristina Ivanova', 'kristina.ivanova@gmail.com', 'KriIva', '076097655'),
(now(),'Marin Kamel', 'marin.kamel@gmail.com', 'MarKam', '076097655'),
(now(),'Nikola Petrovski', 'nikola.petrovski@gmail.com', 'NikPet', '076097655'),
(now(),'Markijan Malinov', 'markijan.malinkov@gmail.com', 'MarMal', '076767655'),
(now(),'Frosina Jorukoska', 'frosina.jorukoska@gmail.com', 'FroJor', '076086655'),
(now(),'Monika Stojmenska', 'monika.stojmenska@gmail.com', 'MonSto', '070695655'),
(now(),'Nenad Marichik', 'nenad.marichik@gmail.com', 'NenMar', '075097675'),
(now(),'Luka Serdar', 'luka.serdar@gmail.com', 'LukSer', '071764325');

insert into admin_table (id_user) values
(1),
(2),
(3);

insert into surendee (id_user) values
(4),
(5),
(6);

insert into donor (id_user, is_from_organisation, name_organisation_donor) values 
(7, false, null),
(8, true, 'Save The Birds Organisation'),
(9, false, null);

insert into organisation (name_organisation, email_organisation, billing_information) values 
('AnimalHelp', 'animalhelp@contact.org', '200001234567890'),
('National Shelters Macedonia', 'shelters@contact.org.mk', '300001234567890'),
('Dog Rescue', 'dog.rescue@contact.org', '400001234567890');

insert into shelter (address_shelter, telephone_shelter, id_organisation, name_shelter, email_shelter) values 
('st. Street n. 5, Skopje, Macedonia', '123-456-789', 2, 'Skopje City Shelter', 'skopje-shelters@contact.org.mk'),
('st. Street n. 4, Bitola, Macedonia', '223-456-789', 2, 'Bitola City Shelter', 'bitola-shelters@contact.org.mk'),
('st. Street n. 8, Ohrid, Macedonia', '323-456-789', 2, 'Ohrid City Shelter', 'ohrid-shelters@contact.org.mk'),
('st. SomeStreet n.9, Skopje, Macedonia', '072-072-072', null, 'Animal Rescue - Independent Shelter Skopje', 'animal-rescue-skopje@contact.org'); )

insert into employee (id_user, position_employee, id_shelter, is_verified, verified_by_admin) values 
(10, 'shelter staff', 1, true, 1),
(11, 'shelter staff', 1, true, 1),
(12, 'shelter staff', 2, true, 2),
(13, 'shelter staff', 2, true, 2),
(14, 'shelter staff', 3, true, 3),
(15, 'shelter staff', 4, true, 3);

insert into adopter (id_user, free_time, funds, has_other_pets, has_kids, housing, 
        physical_activity_adopters, will_foster, is_verified, verified_by_employee) values 
(16, null, null, null, null, null, null, null, true, 10),
(17, 2, 0, true, false, 1, 2, true, true, 14),
(18, 0, 2, false, false, 0, 1, false, true, 15),
(19, 1, 1, false, true, 1, 0, true, true, 12),
(20, null, null, null, null, null, null, null, false, null),
(21, 2, 2, true, true, 1, 2, true, true, 14);

insert into adoption (start_date, end_date_foster, approved, id_adopter) values 
(to_date('2022-12-23', 'YYYY-MM-DD'), null, true, 16),
(to_date('2022-12-11', 'YYYY-MM-DD'), to_date('2022-05-11', 'YYYY-MM-DD'), true, 17),
(to_date('2023-10-17', 'YYYY-MM-DD'), null, true, 18),
(to_date('2023-01-10', 'YYYY-MM-DD'), to_date('2022-04-10', 'YYYY-MM-DD'), true, 19),
(to_date('2022-10-23', 'YYYY-MM-DD'), null, true, 20),
(to_date('2022-12-11', 'YYYY-MM-DD'), null, true, 21),
(to_date('2021-8-17', 'YYYY-MM-DD'), null, true, 18),
(to_date('2023-6-10', 'YYYY-MM-DD'), null, true, 19),
(to_date('2022-9-23', 'YYYY-MM-DD'), null, true, 20),
(to_date('2022-1-14', 'YYYY-MM-DD'), null, true, 20),
(to_date('2022-9-9', 'YYYY-MM-DD'), null, true, 20),
(to_date('2022-2-14', 'YYYY-MM-DD'), null, true, 19),
(to_date('2021-4-17', 'YYYY-MM-DD'), null, true, 19),
(to_date('2023-8-20', 'YYYY-MM-DD'), null, true, 16);

insert into pet (url_pet_image, age_group, size_pet, breed, name_pet, 
        species, gender, can_be_fostered, id_adoption, id_shelter) values 
(null, 0, 1, null, 'Mittens', 0, 1, true, 1, 4),
(null, 2, 3, 'German Shepherd', 'Brownie', 1, 0, false, null, 1),
(null, 1, 2, 'Ragdoll', 'Whiskers', 0, 0, false, 3, null),
(null, 0, 3, null, null, 1, 1, true, 2, 2),
(null, 0, 3, null, null, 1, 1, true, 4, 2),
(null, 1, 0, 'African Gray Parrot', 'Biscuit', 2, 0, false, 1, 4),
(null, 2, 3, 'Golden Retriver', 'Bert', 1, 0, false, 5, 1),
(null, 1, 2, 'Persian', 'Fluff', 0, 0, false, 6, null),
(null, 0, 3, null, 'Roki', 2, 0, false, 7, null),
(null, 0, 1, null, 'Bella', 1, 1, false, 8, 3),
(null, 2, 0, 'Chihuahua', 'Majlo', 1, 0, false, 13, 1),
(null, 0, 1, null, 'Marin', 1, 1, false, 18, 3);

insert into post (date_post, url_thumbanail, id_pet, id_surendee, id_employee) values 
(to_date('2022-10-07', 'YYYY-MM-DD'), null, 1, null, 15),
(to_date('2020-05-04', 'YYYY-MM-DD'), null, 2, null, 10),
(to_date('2022-08-23', 'YYYY-MM-DD'), null, 3, 5, null),
(to_date('2022-07-23', 'YYYY-MM-DD'), null, 4, null, 12),
(to_date('2022-07-23', 'YYYY-MM-DD'), null, 5, null, 12),
(to_date('2021-12-29', 'YYYY-MM-DD'), null, 6, null, 15);
 
insert into category (name_category) values 
('gray'),
('brown'),
('black'),
('friendly'),
('good with kids'),
('needs extra care');

insert into food (manufacturer, name_food, type_food) values 
('Purrfect Bistro', 'Senior Cat Food', 1),
('Kibbles', 'Tasty Dog Food', 0),
('Cesar', 'High Quality', 0);

insert into therapy (health_problem, start_date, end_date) values 
('leg surgery', null, null),
('diabetes treatment', null, null),
('3 month therapy to treat parasite', to_date('2023-01-03', 'YYYY-MM-DD'), to_date('2021-04-03', 'YYYY-MM-DD'));

insert into vet_clinic (telephone_vet_clinic, address_vet_clinic, name_vet_clinic) values 
('1234-567-890', 'st.Street n.6', 'PetCare - Veterinary Clinic'),
('2345-567-890', 'st.Street n.9', 'Tail Wags'),
('3456-567-890', 'st.Street n.12', 'The Pet Doctors');

insert into personal_profile (id_pet, friendly_to_kids, friendly_to_pets, 
        attention, physical_activity, grooming_needed) values 
(1, 1, 0, 0, 0, 0),
(2, 2, 2, 2, 0, 1),
(3, 2, 1, 1, 1, 2),
(4, 1, 2, 2, 0, 1),
(5, 1, 2, 0, 2, 1),
(6, 0, 0, 2, 1, 0);

insert into donor_donates_to_organisation (id_user, id_organisation) values 
(7, 1),
(8, 1),
(8, 2),
(9, 3);

insert into pet_belongs_to_category (id_pet, id_category) values 
(2, 2),
(6, 2),
(2, 5),
(4, 6);

insert into pet_needs_therapy (id_pet, id_therapy) values 
(4, 3),
(5, 3),
(4, 1),
(2, 2);

insert into pet_preferably_eats_food (id_pet, id_food, quantity_a_day) values 
(2, 3, 500),
(1, 3, 200),
(2, 2, 150);

insert into pet_needs_intervention_in_vet_clinic (id_pet, 
        id_vet_clinic, date_of_interventing, description) values 
(4, 2, to_date('2023-02-12', 'YYYY-MM-DD'), 'spay'),
(5, 2, to_date('2023-02-12', 'YYYY-MM-DD'), 'spay'),
(4, 3, to_date('2023-01-22', 'YYYY-MM-DD'), 'leg surgery');