Index: sql/dml.sql =================================================================== --- sql/dml.sql (revision c613cbf6f9fd9bd8bfca2ae505ed47ced972227a) +++ sql/dml.sql (revision 48d2bedc68ea10341495edcd217325613e05065f) @@ -351,171 +351,345 @@ (126, 'WRIST_PAIN', 'Pain in wrist'); -INSERT INTO doctors (doctor_id, first_name, last_name, email_address, level_id, specialization_id, department_id) VALUES - (1, 'Ivan', 'Stojanov', 'ivan.stojanov@medora.com', 1, 1, 1), - (2, 'Elena', 'Kirova', 'elena.kirova@medora.com', 2, 1, 1), - (3, 'Nikola', 'Trajkov', 'nikola.trajkov@medora.com', 3, 1, 1), - (4, 'Sara', 'Dimova', 'sara.dimova@medora.com', 4, 1, 1), - (5, 'Marija', 'Bajramovska', 'marija.bajramovska@medora.com', 5, 1, 1), - (6, 'Ana', 'Petrova', 'ana.petrova@medora.com', 1, 2, 2), - (7, 'Petar', 'Iliev', 'petar.iliev@medora.com', 2, 2, 2), - (8, 'Mila', 'Stojanova', 'mila.stojanova@medora.com', 3, 2, 2), - (9, 'Dejan', 'Markovski', 'dejan.markovski@medora.com', 4, 2, 2), - (10, 'Kristina', 'Todorova', 'kristina.todorova@medora.com', 5, 2, 2), - (11, 'Goran', 'Spasov', 'goran.spasov@medora.com', 1, 3, 3), - (12, 'Ivana', 'Hristova', 'ivana.hristova@medora.com', 2, 3, 3), - (13, 'Bojan', 'Nikolovski', 'bojan.nikolovski@medora.com', 3, 3, 3), - (14, 'Tea', 'Angelova', 'tea.angelova@medora.com', 4, 3, 3), - (15, 'Filip', 'Jovanov', 'filip.jovanov@medora.com', 5, 3, 3), - (16, 'Natasha', 'Petkovska', 'natasha.petkovska@medora.com', 1, 4, 4), - (17, 'Viktor', 'Andreev', 'viktor.andreev@medora.com', 2, 4, 4), - (18, 'Sofija', 'Marinova', 'sofija.marinova@medora.com', 3, 4, 4), - (19, 'Luka', 'Nikolov', 'luka.nikolov@medora.com', 4, 4, 4), - (20, 'Marija', 'Damjanova', 'marija.damjanova@medora.com', 5, 4, 4), - (21, 'Katerina', 'Ilieva', 'katerina.ilieva@medora.com', 1, 5, 5), - (22, 'Dimitar', 'Petrov', 'dimitar.petrov@medora.com', 2, 5, 5), - (23, 'Jana', 'Kostova', 'jana.kostova@medora.com', 3, 5, 5), - (24, 'Stefan', 'Todorov', 'stefan.todorov@medora.com', 4, 5, 5), - (25, 'Elena', 'Markova', 'elena.markova@medora.com', 5, 5, 5), - (26, 'Aleksandar', 'Ristovski', 'aleksandar.ristovski@medora.com', 1, 6, 6), - (27, 'Ivana', 'Trajkovska', 'ivana.trajkovska@medora.com', 2, 6, 6), - (28, 'Goran', 'Nikolov', 'goran.nikolov@medora.com', 3, 6, 6), - (29, 'Mila', 'Stojkova', 'mila.stojkova@medora.com', 4, 6, 6), - (30, 'Bojan', 'Petrov', 'bojan.petrov@medora.com', 5, 6, 6), - (31, 'Petar', 'Angelov', 'petar.angelov@medora.com', 1, 7, 7), - (32, 'Ana', 'Dimovska', 'ana.dimovska@medora.com', 2, 7, 7), - (33, 'Nikola', 'Kostadinov', 'nikola.kostadinov@medora.com', 3, 7, 7), - (34, 'Sara', 'Petrova', 'sara.petrova@medora.com', 4, 7, 7), - (35, 'Marko', 'Stojanovski', 'marko.stojanovski@medora.com', 5, 7, 7), - (36, 'Elena', 'Markovic', 'elena.markovic@medora.com', 1, 8, 8), - (37, 'Ivan', 'Petrovic', 'ivan.petrovic@medora.com', 2, 8, 8), - (38, 'Dejan', 'Ilievski', 'dejan.ilievski@medora.com', 3, 8, 8), - (39, 'Kristina', 'Ristova', 'kristina.ristova@medora.com', 4, 8, 8), - (40, 'Filip', 'Sokolov', 'filip.sokolov@medora.com', 5, 8, 8), - (41, 'Goran', 'Spasovski', 'goran.spasovski@medora.com', 1, 9, 9), - (42, 'Ivana', 'Hristovska', 'ivana.hristovska@medora.com', 2, 9, 9), - (43, 'Bojan', 'Nikolovska', 'bojan.nikolovska@medora.com', 3, 9, 9), - (44, 'Tea', 'Angelkovska', 'tea.angelkovska@medora.com', 4, 9, 9), - (45, 'Luka', 'Petrovski', 'luka.petrovski@medora.com', 5, 9, 9), - (46, 'Marija', 'Ristova', 'marija.ristova@medora.com', 1, 10, 10), - (47, 'Viktor', 'Stojanovski', 'viktor.stojanovski@medora.com', 2, 10, 10), - (48, 'Sofija', 'Markovska', 'sofija.markovska@medora.com', 3, 10, 10), - (49, 'Dimitar', 'Ilievski', 'dimitar.ilievski@medora.com', 4, 10, 10), - (50, 'Jana', 'Petrovska', 'jana.petrovska2@medora.com', 5, 10, 10), - (51, 'Stefan', 'Nikolov', 'stefan.nikolov@medora.com', 1, 11, 11), - (52, 'Elena', 'Trajkovska', 'elena.trajkovska@medora.com', 2, 11, 11), - (53, 'Nikola', 'Angelov', 'nikola.angelov@medora.com', 3, 11, 11), - (54, 'Sara', 'Dimovska', 'sara.dimovska@medora.com', 4, 11, 11), - (55, 'Ivan', 'Kostov', 'ivan.kostov@medora.com', 5, 11, 11), - (56, 'Petar', 'Hristov', 'petar.hristov@medora.com', 1, 12, 12), - (57, 'Ana', 'Petrovska', 'ana.petrovska3@medora.com', 2, 12, 12), - (58, 'Dejan', 'Stojkov', 'dejan.stojkov@medora.com', 3, 12, 12), - (59, 'Kristina', 'Ristovska', 'kristina.ristovska@medora.com', 4, 12, 12), - (60, 'Goran', 'Nikolovski', 'goran.nikolovski@medora.com', 5, 12, 12), - (61, 'Ivana', 'Markov', 'ivana.markov@medora.com', 1, 13, 13), - (62, 'Bojan', 'Petrovski', 'bojan.petrovski1@medora.com', 2, 13, 13), - (63, 'Tea', 'Ilieva', 'tea.ilieva@medora.com', 3, 13, 13), - (64, 'Filip', 'Spasov', 'filip.spasov@medora.com', 4, 13, 13), - (65, 'Marija', 'Angelova', 'marija.angelova@medora.com', 5, 13, 13), - (66, 'Viktor', 'Kirov', 'viktor.kirov@medora.com', 1, 14, 14), - (67, 'Sofija', 'Petrovska', 'sofija.petrovska@medora.com', 2, 14, 14), - (68, 'Luka', 'Ristovski', 'luka.ristovski@medora.com', 3, 14, 14), - (69, 'Dimitar', 'Markov', 'dimitar.markov@medora.com', 4, 14, 14), - (70, 'Jana', 'Nikolova', 'jana.nikolova@medora.com', 5, 14, 14), - (71, 'Marko', 'Stojanov', 'marko.stojanov@medora.com', 1, 15, 15), - (72, 'Elena', 'Ilievska', 'elena.ilievska@medora.com', 2, 15, 15), - (73, 'Nikola', 'Petrov', 'nikola.petrov@medora.com', 3, 15, 15), - (74, 'Sara', 'Trajkovska', 'sara.trajkovska@medora.com', 4, 15, 15), - (75, 'Ivan', 'Dimov', 'ivan.dimov@medora.com', 5, 15, 15), - (76, 'Goran', 'Ristov', 'goran.ristov@medora.com', 1, 16, 16), - (77, 'Ivana', 'Kostadinova', 'ivana.kostadinova@medora.com', 2, 16, 16), - (78, 'Bojan', 'Petkov', 'bojan.petkov@medora.com', 3, 16, 16), - (79, 'Tea', 'Markovska', 'tea.markovska@medora.com', 4, 16, 16), - (80, 'Filip', 'Stojanov', 'filip.stojanov@medora.com', 5, 16, 16), - (81, 'Marija', 'Hristovska', 'marija.hristovska@medora.com', 1, 17, 17), - (82, 'Viktor', 'Iliev', 'viktor.iliev@medora.com', 2, 17, 17), - (83, 'Sofija', 'Petrovski', 'sofija.petrovski@medora.com', 3, 17, 17), - (84, 'Luka', 'Angelovska', 'luka.angelovska@medora.com', 4, 17, 17), - (85, 'Dimitar', 'Kirovski', 'dimitar.kirovski@medora.com', 5, 17, 17), - (86, 'Jana', 'Ristova', 'jana.ristova@medora.com', 1, 18, 18), - (87, 'Marko', 'Petrovic', 'marko.petrovic@medora.com', 2, 18, 18), - (88, 'Elena', 'Stojkovska', 'elena.stojkovska@medora.com', 3, 18, 18), - (89, 'Nikola', 'Trajkovic', 'nikola.trajkovic@medora.com', 4, 18, 18), - (90, 'Sara', 'Dimkovska', 'sara.dimkovska@medora.com', 5, 18, 18), - (91, 'Ivan', 'Spasov', 'ivan.spasov@medora.com', 1, 19, 19), - (92, 'Petar', 'Nikolov', 'petar.nikolov@medora.com', 2, 19, 19), - (93, 'Ana', 'Markovska', 'ana.markovska@medora.com', 3, 19, 19), - (94, 'Dejan', 'Iliev', 'dejan.iliev@medora.com', 4, 19, 19), - (95, 'Kristina', 'Petrova', 'kristina.petrova@medora.com', 5, 19, 19), - (96, 'Goran', 'Stojanovski', 'goran.stojanovski@medora.com', 1, 20, 20), - (97, 'Ivana', 'Hristova', 'ivana.hristova1@medora.com', 2, 20, 20), - (98, 'Bojan', 'Kostov', 'bojan.kostov@medora.com', 3, 20, 20), - (99, 'Tea', 'Petrovska', 'tea.petrovska@medora.com', 4, 20, 20), - (100, 'Filip', 'Ristovski', 'filip.ristovski@medora.com', 5, 20, 20), - (101, 'Marija', 'Angelovska', 'marija.angelovska@medora.com', 1, 21, 21), - (102, 'Viktor', 'Markovski', 'viktor.markovski@medora.com', 2, 21, 21), - (103, 'Sofija', 'Petrova', 'sofija.petrova@medora.com', 3, 21, 21), - (104, 'Luka', 'Ilievski', 'luka.ilievski@medora.com', 4, 21, 21), - (105, 'Dimitar', 'Stojanov', 'dimitar.stojanov@medora.com', 5, 21, 21), - (106, 'Jana', 'Kirovska', 'jana.kirovska@medora.com', 1, 22, 22), - (107, 'Marko', 'Petkov', 'marko.petkov@medora.com', 2, 22, 22), - (108, 'Elena', 'Ristova', 'elena.ristova@medora.com', 3, 22, 22), - (109, 'Nikola', 'Dimov', 'nikola.dimov@medora.com', 4, 22, 22), - (110, 'Sara', 'Nikolova', 'sara.nikolova@medora.com', 5, 22, 22), - (111, 'Ivan', 'Trajkov', 'ivan.trajkov@medora.com', 1, 23, 23), - (112, 'Petar', 'Stojkov', 'petar.stojkov@medora.com', 2, 23, 23), - (113, 'Ana', 'Petrovska', 'ana.petrovska1@medora.com', 3, 23, 23), - (114, 'Dejan', 'Markov', 'dejan.markov@medora.com', 4, 23, 23), - (115, 'Kristina', 'Ilieva', 'kristina.ilieva@medora.com', 5, 23, 23), - (116, 'Filip', 'Kostadinov', 'filip.kostadinov@medora.com', 1, 24, 24), - (117, 'Ivana', 'Spasova', 'ivana.spasova@medora.com', 2, 24, 24), - (118, 'Bojan', 'Petrovski', 'bojan.petrovski2@medora.com', 3, 24, 24), - (119, 'Teodora', 'Angelova', 'teodora.angelova@medora.com', 4, 24, 24), - (120, 'Mila', 'Lukanovska', 'mila.lukanovska@medora.com', 5, 24, 24); +INSERT INTO users (user_id, username, password, role, first_name, last_name, is_active) VALUES + (1, 'admin', '$2b$12$VPUSCKLqfMU1ojKg4TncaOmqRZ.vCaguidmfvdAN3QM.qNRkkm/Ka', 'ADMIN', 'System', 'Administrator', true), + (2, '1402994123456', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Maja', 'Veljanova', true), + (3, '2106991123457', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Kristijan', 'Bojkov', true), + (4, '0311000123458', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Tamara', 'Gorgieva', true), + (5, '1009988123459', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Aleks', 'Nikolovski', true), + (6, '2512997123460', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Sara', 'Milevska', true), + (7, '1804993123461', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Stefan', 'Arsovski', true), + (8, '0907999123462', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Elena', 'Petreska', true), + (9, '3001990123463', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Viktor', 'Stankov', true), + (10, '1205995123464', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Ivana', 'Dimitrova', true), + (11, '2208987123465', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Marko', 'Lazarevski', true), + (12, '1703001123466', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Jana', 'Trajkovska', true), + (13, '0510992123467', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Petar', 'Kostov', true), + (14, '2806996123468', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Ana', 'Ristova', true), + (15, '1102989123469', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Nikola', 'Sokolov', true), + (16, '1909022123470', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Mila', 'Petrova', true), + (17, '1111994123471', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Dejan', 'Ilievski', true), + (18, '1401988123472', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Kristina', 'Markovska', true), + (19, '0707986123473', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Goran', 'Petrov', true), + (20, '0212000123474', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Sofija', 'Nikolova', true), + (21, '0303991123475', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Dimitar', 'Angelov', true), + (22, '0808997123476', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Teodora', 'Hristova', true), + (23, '1505993123477', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Filip', 'Stojanov', true), + (24, '1010999123478', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Marija', 'Kirovska', true), + (25, '1212988123479', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Ivan', 'Bojkov', true), + (26, '0404001123480', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Lina', 'Petrovska', true), + (27, '2002992123481', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Bojan', 'Spasov', true), + (28, '0909995123482', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Ana', 'Dimovska', true), + (29, '1606987123483', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Vladimir', 'Ristovski', true), + (30, '0101033123484', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Katerina', 'Todorova', true), + (31, '2311990123485', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Martin', 'Iliev', true), + (32, '1303996123486', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Elena', 'Trajkov', true), + (33, '2707994123487', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Aleksandar', 'Petrovski', true), + (34, '1809998123488', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Maja', 'Stojanovska', true), + (35, '0505989123489', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Nikola', 'Gligorov', true), + (36, '1212022123490', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Sara', 'Ilieva', true), + (37, '0303993123491', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Petar', 'Markovski', true), + (38, '0707997123492', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Ivana', 'Petrovska', true), + (39, '1010986123493', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Goran', 'Nikolovski', true), + (40, '2001000123494', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Jana', 'Ristova', true), + (41, 'ivan.stojanov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivan', 'Stojanov', true), + (42, 'elena.kirova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Elena', 'Kirova', true), + (43, 'nikola.trajkov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Nikola', 'Trajkov', true), + (44, 'sara.dimova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sara', 'Dimova', true), + (45, 'marija.bajramovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Marija', 'Bajramovska', true), + (46, 'ana.petrova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ana', 'Petrova', true), + (47, 'petar.iliev@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Petar', 'Iliev', true), + (48, 'mila.stojanova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Mila', 'Stojanova', true), + (49, 'dejan.markovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Dejan', 'Markovski', true), + (50, 'kristina.todorova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Kristina', 'Todorova', true), + (51, 'goran.spasov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Goran', 'Spasov', true), + (52, 'ivana.hristova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivana', 'Hristova', true), + (53, 'bojan.nikolovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Bojan', 'Nikolovski', true), + (54, 'tea.angelova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Tea', 'Angelova', true), + (55, 'filip.jovanov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Filip', 'Jovanov', true), + (56, 'natasha.petkovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Natasha', 'Petkovska', true), + (57, 'viktor.andreev@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Viktor', 'Andreev', true), + (58, 'sofija.marinova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sofija', 'Marinova', true), + (59, 'luka.nikolov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Luka', 'Nikolov', true), + (60, 'marija.damjanova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Marija', 'Damjanova', true), + (61, 'katerina.ilieva@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Katerina', 'Ilieva', true), + (62, 'dimitar.petrov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Dimitar', 'Petrov', true), + (63, 'jana.kostova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Jana', 'Kostova', true), + (64, 'stefan.todorov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Stefan', 'Todorov', true), + (65, 'elena.markova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Elena', 'Markova', true), + (66, 'aleksandar.ristovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Aleksandar', 'Ristovski', true), + (67, 'ivana.trajkovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivana', 'Trajkovska', true), + (68, 'goran.nikolov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Goran', 'Nikolov', true), + (69, 'mila.stojkova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Mila', 'Stojkova', true), + (70, 'bojan.petrov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Bojan', 'Petrov', true), + (71, 'petar.angelov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Petar', 'Angelov', true), + (72, 'ana.dimovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ana', 'Dimovska', true), + (73, 'nikola.kostadinov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Nikola', 'Kostadinov', true), + (74, 'sara.petrova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sara', 'Petrova', true), + (75, 'marko.stojanovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Marko', 'Stojanovski', true), + (76, 'elena.markovic@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Elena', 'Markovic', true), + (77, 'ivan.petrovic@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivan', 'Petrovic', true), + (78, 'dejan.ilievski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Dejan', 'Ilievski', true), + (79, 'kristina.ristova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Kristina', 'Ristova', true), + (80, 'filip.sokolov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Filip', 'Sokolov', true), + (81, 'goran.spasovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Goran', 'Spasovski', true), + (82, 'ivana.hristovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivana', 'Hristovska', true), + (83, 'bojan.nikolovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Bojan', 'Nikolovska', true), + (84, 'tea.angelkovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Tea', 'Angelkovska', true), + (85, 'luka.petrovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Luka', 'Petrovski', true), + (86, 'marija.ristova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Marija', 'Ristova', true), + (87, 'viktor.stojanovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Viktor', 'Stojanovski', true), + (88, 'sofija.markovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sofija', 'Markovska', true), + (89, 'dimitar.ilievski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Dimitar', 'Ilievski', true), + (90, 'jana.petrovska2@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Jana', 'Petrovska', true), + (91, 'stefan.nikolov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Stefan', 'Nikolov', true), + (92, 'elena.trajkovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Elena', 'Trajkovska', true), + (93, 'nikola.angelov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Nikola', 'Angelov', true), + (94, 'sara.dimovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sara', 'Dimovska', true), + (95, 'ivan.kostov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivan', 'Kostov', true), + (96, 'petar.hristov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Petar', 'Hristov', true), + (97, 'ana.petrovska3@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ana', 'Petrovska', true), + (98, 'dejan.stojkov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Dejan', 'Stojkov', true), + (99, 'kristina.ristovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Kristina', 'Ristovska', true), + (100, 'goran.nikolovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Goran', 'Nikolovski', true), + (101, 'ivana.markov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivana', 'Markov', true), + (102, 'bojan.petrovski1@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Bojan', 'Petrovski', true), + (103, 'tea.ilieva@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Tea', 'Ilieva', true), + (104, 'filip.spasov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Filip', 'Spasov', true), + (105, 'marija.angelova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Marija', 'Angelova', true), + (106, 'viktor.kirov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Viktor', 'Kirov', true), + (107, 'sofija.petrovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sofija', 'Petrovska', true), + (108, 'luka.ristovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Luka', 'Ristovski', true), + (109, 'dimitar.markov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Dimitar', 'Markov', true), + (110, 'jana.nikolova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Jana', 'Nikolova', true), + (111, 'marko.stojanov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Marko', 'Stojanov', true), + (112, 'elena.ilievska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Elena', 'Ilievska', true), + (113, 'nikola.petrov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Nikola', 'Petrov', true), + (114, 'sara.trajkovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sara', 'Trajkovska', true), + (115, 'ivan.dimov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivan', 'Dimov', true), + (116, 'goran.ristov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Goran', 'Ristov', true), + (117, 'ivana.kostadinova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivana', 'Kostadinova', true), + (118, 'bojan.petkov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Bojan', 'Petkov', true), + (119, 'tea.markovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Tea', 'Markovska', true), + (120, 'filip.stojanov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Filip', 'Stojanov', true), + (121, 'marija.hristovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Marija', 'Hristovska', true), + (122, 'viktor.iliev@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Viktor', 'Iliev', true), + (123, 'sofija.petrovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sofija', 'Petrovski', true), + (124, 'luka.angelovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Luka', 'Angelovska', true), + (125, 'dimitar.kirovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Dimitar', 'Kirovski', true), + (126, 'jana.ristova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Jana', 'Ristova', true), + (127, 'marko.petrovic@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Marko', 'Petrovic', true), + (128, 'elena.stojkovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Elena', 'Stojkovska', true), + (129, 'nikola.trajkovic@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Nikola', 'Trajkovic', true), + (130, 'sara.dimkovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sara', 'Dimkovska', true), + (131, 'ivan.spasov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivan', 'Spasov', true), + (132, 'petar.nikolov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Petar', 'Nikolov', true), + (133, 'ana.markovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ana', 'Markovska', true), + (134, 'dejan.iliev@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Dejan', 'Iliev', true), + (135, 'kristina.petrova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Kristina', 'Petrova', true), + (136, 'goran.stojanovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Goran', 'Stojanovski', true), + (137, 'ivana.hristova1@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivana', 'Hristova', true), + (138, 'bojan.kostov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Bojan', 'Kostov', true), + (139, 'tea.petrovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Tea', 'Petrovska', true), + (140, 'filip.ristovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Filip', 'Ristovski', true), + (141, 'marija.angelovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Marija', 'Angelovska', true), + (142, 'viktor.markovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Viktor', 'Markovski', true), + (143, 'sofija.petrova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sofija', 'Petrova', true), + (144, 'luka.ilievski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Luka', 'Ilievski', true), + (145, 'dimitar.stojanov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Dimitar', 'Stojanov', true), + (146, 'jana.kirovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Jana', 'Kirovska', true), + (147, 'marko.petkov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Marko', 'Petkov', true), + (148, 'elena.ristova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Elena', 'Ristova', true), + (149, 'nikola.dimov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Nikola', 'Dimov', true), + (150, 'sara.nikolova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sara', 'Nikolova', true), + (151, 'ivan.trajkov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivan', 'Trajkov', true), + (152, 'petar.stojkov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Petar', 'Stojkov', true), + (153, 'ana.petrovska1@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ana', 'Petrovska', true), + (154, 'dejan.markov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Dejan', 'Markov', true), + (155, 'kristina.ilieva@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Kristina', 'Ilieva', true), + (156, 'filip.kostadinov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Filip', 'Kostadinov', true), + (157, 'ivana.spasova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivana', 'Spasova', true), + (158, 'bojan.petrovski2@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Bojan', 'Petrovski', true), + (159, 'teodora.angelova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Teodora', 'Angelova', true), + (160, 'mila.lukanovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Mila', 'Lukanovska', true), + (161, 'lab_darko', '$2b$12$kEFZrjIohMSoqaQgr6a5Pep80r9Lf7C8ju4vVP1zNFlBDedhp.xHm', 'LAB_TECHNICIAN', 'Darko', 'Milosev', true), + (162, 'lab_biljana', '$2b$12$kEFZrjIohMSoqaQgr6a5Pep80r9Lf7C8ju4vVP1zNFlBDedhp.xHm', 'LAB_TECHNICIAN', 'Biljana', 'Trajkovska', true), + (163, 'lab_stefan', '$2b$12$kEFZrjIohMSoqaQgr6a5Pep80r9Lf7C8ju4vVP1zNFlBDedhp.xHm', 'LAB_TECHNICIAN', 'Stefan', 'Nikolovski', true), + (164, 'lab_marina', '$2b$12$kEFZrjIohMSoqaQgr6a5Pep80r9Lf7C8ju4vVP1zNFlBDedhp.xHm', 'LAB_TECHNICIAN', 'Marina', 'Petreska', true), + (165, 'lab_aleksandar', '$2b$12$kEFZrjIohMSoqaQgr6a5Pep80r9Lf7C8ju4vVP1zNFlBDedhp.xHm', 'LAB_TECHNICIAN', 'Aleksandar', 'Ristovski', true), + (166, 'admin_ilija', '$2b$12$ldKfa9rVgeYlftGINw5IWu3/JtyiJRJ6Is1SclgQ0PimuOfsS1m.u', 'BILLING_ADMIN', 'Ilija', 'Stojanov', true), + (167, 'admin_elena', '$2b$12$ldKfa9rVgeYlftGINw5IWu3/JtyiJRJ6Is1SclgQ0PimuOfsS1m.u', 'BILLING_ADMIN', 'Elena', 'Kirova', true), + (168, 'admin_marjan', '$2b$12$ldKfa9rVgeYlftGINw5IWu3/JtyiJRJ6Is1SclgQ0PimuOfsS1m.u', 'BILLING_ADMIN', 'Marjan', 'Petrov', true), + (169, 'admin_vesna', '$2b$12$ldKfa9rVgeYlftGINw5IWu3/JtyiJRJ6Is1SclgQ0PimuOfsS1m.u', 'BILLING_ADMIN', 'Vesna', 'Dimova', true), + (170, 'admin_dushanka', '$2b$12$ldKfa9rVgeYlftGINw5IWu3/JtyiJRJ6Is1SclgQ0PimuOfsS1m.u', 'BILLING_ADMIN', 'Dushanka', 'Trajkovska', true); + +-- Advance the serial sequence so future INSERTs (without explicit user_id) don't collide +SELECT setval('users_user_id_seq', (SELECT MAX(user_id) FROM users)); + +INSERT INTO doctors (doctor_id, first_name, last_name, email_address, level_id, specialization_id, department_id, user_id) VALUES + (1, 'Ivan', 'Stojanov', 'ivan.stojanov@medora.com', 1, 1, 1, 41), + (2, 'Elena', 'Kirova', 'elena.kirova@medora.com', 2, 1, 1, 42), + (3, 'Nikola', 'Trajkov', 'nikola.trajkov@medora.com', 3, 1, 1, 43), + (4, 'Sara', 'Dimova', 'sara.dimova@medora.com', 4, 1, 1, 44), + (5, 'Marija', 'Bajramovska', 'marija.bajramovska@medora.com', 5, 1, 1, 45), + (6, 'Ana', 'Petrova', 'ana.petrova@medora.com', 1, 2, 2, 46), + (7, 'Petar', 'Iliev', 'petar.iliev@medora.com', 2, 2, 2, 47), + (8, 'Mila', 'Stojanova', 'mila.stojanova@medora.com', 3, 2, 2, 48), + (9, 'Dejan', 'Markovski', 'dejan.markovski@medora.com', 4, 2, 2, 49), + (10, 'Kristina', 'Todorova', 'kristina.todorova@medora.com', 5, 2, 2, 50), + (11, 'Goran', 'Spasov', 'goran.spasov@medora.com', 1, 3, 3, 51), + (12, 'Ivana', 'Hristova', 'ivana.hristova@medora.com', 2, 3, 3, 52), + (13, 'Bojan', 'Nikolovski', 'bojan.nikolovski@medora.com', 3, 3, 3, 53), + (14, 'Tea', 'Angelova', 'tea.angelova@medora.com', 4, 3, 3, 54), + (15, 'Filip', 'Jovanov', 'filip.jovanov@medora.com', 5, 3, 3, 55), + (16, 'Natasha', 'Petkovska', 'natasha.petkovska@medora.com', 1, 4, 4, 56), + (17, 'Viktor', 'Andreev', 'viktor.andreev@medora.com', 2, 4, 4, 57), + (18, 'Sofija', 'Marinova', 'sofija.marinova@medora.com', 3, 4, 4, 58), + (19, 'Luka', 'Nikolov', 'luka.nikolov@medora.com', 4, 4, 4, 59), + (20, 'Marija', 'Damjanova', 'marija.damjanova@medora.com', 5, 4, 4, 60), + (21, 'Katerina', 'Ilieva', 'katerina.ilieva@medora.com', 1, 5, 5, 61), + (22, 'Dimitar', 'Petrov', 'dimitar.petrov@medora.com', 2, 5, 5, 62), + (23, 'Jana', 'Kostova', 'jana.kostova@medora.com', 3, 5, 5, 63), + (24, 'Stefan', 'Todorov', 'stefan.todorov@medora.com', 4, 5, 5, 64), + (25, 'Elena', 'Markova', 'elena.markova@medora.com', 5, 5, 5, 65), + (26, 'Aleksandar', 'Ristovski', 'aleksandar.ristovski@medora.com', 1, 6, 6, 66), + (27, 'Ivana', 'Trajkovska', 'ivana.trajkovska@medora.com', 2, 6, 6, 67), + (28, 'Goran', 'Nikolov', 'goran.nikolov@medora.com', 3, 6, 6, 68), + (29, 'Mila', 'Stojkova', 'mila.stojkova@medora.com', 4, 6, 6, 69), + (30, 'Bojan', 'Petrov', 'bojan.petrov@medora.com', 5, 6, 6, 70), + (31, 'Petar', 'Angelov', 'petar.angelov@medora.com', 1, 7, 7, 71), + (32, 'Ana', 'Dimovska', 'ana.dimovska@medora.com', 2, 7, 7, 72), + (33, 'Nikola', 'Kostadinov', 'nikola.kostadinov@medora.com', 3, 7, 7, 73), + (34, 'Sara', 'Petrova', 'sara.petrova@medora.com', 4, 7, 7, 74), + (35, 'Marko', 'Stojanovski', 'marko.stojanovski@medora.com', 5, 7, 7, 75), + (36, 'Elena', 'Markovic', 'elena.markovic@medora.com', 1, 8, 8, 76), + (37, 'Ivan', 'Petrovic', 'ivan.petrovic@medora.com', 2, 8, 8, 77), + (38, 'Dejan', 'Ilievski', 'dejan.ilievski@medora.com', 3, 8, 8, 78), + (39, 'Kristina', 'Ristova', 'kristina.ristova@medora.com', 4, 8, 8, 79), + (40, 'Filip', 'Sokolov', 'filip.sokolov@medora.com', 5, 8, 8, 80), + (41, 'Goran', 'Spasovski', 'goran.spasovski@medora.com', 1, 9, 9, 81), + (42, 'Ivana', 'Hristovska', 'ivana.hristovska@medora.com', 2, 9, 9, 82), + (43, 'Bojan', 'Nikolovska', 'bojan.nikolovska@medora.com', 3, 9, 9, 83), + (44, 'Tea', 'Angelkovska', 'tea.angelkovska@medora.com', 4, 9, 9, 84), + (45, 'Luka', 'Petrovski', 'luka.petrovski@medora.com', 5, 9, 9, 85), + (46, 'Marija', 'Ristova', 'marija.ristova@medora.com', 1, 10, 10, 86), + (47, 'Viktor', 'Stojanovski', 'viktor.stojanovski@medora.com', 2, 10, 10, 87), + (48, 'Sofija', 'Markovska', 'sofija.markovska@medora.com', 3, 10, 10, 88), + (49, 'Dimitar', 'Ilievski', 'dimitar.ilievski@medora.com', 4, 10, 10, 89), + (50, 'Jana', 'Petrovska', 'jana.petrovska2@medora.com', 5, 10, 10, 90), + (51, 'Stefan', 'Nikolov', 'stefan.nikolov@medora.com', 1, 11, 11, 91), + (52, 'Elena', 'Trajkovska', 'elena.trajkovska@medora.com', 2, 11, 11, 92), + (53, 'Nikola', 'Angelov', 'nikola.angelov@medora.com', 3, 11, 11, 93), + (54, 'Sara', 'Dimovska', 'sara.dimovska@medora.com', 4, 11, 11, 94), + (55, 'Ivan', 'Kostov', 'ivan.kostov@medora.com', 5, 11, 11, 95), + (56, 'Petar', 'Hristov', 'petar.hristov@medora.com', 1, 12, 12, 96), + (57, 'Ana', 'Petrovska', 'ana.petrovska3@medora.com', 2, 12, 12, 97), + (58, 'Dejan', 'Stojkov', 'dejan.stojkov@medora.com', 3, 12, 12, 98), + (59, 'Kristina', 'Ristovska', 'kristina.ristovska@medora.com', 4, 12, 12, 99), + (60, 'Goran', 'Nikolovski', 'goran.nikolovski@medora.com', 5, 12, 12, 100), + (61, 'Ivana', 'Markov', 'ivana.markov@medora.com', 1, 13, 13, 101), + (62, 'Bojan', 'Petrovski', 'bojan.petrovski1@medora.com', 2, 13, 13, 102), + (63, 'Tea', 'Ilieva', 'tea.ilieva@medora.com', 3, 13, 13, 103), + (64, 'Filip', 'Spasov', 'filip.spasov@medora.com', 4, 13, 13, 104), + (65, 'Marija', 'Angelova', 'marija.angelova@medora.com', 5, 13, 13, 105), + (66, 'Viktor', 'Kirov', 'viktor.kirov@medora.com', 1, 14, 14, 106), + (67, 'Sofija', 'Petrovska', 'sofija.petrovska@medora.com', 2, 14, 14, 107), + (68, 'Luka', 'Ristovski', 'luka.ristovski@medora.com', 3, 14, 14, 108), + (69, 'Dimitar', 'Markov', 'dimitar.markov@medora.com', 4, 14, 14, 109), + (70, 'Jana', 'Nikolova', 'jana.nikolova@medora.com', 5, 14, 14, 110), + (71, 'Marko', 'Stojanov', 'marko.stojanov@medora.com', 1, 15, 15, 111), + (72, 'Elena', 'Ilievska', 'elena.ilievska@medora.com', 2, 15, 15, 112), + (73, 'Nikola', 'Petrov', 'nikola.petrov@medora.com', 3, 15, 15, 113), + (74, 'Sara', 'Trajkovska', 'sara.trajkovska@medora.com', 4, 15, 15, 114), + (75, 'Ivan', 'Dimov', 'ivan.dimov@medora.com', 5, 15, 15, 115), + (76, 'Goran', 'Ristov', 'goran.ristov@medora.com', 1, 16, 16, 116), + (77, 'Ivana', 'Kostadinova', 'ivana.kostadinova@medora.com', 2, 16, 16, 117), + (78, 'Bojan', 'Petkov', 'bojan.petkov@medora.com', 3, 16, 16, 118), + (79, 'Tea', 'Markovska', 'tea.markovska@medora.com', 4, 16, 16, 119), + (80, 'Filip', 'Stojanov', 'filip.stojanov@medora.com', 5, 16, 16, 120), + (81, 'Marija', 'Hristovska', 'marija.hristovska@medora.com', 1, 17, 17, 121), + (82, 'Viktor', 'Iliev', 'viktor.iliev@medora.com', 2, 17, 17, 122), + (83, 'Sofija', 'Petrovski', 'sofija.petrovski@medora.com', 3, 17, 17, 123), + (84, 'Luka', 'Angelovska', 'luka.angelovska@medora.com', 4, 17, 17, 124), + (85, 'Dimitar', 'Kirovski', 'dimitar.kirovski@medora.com', 5, 17, 17, 125), + (86, 'Jana', 'Ristova', 'jana.ristova@medora.com', 1, 18, 18, 126), + (87, 'Marko', 'Petrovic', 'marko.petrovic@medora.com', 2, 18, 18, 127), + (88, 'Elena', 'Stojkovska', 'elena.stojkovska@medora.com', 3, 18, 18, 128), + (89, 'Nikola', 'Trajkovic', 'nikola.trajkovic@medora.com', 4, 18, 18, 129), + (90, 'Sara', 'Dimkovska', 'sara.dimkovska@medora.com', 5, 18, 18, 130), + (91, 'Ivan', 'Spasov', 'ivan.spasov@medora.com', 1, 19, 19, 131), + (92, 'Petar', 'Nikolov', 'petar.nikolov@medora.com', 2, 19, 19, 132), + (93, 'Ana', 'Markovska', 'ana.markovska@medora.com', 3, 19, 19, 133), + (94, 'Dejan', 'Iliev', 'dejan.iliev@medora.com', 4, 19, 19, 134), + (95, 'Kristina', 'Petrova', 'kristina.petrova@medora.com', 5, 19, 19, 135), + (96, 'Goran', 'Stojanovski', 'goran.stojanovski@medora.com', 1, 20, 20, 136), + (97, 'Ivana', 'Hristova', 'ivana.hristova1@medora.com', 2, 20, 20, 137), + (98, 'Bojan', 'Kostov', 'bojan.kostov@medora.com', 3, 20, 20, 138), + (99, 'Tea', 'Petrovska', 'tea.petrovska@medora.com', 4, 20, 20, 139), + (100, 'Filip', 'Ristovski', 'filip.ristovski@medora.com', 5, 20, 20, 140), + (101, 'Marija', 'Angelovska', 'marija.angelovska@medora.com', 1, 21, 21, 141), + (102, 'Viktor', 'Markovski', 'viktor.markovski@medora.com', 2, 21, 21, 142), + (103, 'Sofija', 'Petrova', 'sofija.petrova@medora.com', 3, 21, 21, 143), + (104, 'Luka', 'Ilievski', 'luka.ilievski@medora.com', 4, 21, 21, 144), + (105, 'Dimitar', 'Stojanov', 'dimitar.stojanov@medora.com', 5, 21, 21, 145), + (106, 'Jana', 'Kirovska', 'jana.kirovska@medora.com', 1, 22, 22, 146), + (107, 'Marko', 'Petkov', 'marko.petkov@medora.com', 2, 22, 22, 147), + (108, 'Elena', 'Ristova', 'elena.ristova@medora.com', 3, 22, 22, 148), + (109, 'Nikola', 'Dimov', 'nikola.dimov@medora.com', 4, 22, 22, 149), + (110, 'Sara', 'Nikolova', 'sara.nikolova@medora.com', 5, 22, 22, 150), + (111, 'Ivan', 'Trajkov', 'ivan.trajkov@medora.com', 1, 23, 23, 151), + (112, 'Petar', 'Stojkov', 'petar.stojkov@medora.com', 2, 23, 23, 152), + (113, 'Ana', 'Petrovska', 'ana.petrovska1@medora.com', 3, 23, 23, 153), + (114, 'Dejan', 'Markov', 'dejan.markov@medora.com', 4, 23, 23, 154), + (115, 'Kristina', 'Ilieva', 'kristina.ilieva@medora.com', 5, 23, 23, 155), + (116, 'Filip', 'Kostadinov', 'filip.kostadinov@medora.com', 1, 24, 24, 156), + (117, 'Ivana', 'Spasova', 'ivana.spasova@medora.com', 2, 24, 24, 157), + (118, 'Bojan', 'Petrovski', 'bojan.petrovski2@medora.com', 3, 24, 24, 158), + (119, 'Teodora', 'Angelova', 'teodora.angelova@medora.com', 4, 24, 24, 159), + (120, 'Mila', 'Lukanovska', 'mila.lukanovska@medora.com', 5, 24, 24, 160); INSERT INTO patients ( patient_id, first_name, last_name, email_address, date_of_birth, - blood_type, gender, phone_number, embg + blood_type, gender, phone_number, embg, user_id ) VALUES - (1, 'Maja', 'Veljanova', 'maja.veljanova@gmail.com', '1994-02-14', 'A+', 'FEMALE', '070111222', '1402994123456'), - (2, 'Kristijan', 'Bojkov', 'kristijan.bojkov@gmail.com', '1991-06-21', 'O-', 'MALE', '071222333', '2106991123457'), - (3, 'Tamara', 'Gorgieva', 'tamara.gorgieva@gmail.com', '2000-11-03', 'B+', 'FEMALE', '072333444', '0311000123458'), - (4, 'Aleks', 'Nikolovski', 'aleks.nikolovski@gmail.com', '1988-09-10', 'AB+', 'MALE', '073444555', '1009988123459'), - (5, 'Sara', 'Milevska', 'sara.milevska@gmail.com', '1997-12-25', 'A-', 'FEMALE', '074555666', '2512997123460'), - (6, 'Stefan', 'Arsovski', 'stefan.arsovski@gmail.com', '1993-04-18', 'O+', 'MALE', '075666777', '1804993123461'), - (7, 'Elena', 'Petreska', 'elena.petreska@gmail.com', '1999-07-09', 'B-', 'FEMALE', '076777888', '0907999123462'), - (8, 'Viktor', 'Stankov', 'viktor.stankov@gmail.com', '1990-01-30', 'A+', 'MALE', '077888999', '3001990123463'), - (9, 'Ivana', 'Dimitrova', 'ivana.dimitrova@gmail.com', '1995-05-12', 'O-', 'FEMALE', '078999111', '1205995123464'), - (10, 'Marko', 'Lazarevski', 'marko.lazarevski@gmail.com', '1987-08-22', 'AB-', 'MALE', '070123456', '2208987123465'), - (11, 'Jana', 'Trajkovska', 'jana.trajkovska@gmail.com', '2001-03-17', 'A+', 'FEMALE', '071234567', '1703001123466'), - (12, 'Petar', 'Kostov', 'petar.kostov@gmail.com', '1992-10-05', 'B+', 'MALE', '072345678', '0510992123467'), - (13, 'Ana', 'Ristova', 'ana.ristova@gmail.com', '1996-06-28', 'O+', 'FEMALE', '073456789', '2806996123468'), - (14, 'Nikola', 'Sokolov', 'nikola.sokolov@gmail.com', '1989-02-11', 'A-', 'MALE', '074567890', '1102989123469'), - (15, 'Mila', 'Petrova', 'mila.petrova@gmail.com', '2002-09-19', 'AB+', 'FEMALE', '075678901', '1909022123470'), - (16, 'Dejan', 'Ilievski', 'dejan.ilievski@gmail.com', '1994-11-11', 'O+', 'MALE', '076789012', '1111994123471'), - (17, 'Kristina', 'Markovska', 'kristina.markovska@gmail.com', '1998-01-14', 'B+', 'FEMALE', '077890123', '1401988123472'), - (18, 'Goran', 'Petrov', 'goran.petrov@gmail.com', '1986-07-07', 'A+', 'MALE', '078901234', '0707986123473'), - (19, 'Sofija', 'Nikolova', 'sofija.nikolova@gmail.com', '2000-12-02', 'O-', 'FEMALE', '070112233', '0212000123474'), - (20, 'Dimitar', 'Angelov', 'dimitar.angelov@gmail.com', '1991-03-03', 'B-', 'MALE', '071223344', '0303991123475'), - (21, 'Teodora', 'Hristova', 'teodora.hristova@gmail.com', '1997-08-08', 'A+', 'FEMALE', '072334455', '0808997123476'), - (22, 'Filip', 'Stojanov', 'filip.stojanov@gmail.com', '1993-05-15', 'AB+', 'MALE', '073445566', '1505993123477'), - (23, 'Marija', 'Kirovska', 'marija.kirovska@gmail.com', '1999-10-10', 'O+', 'FEMALE', '074556677', '1010999123478'), - (24, 'Ivan', 'Bojkov', 'ivan.bojkov@gmail.com', '1988-12-12', 'A-', 'MALE', '075667788', '1212988123479'), - (25, 'Lina', 'Petrovska', 'lina.petrovska@gmail.com', '2001-04-04', 'B+', 'FEMALE', '076778899', '0404001123480'), - (26, 'Bojan', 'Spasov', 'bojan.spasov@gmail.com', '1992-02-20', 'O+', 'MALE', '077889900', '2002992123481'), - (27, 'Ana', 'Dimovska', 'ana.dimovska@gmail.com', '1995-09-09', 'A+', 'FEMALE', '078990011', '0909995123482'), - (28, 'Vladimir', 'Ristovski', 'vladimir.ristovski@gmail.com', '1987-06-16', 'AB-', 'MALE', '070998877', '1606987123483'), - (29, 'Katerina', 'Todorova', 'katerina.todorova@gmail.com', '2003-01-01', 'O-', 'FEMALE', '071887766', '0101033123484'), - (30, 'Martin', 'Iliev', 'martin.iliev@gmail.com', '1990-11-23', 'B+', 'MALE', '072776655', '2311990123485'), - (31, 'Elena', 'Trajkov', 'elena.trajkov@gmail.com', '1996-03-13', 'A-', 'FEMALE', '073665544', '1303996123486'), - (32, 'Aleksandar', 'Petrovski', 'aleksandar.petrovski@gmail.com', '1994-07-27', 'O+', 'MALE', '074554433', '2707994123487'), - (33, 'Maja', 'Stojanovska', 'maja.stojanovska@gmail.com', '1998-09-18', 'B-', 'FEMALE', '075443322', '1809998123488'), - (34, 'Nikola', 'Gligorov', 'nikola.gligorov@gmail.com', '1989-05-05', 'A+', 'MALE', '076332211', '0505989123489'), - (35, 'Sara', 'Ilieva', 'sara.ilieva@gmail.com', '2002-12-12', 'AB+', 'FEMALE', '077221100', '1212022123490'), - (36, 'Petar', 'Markovski', 'petar.markovski@gmail.com', '1993-03-03', 'O+', 'MALE', '078110099', '0303993123491'), - (37, 'Ivana', 'Petrovska', 'ivana.petrovska@gmail.com', '1997-07-07', 'A-', 'FEMALE', '070223344', '0707997123492'), - (38, 'Goran', 'Nikolovski', 'goran.nikolovski@gmail.com', '1986-10-10', 'B+', 'MALE', '071334455', '1010986123493'), - (39, 'Jana', 'Ristova', 'jana.ristova@gmail.com', '2000-01-20', 'O-', 'FEMALE', '072445566', '2001000123494'); - + (1, 'Maja', 'Veljanova', 'maja.veljanova@gmail.com', '1994-02-14', 'A+', 'FEMALE', '070111222', '1402994123456', 2), + (2, 'Kristijan', 'Bojkov', 'kristijan.bojkov@gmail.com', '1991-06-21', 'O-', 'MALE', '071222333', '2106991123457', 3), + (3, 'Tamara', 'Gorgieva', 'tamara.gorgieva@gmail.com', '2000-11-03', 'B+', 'FEMALE', '072333444', '0311000123458', 4), + (4, 'Aleks', 'Nikolovski', 'aleks.nikolovski@gmail.com', '1988-09-10', 'AB+', 'MALE', '073444555', '1009988123459', 5), + (5, 'Sara', 'Milevska', 'sara.milevska@gmail.com', '1997-12-25', 'A-', 'FEMALE', '074555666', '2512997123460', 6), + (6, 'Stefan', 'Arsovski', 'stefan.arsovski@gmail.com', '1993-04-18', 'O+', 'MALE', '075666777', '1804993123461', 7), + (7, 'Elena', 'Petreska', 'elena.petreska@gmail.com', '1999-07-09', 'B-', 'FEMALE', '076777888', '0907999123462', 8), + (8, 'Viktor', 'Stankov', 'viktor.stankov@gmail.com', '1990-01-30', 'A+', 'MALE', '077888999', '3001990123463', 9), + (9, 'Ivana', 'Dimitrova', 'ivana.dimitrova@gmail.com', '1995-05-12', 'O-', 'FEMALE', '078999111', '1205995123464', 10), + (10, 'Marko', 'Lazarevski', 'marko.lazarevski@gmail.com', '1987-08-22', 'AB-', 'MALE', '070123456', '2208987123465', 11), + (11, 'Jana', 'Trajkovska', 'jana.trajkovska@gmail.com', '2001-03-17', 'A+', 'FEMALE', '071234567', '1703001123466', 12), + (12, 'Petar', 'Kostov', 'petar.kostov@gmail.com', '1992-10-05', 'B+', 'MALE', '072345678', '0510992123467', 13), + (13, 'Ana', 'Ristova', 'ana.ristova@gmail.com', '1996-06-28', 'O+', 'FEMALE', '073456789', '2806996123468', 14), + (14, 'Nikola', 'Sokolov', 'nikola.sokolov@gmail.com', '1989-02-11', 'A-', 'MALE', '074567890', '1102989123469', 15), + (15, 'Mila', 'Petrova', 'mila.petrova@gmail.com', '2002-09-19', 'AB+', 'FEMALE', '075678901', '1909022123470', 16), + (16, 'Dejan', 'Ilievski', 'dejan.ilievski@gmail.com', '1994-11-11', 'O+', 'MALE', '076789012', '1111994123471', 17), + (17, 'Kristina', 'Markovska', 'kristina.markovska@gmail.com', '1998-01-14', 'B+', 'FEMALE', '077890123', '1401988123472', 18), + (18, 'Goran', 'Petrov', 'goran.petrov@gmail.com', '1986-07-07', 'A+', 'MALE', '078901234', '0707986123473', 19), + (19, 'Sofija', 'Nikolova', 'sofija.nikolova@gmail.com', '2000-12-02', 'O-', 'FEMALE', '070112233', '0212000123474', 20), + (20, 'Dimitar', 'Angelov', 'dimitar.angelov@gmail.com', '1991-03-03', 'B-', 'MALE', '071223344', '0303991123475', 21), + (21, 'Teodora', 'Hristova', 'teodora.hristova@gmail.com', '1997-08-08', 'A+', 'FEMALE', '072334455', '0808997123476', 22), + (22, 'Filip', 'Stojanov', 'filip.stojanov@gmail.com', '1993-05-15', 'AB+', 'MALE', '073445566', '1505993123477', 23), + (23, 'Marija', 'Kirovska', 'marija.kirovska@gmail.com', '1999-10-10', 'O+', 'FEMALE', '074556677', '1010999123478', 24), + (24, 'Ivan', 'Bojkov', 'ivan.bojkov@gmail.com', '1988-12-12', 'A-', 'MALE', '075667788', '1212988123479', 25), + (25, 'Lina', 'Petrovska', 'lina.petrovska@gmail.com', '2001-04-04', 'B+', 'FEMALE', '076778899', '0404001123480', 26), + (26, 'Bojan', 'Spasov', 'bojan.spasov@gmail.com', '1992-02-20', 'O+', 'MALE', '077889900', '2002992123481', 27), + (27, 'Ana', 'Dimovska', 'ana.dimovska@gmail.com', '1995-09-09', 'A+', 'FEMALE', '078990011', '0909995123482', 28), + (28, 'Vladimir', 'Ristovski', 'vladimir.ristovski@gmail.com', '1987-06-16', 'AB-', 'MALE', '070998877', '1606987123483', 29), + (29, 'Katerina', 'Todorova', 'katerina.todorova@gmail.com', '2003-01-01', 'O-', 'FEMALE', '071887766', '0101033123484', 30), + (30, 'Martin', 'Iliev', 'martin.iliev@gmail.com', '1990-11-23', 'B+', 'MALE', '072776655', '2311990123485', 31), + (31, 'Elena', 'Trajkov', 'elena.trajkov@gmail.com', '1996-03-13', 'A-', 'FEMALE', '073665544', '1303996123486', 32), + (32, 'Aleksandar', 'Petrovski', 'aleksandar.petrovski@gmail.com', '1994-07-27', 'O+', 'MALE', '074554433', '2707994123487', 33), + (33, 'Maja', 'Stojanovska', 'maja.stojanovska@gmail.com', '1998-09-18', 'B-', 'FEMALE', '075443322', '1809998123488', 34), + (34, 'Nikola', 'Gligorov', 'nikola.gligorov@gmail.com', '1989-05-05', 'A+', 'MALE', '076332211', '0505989123489', 35), + (35, 'Sara', 'Ilieva', 'sara.ilieva@gmail.com', '2002-12-12', 'AB+', 'FEMALE', '077221100', '1212022123490', 36), + (36, 'Petar', 'Markovski', 'petar.markovski@gmail.com', '1993-03-03', 'O+', 'MALE', '078110099', '0303993123491', 37), + (37, 'Ivana', 'Petrovska', 'ivana.petrovska@gmail.com', '1997-07-07', 'A-', 'FEMALE', '070223344', '0707997123492', 38), + (38, 'Goran', 'Nikolovski', 'goran.nikolovski@gmail.com', '1986-10-10', 'B+', 'MALE', '071334455', '1010986123493', 39), + (39, 'Jana', 'Ristova', 'jana.ristova@gmail.com', '2000-01-20', 'O-', 'FEMALE', '072445566', '2001000123494', 40); @@ -525,11 +699,12 @@ name, lastname, - email + email, + user_id ) VALUES - (1, 'admin_ilija', 'Ilija', 'Stojanov', 'ilija.stojanov@adminmedora.com'), - (2, 'admin_elena', 'Elena', 'Kirova', 'elena.kirova@adminmedora.com'), - (3, 'admin_marjan', 'Marjan', 'Petrov', 'marjan.petrov@adminmedora.com'), - (4, 'admin_vesna', 'Vesna', 'Dimova', 'vesna.dimova@adminmedora.com'), - (5, 'admin_dushanka', 'Dushanka', 'Trajkovska', 'drushanka.trajkovska@adminmedora.com'); + (2, 'admin_ilija', 'Ilija', 'Stojanov', 'ilija.stojanov@adminmedora.com', 166), + (3, 'admin_elena', 'Elena', 'Kirova', 'elena.kirova@adminmedora.com', 167), + (4, 'admin_marjan', 'Marjan', 'Petrov', 'marjan.petrov@adminmedora.com', 168), + (5, 'admin_vesna', 'Vesna', 'Dimova', 'vesna.dimova@adminmedora.com', 169), + (6, 'admin_dushanka', 'Dushanka', 'Trajkovska', 'drushanka.trajkovska@adminmedora.com', 170); @@ -539,12 +714,12 @@ name, lastname, - email + email, + user_id ) VALUES - (1, 'lab_darko', 'Darko', 'Milosev', 'darko.milosev@labmedora.com'), - (2, 'lab_biljana', 'Biljana', 'Trajkovska', 'biljana.trajkovska@labmedora.com'), - (3, 'lab_stefan', 'Stefan', 'Nikolovski', 'stefan.nikolovski@labmedora.com'), - (4, 'lab_marina', 'Marina', 'Petreska', 'marina.petreska@labmedora.com'), - (5, 'lab_aleksandar', 'Aleksandar', 'Ristovski', 'aleksandar.ristovski@labmedora.com'); - + (1, 'lab_darko', 'Darko', 'Milosev', 'darko.milosev@labmedora.com', 161), + (2, 'lab_biljana', 'Biljana', 'Trajkovska', 'biljana.trajkovska@labmedora.com', 162), + (3, 'lab_stefan', 'Stefan', 'Nikolovski', 'stefan.nikolovski@labmedora.com', 163), + (4, 'lab_marina', 'Marina', 'Petreska', 'marina.petreska@labmedora.com', 164), + (5, 'lab_aleksandar', 'Aleksandar', 'Ristovski', 'aleksandar.ristovski@labmedora.com', 165); @@ -772,130 +947,129 @@ - -INSERT INTO procedures (procedure_id, procedure_type, procedure_date, description, cost, doctor_id, diagnosis_id) VALUES - (1, 'Spirometry', '2026-01-10', 'Lung function test measuring airflow', 50, 1, 4), - (2, 'Bronchoscopy', '2026-01-10', 'Endoscopic examination of airways', 200, 1, 4), - (3, 'Body plethysmography', '2026-01-11', 'Measurement of lung volumes', 180, 1, 5), - (4, 'Diffusion capacity test (DLCO)', '2026-01-11', 'Gas exchange efficiency test', 120, 1, 106), - (5, 'Peak flow measurement', '2026-01-12', 'Maximum exhalation speed test', 30, 1, 4), - (6, 'Blood gas analysis', '2026-01-12', 'Oxygen and CO2 level test', 70, 1, 5), - (7, 'Allergy testing', '2026-01-13', 'Identification of respiratory allergens', 90, 2, 94), - (8, 'Bronchodilator test', '2026-01-13', 'Asthma response test after medication', 80, 1, 4), - (9, 'ECG', '2026-01-14', 'Electrical heart activity recording', 40, 2, 74), - (10, 'Echocardiography', '2026-01-14', 'Ultrasound of the heart', 120, 2, 75), - (11, 'Stress test', '2026-01-15', 'Heart performance under exercise', 100, 2, 74), - (12, 'Holter ECG', '2026-01-15', '24h heart rhythm monitoring', 150, 2, 76), - (13, 'Blood pressure Holter', '2026-01-16', '24h blood pressure monitoring', 140, 2, 1), - (14, 'Cardiac catheterization', '2026-01-16', 'Invasive heart vessel examination', 600, 2, 74), - (15, 'Coronary angiography', '2026-01-17', 'Imaging of coronary arteries', 700, 2, 74), - (16, 'Transesophageal echo', '2026-01-17', 'Internal heart ultrasound', 300, 2, 75), - (17, 'EEG', '2026-01-18', 'Brain electrical activity test', 100, 3, 7), - (18, 'EMG', '2026-01-18', 'Muscle electrical activity test', 120, 3, 113), - (19, 'Evoked potentials', '2026-01-19', 'Nerve response measurement', 130, 3, 113), - (20, 'Lumbar puncture', '2026-01-19', 'CSF fluid collection from spine', 250, 3, 82), - (21, 'Nerve conduction study', '2026-01-20', 'Nerve signal speed test', 110, 3, 113), - (22, 'Carotid Doppler', '2026-01-20', 'Blood flow in neck arteries', 140, 3, 84), - (23, 'Arthroscopy', '2026-01-21', 'Joint inspection using camera', 500, 4, 11), - (24, 'Hip replacement', '2026-01-21', 'Surgical hip joint replacement', 5000, 4, 11), - (25, 'Knee replacement', '2026-01-22', 'Surgical knee joint replacement', 4800, 4, 11), - (26, 'Fracture fixation', '2026-01-22', 'Bone stabilization surgery', 1200, 4, 13), - (27, 'Ligament reconstruction', '2026-01-23', 'Repair of torn ligaments', 2500, 4, 11), - (28, 'Spine surgery', '2026-01-23', 'Surgical spinal intervention', 6000, 4, 14), - (29, 'Gynecological ultrasound', '2026-01-24', 'Ultrasound of female reproductive system', 80, 5, 139), - (30, 'Pap smear', '2026-01-24', 'Cervical cancer screening test', 60, 5, 31), - (31, 'Colposcopy', '2026-01-25', 'Detailed cervix examination', 120, 5, 31), - (32, 'Hysteroscopy', '2026-01-25', 'Uterine cavity inspection', 300, 5, 140), - (33, 'Laparoscopy', '2026-01-26', 'Minimally invasive abdominal surgery', 700, 5, 139), - (34, 'Cesarean section', '2026-01-26', 'Surgical delivery of baby', 1500, 5, 34), - (35, 'Delivery', '2026-01-27', 'Natural childbirth', 800, 5, 35), - (36, 'Cervical biopsy', '2026-01-27', 'Tissue sampling from cervix', 200, 5, 30), - (37, 'Audiometry', '2026-01-28', 'Hearing test', 50, 6, 60), - (38, 'Tympanometry', '2026-01-28', 'Middle ear function test', 60, 6, 57), - (39, 'Nasal endoscopy', '2026-01-29', 'Nasal cavity examination', 120, 6, 59), - (40, 'Laryngoscopy', '2026-01-29', 'Throat and voice box examination', 130, 6, 58), - (41, 'Tonsillectomy', '2026-01-30', 'Removal of tonsils', 400, 6, 58), - (42, 'Sinus surgery', '2026-01-30', 'Surgical sinus treatment', 1200, 6, 59), - (43, 'Vision exam', '2026-02-01', 'Eye vision testing', 40, 7, 60), - (44, 'Optical coherence tomography', '2026-02-01', 'Retina imaging', 150, 7, 63), - (45, 'Perimetry', '2026-02-02', 'Visual field test', 70, 7, 62), - (46, 'Cataract surgery', '2026-02-02', 'Lens replacement surgery', 2000, 7, 61), - (47, 'Laser eye surgery', '2026-02-03', 'Vision correction procedure', 2500, 7, 61), - (48, 'Complete blood count', '2026-02-03', 'Basic blood analysis', 30, 8, 41), - (49, 'Biochemistry panel', '2026-02-04', 'Blood chemical analysis', 50, 8, 2), - (50, 'Coagulation tests', '2026-02-04', 'Blood clotting tests', 60, 8, 43), - (51, 'Hormone tests', '2026-02-05', 'Hormonal level analysis', 80, 8, 47), - (52, 'Microbiology tests', '2026-02-05', 'Infection detection tests', 90, 8, 40), - (53, 'PCR test', '2026-02-06', 'DNA/RNA detection test', 100, 8, 36), - (54, 'X-ray', '2026-02-06', 'Basic imaging scan', 50, 9, 13), - (55, 'CT scan', '2026-02-07', 'Cross-sectional imaging', 200, 9, 13), - (56, 'MRI', '2026-02-07', 'Magnetic resonance imaging', 350, 9, 7), - (57, 'Ultrasound', '2026-02-08', 'Sound wave imaging', 70, 9, 139), - (58, 'Mammography', '2026-02-08', 'Breast imaging', 120, 9, 26), - (59, 'Interventional radiology', '2026-02-09', 'Image-guided procedures', 800, 9, 74), - (60, 'Gastroscopy', '2026-02-09', 'Stomach camera examination', 200, 10, 16), - (61, 'Colonoscopy', '2026-02-10', 'Colon examination', 300, 10, 121), - (62, 'Biopsy', '2026-02-10', 'Tissue sampling', 250, 10, 26), - (63, 'ERCP', '2026-02-11', 'Bile duct procedure', 600, 10, 20), - (64, 'Abdominal ultrasound', '2026-02-11', 'Abdominal organ imaging', 90, 9, 19), - (65, 'Urinary tract ultrasound', '2026-02-12', 'Kidney and bladder imaging', 90, 9, 23), - (66, 'Cystoscopy', '2026-02-12', 'Bladder examination', 200, 11, 23), - (67, 'Urodynamic testing', '2026-02-13', 'Urine flow analysis', 150, 11, 134), - (68, 'Lithotripsy', '2026-02-13', 'Kidney stone breaking', 500, 11, 25), - (69, 'TURP', '2026-02-14', 'Prostate surgery', 1200, 11, 131), - (70, 'Prostate biopsy', '2026-02-14', 'Prostate tissue sampling', 250, 11, 131), - (71, 'Hemodialysis', '2026-02-15', 'Blood cleaning procedure', 200, 12, 22), - (72, 'Peritoneal dialysis', '2026-02-15', 'Abdominal dialysis', 180, 12, 22), - (73, 'Kidney biopsy', '2026-02-16', 'Kidney tissue sampling', 300, 12, 21), - (74, 'Renal clearance tests', '2026-02-16', 'Kidney function tests', 100, 12, 22), - (75, 'Electrolyte tests', '2026-02-17', 'Blood mineral analysis', 60, 12, 100), - (76, 'Chemotherapy', '2026-02-17', 'Cancer drug treatment', 2000, 13, 26), - (77, 'Radiotherapy', '2026-02-18', 'Radiation cancer treatment', 2500, 13, 27), - (78, 'Tumor biopsy', '2026-02-18', 'Cancer tissue sampling', 400, 13, 26), - (79, 'PET scan', '2026-02-19', 'Cancer imaging scan', 900, 9, 26), - (80, 'Immunotherapy', '2026-02-19', 'Immune cancer treatment', 3000, 13, 28), - (81, 'Dermatological exam', '2026-02-20', 'Skin examination', 50, 14, 31), - (82, 'Dermatoscopy', '2026-02-20', 'Skin lesion imaging', 80, 14, 30), - (83, 'Skin biopsy', '2026-02-21', 'Skin tissue sampling', 200, 14, 31), - (84, 'Cryotherapy', '2026-02-21', 'Freezing skin treatment', 150, 14, 34), - (85, 'Laser treatments', '2026-02-22', 'Skin laser therapy', 500, 14, 34), - (86, 'Pediatric exam', '2026-02-22', 'Child medical checkup', 60, 15, 1), - (87, 'Vaccination', '2026-02-23', 'Immunization procedure', 40, 15, 1), - (88, 'Neonatal screening', '2026-02-23', 'Newborn testing', 100, 15, 1), - (89, 'Growth assessment', '2026-02-24', 'Child development check', 50, 15, 1), - (90, 'Psychiatric evaluation', '2026-02-24', 'Mental health assessment', 120, 16, 51), - (91, 'Psychotherapy', '2026-02-25', 'Therapy sessions', 100, 16, 51), - (92, 'Cognitive testing', '2026-02-25', 'Brain function testing', 80, 16, 54), - (93, 'Pharmacotherapy', '2026-02-26', 'Psychiatric medication treatment', 150, 16, 51), - (94, 'Physiotherapy', '2026-02-26', 'Physical rehabilitation treatment', 80, 17, 11), - (95, 'Kinesiotherapy', '2026-02-27', 'Movement-based therapy', 90, 17, 11), - (96, 'Electrotherapy', '2026-02-27', 'Electrical stimulation therapy', 70, 17, 72), - (97, 'Hydrotherapy', '2026-02-28', 'Water-based rehabilitation therapy', 100, 17, 72), - (98, 'Blood count', '2026-03-01', 'Detailed blood cell analysis', 40, 8, 41), - (99, 'Bone marrow biopsy', '2026-03-01', 'Bone marrow sampling', 400, 8, 43), - (100, 'Coagulation studies', '2026-03-02', 'Blood clotting analysis', 80, 8, 43), - (101, 'Blood transfusion', '2026-03-02', 'Transfer of blood products', 300, 8, 45), - (102, 'Serology tests', '2026-03-03', 'Antibody detection tests', 90, 8, 36), - (103, 'PCR diagnostics', '2026-03-03', 'Molecular infection detection', 120, 8, 40), - (104, 'Microbial cultures', '2026-03-04', 'Bacteria growth testing', 100, 8, 40), - (105, 'Antibiotic therapy', '2026-03-04', 'Infection treatment with antibiotics', 200, 1, 40), - (106, 'Brain surgery', '2026-03-05', 'Surgical brain intervention', 8000, 3, 82), - (107, 'Spine surgery', '2026-03-05', 'Surgical spinal operation', 7000, 4, 117), - (108, 'Tumor removal', '2026-03-06', 'Removal of brain tumors', 9000, 3, 82), - (109, 'Shunt procedure', '2026-03-06', 'CSF drainage surgery', 6000, 3, 82), - (110, 'CABG', '2026-03-07', 'Heart bypass surgery', 10000, 2, 74), - (111, 'Valve replacement', '2026-03-07', 'Heart valve surgery', 9500, 2, 75), - (112, 'Pacemaker implantation', '2026-03-08', 'Heart rhythm device installation', 5000, 2, 76), - (113, 'Reconstructive surgery', '2026-03-08', 'Restoration of body structures', 4000, 4, 35), - (114, 'Cosmetic surgery', '2026-03-09', 'Aesthetic body improvement', 3500, 14, 33), - (115, 'Liposuction', '2026-03-09', 'Fat removal procedure', 3000, 14, 66), - (116, 'Rhinoplasty', '2026-03-10', 'Nose reshaping surgery', 3200, 6, 35), - (117, 'Appendectomy', '2026-03-10', 'Appendix removal surgery', 1500, 10, 19), - (118, 'Hernia repair', '2026-03-11', 'Hernia correction surgery', 1800, 10, 90), - (119, 'Gallbladder removal', '2026-03-11', 'Cholecystectomy procedure', 2000, 10, 20), - (120, 'Surgical biopsy', '2026-03-12', 'Tissue sampling surgery', 900, 13, 26), - (121, 'Tooth extraction', '2026-03-12', 'Removal of tooth', 100, 18, 35), - (122, 'Dental filling', '2026-03-13', 'Cavity repair', 120, 18, 35), - (123, 'Dental implants', '2026-03-13', 'Artificial tooth implantation', 1500, 18, 35), - (124, 'Teeth cleaning', '2026-03-14', 'Dental plaque removal', 80, 18, 35); +INSERT INTO procedures (procedure_id, procedure_type, procedure_date, description, cost, doctor_id) VALUES + (1, 'Spirometry', '2026-01-10', 'Lung function test measuring airflow', 50, 1), + (2, 'Bronchoscopy', '2026-01-10', 'Endoscopic examination of airways', 200, 1), + (3, 'Body plethysmography', '2026-01-11', 'Measurement of lung volumes', 180, 1), + (4, 'Diffusion capacity test (DLCO)', '2026-01-11', 'Gas exchange efficiency test', 120, 1), + (5, 'Peak flow measurement', '2026-01-12', 'Maximum exhalation speed test', 30, 1), + (6, 'Blood gas analysis', '2026-01-12', 'Oxygen and CO2 level test', 70, 1), + (7, 'Allergy testing', '2026-01-13', 'Identification of respiratory allergens', 90, 2), + (8, 'Bronchodilator test', '2026-01-13', 'Asthma response test after medication', 80, 1), + (9, 'ECG', '2026-01-14', 'Electrical heart activity recording', 40, 2), + (10, 'Echocardiography', '2026-01-14', 'Ultrasound of the heart', 120, 2), + (11, 'Stress test', '2026-01-15', 'Heart performance under exercise', 100, 2), + (12, 'Holter ECG', '2026-01-15', '24h heart rhythm monitoring', 150, 2), + (13, 'Blood pressure Holter', '2026-01-16', '24h blood pressure monitoring', 140, 2), + (14, 'Cardiac catheterization', '2026-01-16', 'Invasive heart vessel examination', 600, 2), + (15, 'Coronary angiography', '2026-01-17', 'Imaging of coronary arteries', 700, 2), + (16, 'Transesophageal echo', '2026-01-17', 'Internal heart ultrasound', 300, 2), + (17, 'EEG', '2026-01-18', 'Brain electrical activity test', 100, 3), + (18, 'EMG', '2026-01-18', 'Muscle electrical activity test', 120, 3), + (19, 'Evoked potentials', '2026-01-19', 'Nerve response measurement', 130, 3), + (20, 'Lumbar puncture', '2026-01-19', 'CSF fluid collection from spine', 250, 3), + (21, 'Nerve conduction study', '2026-01-20', 'Nerve signal speed test', 110, 3), + (22, 'Carotid Doppler', '2026-01-20', 'Blood flow in neck arteries', 140, 3), + (23, 'Arthroscopy', '2026-01-21', 'Joint inspection using camera', 500, 4), + (24, 'Hip replacement', '2026-01-21', 'Surgical hip joint replacement', 5000, 4), + (25, 'Knee replacement', '2026-01-22', 'Surgical knee joint replacement', 4800, 4), + (26, 'Fracture fixation', '2026-01-22', 'Bone stabilization surgery', 1200, 4), + (27, 'Ligament reconstruction', '2026-01-23', 'Repair of torn ligaments', 2500, 4), + (28, 'Spine surgery', '2026-01-23', 'Surgical spinal intervention', 6000, 4), + (29, 'Gynecological ultrasound', '2026-01-24', 'Ultrasound of female reproductive system', 80, 5), + (30, 'Pap smear', '2026-01-24', 'Cervical cancer screening test', 60, 5), + (31, 'Colposcopy', '2026-01-25', 'Detailed cervix examination', 120, 5), + (32, 'Hysteroscopy', '2026-01-25', 'Uterine cavity inspection', 300, 5), + (33, 'Laparoscopy', '2026-01-26', 'Minimally invasive abdominal surgery', 700, 5), + (34, 'Cesarean section', '2026-01-26', 'Surgical delivery of baby', 1500, 5), + (35, 'Delivery', '2026-01-27', 'Natural childbirth', 800, 5), + (36, 'Cervical biopsy', '2026-01-27', 'Tissue sampling from cervix', 200, 5), + (37, 'Audiometry', '2026-01-28', 'Hearing test', 50, 6), + (38, 'Tympanometry', '2026-01-28', 'Middle ear function test', 60, 6), + (39, 'Nasal endoscopy', '2026-01-29', 'Nasal cavity examination', 120, 6), + (40, 'Laryngoscopy', '2026-01-29', 'Throat and voice box examination', 130, 6), + (41, 'Tonsillectomy', '2026-01-30', 'Removal of tonsils', 400, 6), + (42, 'Sinus surgery', '2026-01-30', 'Surgical sinus treatment', 1200, 6), + (43, 'Vision exam', '2026-02-01', 'Eye vision testing', 40, 7), + (44, 'Optical coherence tomography', '2026-02-01', 'Retina imaging', 150, 7), + (45, 'Perimetry', '2026-02-02', 'Visual field test', 70, 7), + (46, 'Cataract surgery', '2026-02-02', 'Lens replacement surgery', 2000, 7), + (47, 'Laser eye surgery', '2026-02-03', 'Vision correction procedure', 2500, 7), + (48, 'Complete blood count', '2026-02-03', 'Basic blood analysis', 30, 8), + (49, 'Biochemistry panel', '2026-02-04', 'Blood chemical analysis', 50, 8), + (50, 'Coagulation tests', '2026-02-04', 'Blood clotting tests', 60, 8), + (51, 'Hormone tests', '2026-02-05', 'Hormonal level analysis', 80, 8), + (52, 'Microbiology tests', '2026-02-05', 'Infection detection tests', 90, 8), + (53, 'PCR test', '2026-02-06', 'DNA/RNA detection test', 100, 8), + (54, 'X-ray', '2026-02-06', 'Basic imaging scan', 50, 9), + (55, 'CT scan', '2026-02-07', 'Cross-sectional imaging', 200, 9), + (56, 'MRI', '2026-02-07', 'Magnetic resonance imaging', 350, 9), + (57, 'Ultrasound', '2026-02-08', 'Sound wave imaging', 70, 9), + (58, 'Mammography', '2026-02-08', 'Breast imaging', 120, 9), + (59, 'Interventional radiology', '2026-02-09', 'Image-guided procedures', 800, 9), + (60, 'Gastroscopy', '2026-02-09', 'Stomach camera examination', 200, 10), + (61, 'Colonoscopy', '2026-02-10', 'Colon examination', 300, 10), + (62, 'Biopsy', '2026-02-10', 'Tissue sampling', 250, 10), + (63, 'ERCP', '2026-02-11', 'Bile duct procedure', 600, 10), + (64, 'Abdominal ultrasound', '2026-02-11', 'Abdominal organ imaging', 90, 9), + (65, 'Urinary tract ultrasound', '2026-02-12', 'Kidney and bladder imaging', 90, 9), + (66, 'Cystoscopy', '2026-02-12', 'Bladder examination', 200, 11), + (67, 'Urodynamic testing', '2026-02-13', 'Urine flow analysis', 150, 11), + (68, 'Lithotripsy', '2026-02-13', 'Kidney stone breaking', 500, 11), + (69, 'TURP', '2026-02-14', 'Prostate surgery', 1200, 11), + (70, 'Prostate biopsy', '2026-02-14', 'Prostate tissue sampling', 250, 11), + (71, 'Hemodialysis', '2026-02-15', 'Blood cleaning procedure', 200, 12), + (72, 'Peritoneal dialysis', '2026-02-15', 'Abdominal dialysis', 180, 12), + (73, 'Kidney biopsy', '2026-02-16', 'Kidney tissue sampling', 300, 12), + (74, 'Renal clearance tests', '2026-02-16', 'Kidney function tests', 100, 12), + (75, 'Electrolyte tests', '2026-02-17', 'Blood mineral analysis', 60, 12), + (76, 'Chemotherapy', '2026-02-17', 'Cancer drug treatment', 2000, 13), + (77, 'Radiotherapy', '2026-02-18', 'Radiation cancer treatment', 2500, 13), + (78, 'Tumor biopsy', '2026-02-18', 'Cancer tissue sampling', 400, 13), + (79, 'PET scan', '2026-02-19', 'Cancer imaging scan', 900, 9), + (80, 'Immunotherapy', '2026-02-19', 'Immune cancer treatment', 3000, 13), + (81, 'Dermatological exam', '2026-02-20', 'Skin examination', 50, 14), + (82, 'Dermatoscopy', '2026-02-20', 'Skin lesion imaging', 80, 14), + (83, 'Skin biopsy', '2026-02-21', 'Skin tissue sampling', 200, 14), + (84, 'Cryotherapy', '2026-02-21', 'Freezing skin treatment', 150, 14), + (85, 'Laser treatments', '2026-02-22', 'Skin laser therapy', 500, 14), + (86, 'Pediatric exam', '2026-02-22', 'Child medical checkup', 60, 15), + (87, 'Vaccination', '2026-02-23', 'Immunization procedure', 40, 15), + (88, 'Neonatal screening', '2026-02-23', 'Newborn testing', 100, 15), + (89, 'Growth assessment', '2026-02-24', 'Child development check', 50, 15), + (90, 'Psychiatric evaluation', '2026-02-24', 'Mental health assessment', 120, 16), + (91, 'Psychotherapy', '2026-02-25', 'Therapy sessions', 100, 16), + (92, 'Cognitive testing', '2026-02-25', 'Brain function testing', 80, 16), + (93, 'Pharmacotherapy', '2026-02-26', 'Psychiatric medication treatment', 150, 16), + (94, 'Physiotherapy', '2026-02-26', 'Physical rehabilitation treatment', 80, 17), + (95, 'Kinesiotherapy', '2026-02-27', 'Movement-based therapy', 90, 17), + (96, 'Electrotherapy', '2026-02-27', 'Electrical stimulation therapy', 70, 17), + (97, 'Hydrotherapy', '2026-02-28', 'Water-based rehabilitation therapy', 100, 17), + (98, 'Blood count', '2026-03-01', 'Detailed blood cell analysis', 40, 8), + (99, 'Bone marrow biopsy', '2026-03-01', 'Bone marrow sampling', 400, 8), + (100, 'Coagulation studies', '2026-03-02', 'Blood clotting analysis', 80, 8), + (101, 'Blood transfusion', '2026-03-02', 'Transfer of blood products', 300, 8), + (102, 'Serology tests', '2026-03-03', 'Antibody detection tests', 90, 8), + (103, 'PCR diagnostics', '2026-03-03', 'Molecular infection detection', 120, 8), + (104, 'Microbial cultures', '2026-03-04', 'Bacteria growth testing', 100, 8), + (105, 'Antibiotic therapy', '2026-03-04', 'Infection treatment with antibiotics', 200, 1), + (106, 'Brain surgery', '2026-03-05', 'Surgical brain intervention', 8000, 3), + (107, 'Spine surgery', '2026-03-05', 'Surgical spinal operation', 7000, 4), + (108, 'Tumor removal', '2026-03-06', 'Removal of brain tumors', 9000, 3), + (109, 'Shunt procedure', '2026-03-06', 'CSF drainage surgery', 6000, 3), + (110, 'CABG', '2026-03-07', 'Heart bypass surgery', 10000, 2), + (111, 'Valve replacement', '2026-03-07', 'Heart valve surgery', 9500, 2), + (112, 'Pacemaker implantation', '2026-03-08', 'Heart rhythm device installation', 5000, 2), + (113, 'Reconstructive surgery', '2026-03-08', 'Restoration of body structures', 4000, 4), + (114, 'Cosmetic surgery', '2026-03-09', 'Aesthetic body improvement', 3500, 14), + (115, 'Liposuction', '2026-03-09', 'Fat removal procedure', 3000, 14), + (116, 'Rhinoplasty', '2026-03-10', 'Nose reshaping surgery', 3200, 6), + (117, 'Appendectomy', '2026-03-10', 'Appendix removal surgery', 1500, 10), + (118, 'Hernia repair', '2026-03-11', 'Hernia correction surgery', 1800, 10), + (119, 'Gallbladder removal', '2026-03-11', 'Cholecystectomy procedure', 2000, 10), + (120, 'Surgical biopsy', '2026-03-12', 'Tissue sampling surgery', 900, 13), + (121, 'Tooth extraction', '2026-03-12', 'Removal of tooth', 100, 18), + (122, 'Dental filling', '2026-03-13', 'Cavity repair', 120, 18), + (123, 'Dental implants', '2026-03-13', 'Artificial tooth implantation', 1500, 18), + (124, 'Teeth cleaning', '2026-03-14', 'Dental plaque removal', 80, 18); @@ -1128,67 +1302,48 @@ INSERT INTO billing (bill_id, total_cost, payment_status, payment_date, record_id, admin_id) VALUES - (1, 230, 'PAID', '2026-05-11', 1, 1), - (2, 340, 'PENDING', NULL, 2, 1), - (3, 900, 'PAID', '2026-05-10', 3, 2), - (4, 5200, 'PAID', '2026-05-09', 4, 1), - (5, 180, 'PAID', '2026-05-08', 5, 3), - (6, 420, 'PENDING', NULL, 6, 2), - (7, 160, 'PAID', '2026-05-07', 7, 3), - (8, 780, 'PENDING', NULL, 8, 1), - (9, 250, 'PAID', '2026-05-06', 9, 2), - (10, 610, 'PENDING', NULL, 10, 3); + (1, 230, 'PAID', '2026-05-11', 1, 2), + (2, 340, 'PENDING', NULL, 2, 2), + (3, 900, 'PAID', '2026-05-10', 3, 3), + (4, 5200, 'PAID', '2026-05-09', 4, 2), + (5, 180, 'PAID', '2026-05-08', 5, 4), + (6, 420, 'PENDING', NULL, 6, 3), + (7, 160, 'PAID', '2026-05-07', 7, 4), + (8, 780, 'PENDING', NULL, 8, 2), + (9, 250, 'PAID', '2026-05-06', 9, 3), + (10, 610, 'PENDING', NULL, 10, 4); INSERT INTO patient_allergies (patient_id, allergy_id) VALUES --- Patient 1 allergies -(1, 1), -- Penicillin -(1, 3), -- Dust --- Patient 2 allergies -(2, 2), -- Peanuts -(2, 5), -- Pollen --- Patient 3 allergies -(3, 4), -- Lactose --- Patient 4 allergies -(4, 1), -- Penicillin -(4, 6), -- Bee sting --- Patient 5 allergies -(5, 3), -- Dust -(5, 2), -- Peanuts --- Patient 6 allergies -(6, 7), -- Shellfish --- Patient 7 allergies -(7, 5), -- Pollen -(7, 8), -- Latex --- Patient 8 allergies -(8, 4), -- Lactose -(8, 1), -- Penicillin --- Patient 9 allergies -(9, 6), -- Bee sting --- Patient 10 allergies -(10, 2); -- Peanuts +(1, 1), +(1, 3), +(2, 2), +(2, 5), +(3, 4), +(4, 1), +(4, 6), +(5, 3), +(5, 2), +(6, 7), +(7, 5), +(7, 8), +(8, 4), +(8, 1), +(9, 6), +(10, 2); INSERT INTO allergy_prescription_restrictions (allergy_id, restriction_id) VALUES --- Penicillin allergy restrictions -(1, 1), -- avoid Amoxicillin-based drugs -(1, 2), -- avoid Ampicillin-based drugs --- Peanuts allergy restrictions -(2, 3), -- avoid capsule-based allergens -(2, 4), -- avoid certain oral suspensions with traces --- Dust allergy restrictions -(3, 5), -- avoid inhaled powder medications --- Lactose allergy restrictions -(4, 6), -- avoid lactose-containing tablets --- Pollen allergy restrictions -(5, 5), -- avoid inhalation-based medications --- Bee sting allergy restrictions -(6, 7), -- avoid adrenaline-triggering compounds unless emergency -(6, 8), -- caution with immunotherapy drugs --- Shellfish allergy restrictions -(7, 3), -- capsule-based restrictions (gelatin overlap) -(7, 9), -- contrast media precaution --- Latex allergy restrictions -(8, 10), -- avoid latex-containing medical devices --- Mixed severe allergies +(1, 1), +(1, 2), +(2, 3), +(2, 4), +(3, 5), +(4, 6), +(5, 5), +(6, 7), +(6, 8), +(7, 3), +(7, 9), +(8, 10), (1, 6), (2, 6), @@ -1197,35 +1352,25 @@ INSERT INTO patient_symptoms (patient_id, symptom_id) VALUES --- Patient 1 -(1, 1), -- Fever -(1, 2), -- Cough -(1, 5), -- Fatigue --- Patient 2 -(2, 3), -- Headache -(2, 4), -- Sore throat --- Patient 3 -(3, 6), -- Shortness of breath -(3, 2), -- Cough --- Patient 4 -(4, 7), -- Chest pain -(4, 5), -- Fatigue --- Patient 5 -(5, 8), -- Nausea -(5, 9), -- Dizziness --- Patient 6 -(6, 1), -- Fever -(6, 6), -- Shortness of breath --- Patient 7 -(7, 10), -- Joint pain -(7, 5), -- Fatigue --- Patient 8 -(8, 3), -- Headache -(8, 9), -- Dizziness --- Patient 9 -(9, 4), -- Sore throat -(9, 2), -- Cough --- Patient 10 -(10, 11), -- Skin rash -(10, 5); -- Fatigue +(1, 1), +(1, 2), +(1, 5), +(2, 3), +(2, 4), +(3, 6), +(3, 2), +(4, 7), +(4, 5), +(5, 8), +(5, 9), +(6, 1), +(6, 6), +(7, 10), +(7, 5), +(8, 3), +(8, 9), +(9, 4), +(9, 2), +(10, 11), +(10, 5); INSERT INTO diagnosis_symptoms (diagnosis_id, symptom_id) VALUES @@ -1274,26 +1419,4 @@ (7,20); -INSERT INTO diagnosis_procedures (diagnosis_id, procedure_id) VALUES - (1,1), - (1,2), - (2,3), - (2,4), - (3,5), - (3,6), - (4,7), - (4,8), - (5,9), - (5,10), - (6,11), - (6,12), - (7,13), - (7,14), - (8,15), - (8,16), - (9,17), - (9,18), - (10,19), - (10,20); - INSERT INTO department_procedures (department_id, procedure_id) VALUES (1,1), @@ -1360,21 +1483,4 @@ (9,1), (10,2); - -INSERT INTO doctor_medical_records (doctor_id, record_id) VALUES - (1,1), - (1,2), - (1,3), - (2,4), - (2,5), - (2,6), - (3,7), - (3,8), - (3,9), - (4,10), - (4,11), - (5,12), - (5,13), - (6,14), - (6,15); INSERT INTO diagnosis_medical_records (diagnosis_id, record_id) VALUES @@ -1522,25 +1628,25 @@ INSERT INTO medical_record_symptoms (record_id, symptom_id, severity) VALUES - (1,1,'HIGH'), - (1,2,'MEDIUM'), - (1,5,'LOW'), - (2,3,'MEDIUM'), - (2,4,'LOW'), - (3,6,'HIGH'), - (3,2,'MEDIUM'), - (4,7,'HIGH'), - (4,5,'MEDIUM'), - (5,8,'LOW'), - (5,9,'MEDIUM'), - (6,1,'HIGH'), - (6,6,'HIGH'), - (7,10,'MEDIUM'), - (7,5,'LOW'), - (8,3,'MEDIUM'), - (8,9,'LOW'), - (9,4,'MEDIUM'), - (9,2,'LOW'), - (10,11,'LOW'), - (10,5,'MEDIUM'); + (1,1,'HIGH'), + (1,2,'MEDIUM'), + (1,5,'LOW'), + (2,3,'MEDIUM'), + (2,4,'LOW'), + (3,6,'HIGH'), + (3,2,'MEDIUM'), + (4,7,'HIGH'), + (4,5,'MEDIUM'), + (5,8,'LOW'), + (5,9,'MEDIUM'), + (6,1,'HIGH'), + (6,6,'HIGH'), + (7,10,'MEDIUM'), + (7,5,'LOW'), + (8,3,'MEDIUM'), + (8,9,'LOW'), + (9,4,'MEDIUM'), + (9,2,'LOW'), + (10,11,'LOW'), + (10,5,'MEDIUM'); INSERT INTO medical_record_allergies (record_id, allergy_id, reaction, severity) VALUES @@ -1567,3 +1673,2 @@ COMMIT; -