| 1 | --
|
|---|
| 2 | -- PostgreSQL database dump
|
|---|
| 3 | --
|
|---|
| 4 |
|
|---|
| 5 | SET statement_timeout = 0;
|
|---|
| 6 | SET lock_timeout = 0;
|
|---|
| 7 | SET idle_in_transaction_session_timeout = 0;
|
|---|
| 8 | SET transaction_timeout = 0;
|
|---|
| 9 | SET client_encoding = 'UTF8';
|
|---|
| 10 | SET standard_conforming_strings = on;
|
|---|
| 11 | SELECT pg_catalog.set_config('search_path', '', false);
|
|---|
| 12 | SET check_function_bodies = false;
|
|---|
| 13 | SET xmloption = content;
|
|---|
| 14 | SET client_min_messages = warning;
|
|---|
| 15 | SET row_security = off;
|
|---|
| 16 |
|
|---|
| 17 |
|
|---|
| 18 | INSERT INTO synergymed.users VALUES (1, 'Иван', 'Петровски', 'ivan.petrovski', '$2a$12$4nkaobUd.oVHdb5RLcuEe.FyjoFotxXvfs8smAPi1EJskPY2YPBuu', 'ivan.petrovski@example.com', 'машки', '2023-02-15', '1990-03-14', true, true, true, true);
|
|---|
| 19 | INSERT INTO synergymed.users VALUES (2, 'Ана', 'Петрова', 'ana.petrova', '$2a$12$MOTA1vYT5fRX64aUzP7b3ea2Dl7ifvFWrTtKpD9.5huRVposj0nNO', 'ana.petrova@example.com', 'женски', '2023-03-10', '1992-07-23', true, true, true, true);
|
|---|
| 20 | INSERT INTO synergymed.users VALUES (3, 'Марко', 'Јовановски', 'marko.jovanovski', '$2a$12$j/tM9VZ4EVsqZ8rvdJmDLuEGq/ynFBRXEKB0ekRktFwoPCo1aoScW', 'marko.jovanovski@example.com', 'машки', '2023-05-21', '1988-11-05', true, true, true, true);
|
|---|
| 21 | INSERT INTO synergymed.users VALUES (4, 'Марија', 'Јованова', 'marija.jovanova', '$2a$12$oN1vWyausLL.CUs0Yog1.u3J4ob3DgAu/tQDwjRMf9JN4TwAm3Ij.', 'marija.jovanova@example.com', 'женски', '2023-06-07', '1995-01-29', true, true, true, true);
|
|---|
| 22 | INSERT INTO synergymed.users VALUES (5, 'Дамјан', 'Илиевски', 'damjan.ilievski', '$2a$12$wdXYGgKHX.lOAhiZTUKKsO.ftSUFWxt9aZoNb6N/fi45.O4geR6eO', 'damjan.ilievski@example.com', 'машки', '2023-08-30', '1991-09-12', true, true, true, true);
|
|---|
| 23 | INSERT INTO synergymed.users VALUES (6, 'Елена', 'Николова', 'elena.nikolova', '$2a$12$gji9c7bwiAwCmPnViYeWUuMsq1HKOJwvoILnxLhcUCIWU7pL1yHIO', 'elena.nikolova@example.com', 'женски', '2023-11-12', '1993-04-08', true, true, true, true);
|
|---|
| 24 | INSERT INTO synergymed.users VALUES (7, 'Горан', 'Димитров', 'goran.dimitrov', '$2a$12$pw9m/1iNHEg//uucnEOwbuD3PjvIoanz58CGRE20SsoFnWn8tWIHG', 'goran.dimitrov@example.com', 'машки', '2024-01-19', '1987-02-18', true, true, true, true);
|
|---|
| 25 | INSERT INTO synergymed.users VALUES (8, 'Катарина', 'Стојанова', 'katarina.stojanova', '$2a$12$rwezKMPV4BZUrZPdk0ZEguyd/lw.cvycJla/Ck75tqvS3rCaL9W9C', 'katarina.stojanova@example.com', 'женски', '2024-04-03', '1994-10-02', true, true, true, true);
|
|---|
| 26 | INSERT INTO synergymed.users VALUES (9, 'Александар', 'Николов', 'aleksandar.nikolov', '$2a$12$h5i3jCDonXHp9lpGC0rNlOUxOqsaxUZwl/8UKZDZyUNF8CBE2KDSK', 'aleksandar.nikolov@example.com', 'машки', '2024-06-25', '1989-07-07', true, true, true, true);
|
|---|
| 27 | INSERT INTO synergymed.users VALUES (10, 'Теодора', 'Костова', 'teodora.kostova', '$2a$12$UxDgq0rE5zYgnID0Pwxcp.HtBaaEyKfWlH299MCrY5DE1ZGtd2.dq', 'teodora.kostova@example.com', 'женски', '2024-09-14', '1996-12-15', true, true, true, true);
|
|---|
| 28 |
|
|---|
| 29 |
|
|---|
| 30 | INSERT INTO synergymed.admins VALUES (9);
|
|---|
| 31 | INSERT INTO synergymed.admins VALUES (10);
|
|---|
| 32 |
|
|---|
| 33 |
|
|---|
| 34 | INSERT INTO synergymed.client VALUES (2, false);
|
|---|
| 35 | INSERT INTO synergymed.client VALUES (3, true);
|
|---|
| 36 | INSERT INTO synergymed.client VALUES (4, false);
|
|---|
| 37 | INSERT INTO synergymed.client VALUES (5, false);
|
|---|
| 38 | INSERT INTO synergymed.client VALUES (1, true);
|
|---|
| 39 | INSERT INTO synergymed.client VALUES (6, true);
|
|---|
| 40 |
|
|---|
| 41 |
|
|---|
| 42 | INSERT INTO synergymed.healthprofile VALUES (1, 1, 'A+');
|
|---|
| 43 | INSERT INTO synergymed.healthprofile VALUES (2, 2, 'O-');
|
|---|
| 44 | INSERT INTO synergymed.healthprofile VALUES (3, 4, 'B+');
|
|---|
| 45 | INSERT INTO synergymed.healthprofile VALUES (4, 3, 'B-');
|
|---|
| 46 | INSERT INTO synergymed.healthprofile VALUES (5, 5, 'O-');
|
|---|
| 47 |
|
|---|
| 48 |
|
|---|
| 49 | INSERT INTO synergymed.medicine VALUES (1, 'Парацетамол', 'Парацетамол');
|
|---|
| 50 | INSERT INTO synergymed.medicine VALUES (2, 'Пропифеназон', 'Пропифеназон');
|
|---|
| 51 | INSERT INTO synergymed.medicine VALUES (3, 'Кофеин', 'Кофеин');
|
|---|
| 52 | INSERT INTO synergymed.medicine VALUES (4, 'Кодеин фосфат', 'Кодеин фосфат');
|
|---|
| 53 | INSERT INTO synergymed.medicine VALUES (5, 'Ибупрофен', 'Ибупрофен');
|
|---|
| 54 | INSERT INTO synergymed.medicine VALUES (6, 'Азитромицин', 'Азитромицин');
|
|---|
| 55 | INSERT INTO synergymed.medicine VALUES (7, 'Бензидамин хидрохлорид', 'Бензидамин хидрохлорид');
|
|---|
| 56 | INSERT INTO synergymed.medicine VALUES (8, 'Силденафил цитрат', 'Силденафил цитрат');
|
|---|
| 57 |
|
|---|
| 58 |
|
|---|
| 59 | INSERT INTO synergymed.allergicreaction_healthprofile_medicine VALUES (1, 6, '2018-09-17', 'Алергија на азитромицин (осип).', 'лесна');
|
|---|
| 60 | INSERT INTO synergymed.allergicreaction_healthprofile_medicine VALUES (2, 5, '2020-03-03', 'Неподносливост на НСАИЛ (ибупрофен) – гастроинтестинални симптоми.', 'умерена');
|
|---|
| 61 |
|
|---|
| 62 |
|
|---|
| 63 | INSERT INTO synergymed.company VALUES (1, 'Алкалоид АД Скопје', 'Фармацевтска компанија со производство и дистрибуција на лекови, козметика и хемиски производи.', 'MK-ALK-1936');
|
|---|
| 64 | INSERT INTO synergymed.company VALUES (2, 'Реплек АД Скопје', 'Производител на генерички лекови и производи за орална и топикална примена.', 'MK-REP-1945');
|
|---|
| 65 | INSERT INTO synergymed.company VALUES (3, 'Зегин ДОО Скопје', 'Аптекарска мрежа и малопродажба на лекови и здравствени производи.', 'MK-ZEG-1990');
|
|---|
| 66 | INSERT INTO synergymed.company VALUES (4, 'ЕЛС ДООЕЛ Скопје', 'Приватна пошта и логистика (Eco Logistic Service) со домашни и меѓународни услуги.', 'MK-ELS-2001');
|
|---|
| 67 |
|
|---|
| 68 |
|
|---|
| 69 | INSERT INTO synergymed.manufacturer VALUES (1);
|
|---|
| 70 | INSERT INTO synergymed.manufacturer VALUES (2);
|
|---|
| 71 |
|
|---|
| 72 |
|
|---|
| 73 | INSERT INTO synergymed.brandedmedicine VALUES (1, 1, 180.00, 'Комбиниран аналгетик: парацетамол, пропифеназон, кофеин, кодеин.', 'таблета', 'Paracetamol 250 mg / Propyphenazone 210 mg / Caffeine 50 mg / Codeine 10 mg', 'С. Македонија', 'Кафетин');
|
|---|
| 74 | INSERT INTO synergymed.brandedmedicine VALUES (2, 2, 120.00, 'НСАИЛ за болка и температура (ибупрофен).', 'обложена таблета', '200 mg или 400 mg', 'С. Македонија', 'Ибупрофен Актив');
|
|---|
| 75 | INSERT INTO synergymed.brandedmedicine VALUES (3, 2, 360.00, 'Макролиден антибиотик (азитромицин).', 'филм-обложена таблета', '500 mg', 'С. Македонија', 'Азимед');
|
|---|
| 76 | INSERT INTO synergymed.brandedmedicine VALUES (4, 2, 250.00, 'Орофарингеален спреј со бензидамин.', 'орален спреј', '1.5 mg/ml', 'С. Македонија', 'Оралсепт');
|
|---|
| 77 |
|
|---|
| 78 |
|
|---|
| 79 | INSERT INTO synergymed.branded_medicine_instanceof_medicine VALUES (1, 1);
|
|---|
| 80 | INSERT INTO synergymed.branded_medicine_instanceof_medicine VALUES (1, 2);
|
|---|
| 81 | INSERT INTO synergymed.branded_medicine_instanceof_medicine VALUES (1, 3);
|
|---|
| 82 | INSERT INTO synergymed.branded_medicine_instanceof_medicine VALUES (1, 4);
|
|---|
| 83 | INSERT INTO synergymed.branded_medicine_instanceof_medicine VALUES (2, 5);
|
|---|
| 84 | INSERT INTO synergymed.branded_medicine_instanceof_medicine VALUES (3, 6);
|
|---|
| 85 | INSERT INTO synergymed.branded_medicine_instanceof_medicine VALUES (4, 7);
|
|---|
| 86 |
|
|---|
| 87 |
|
|---|
| 88 | INSERT INTO synergymed.brandedmedicineimage VALUES (55, 1, '/uploads/images/branded_medicine/branded_medicine_1_1756942843570_001.png', true);
|
|---|
| 89 | INSERT INTO synergymed.brandedmedicineimage VALUES (56, 1, '/uploads/images/branded_medicine/branded_medicine_1_1756942843570_002.jpg', false);
|
|---|
| 90 | INSERT INTO synergymed.brandedmedicineimage VALUES (57, 2, '/uploads/images/branded_medicine/branded_medicine_2_1756942853345_001.png', true);
|
|---|
| 91 | INSERT INTO synergymed.brandedmedicineimage VALUES (58, 2, '/uploads/images/branded_medicine/branded_medicine_2_1756942853345_002.png', false);
|
|---|
| 92 | INSERT INTO synergymed.brandedmedicineimage VALUES (59, 3, '/uploads/images/branded_medicine/branded_medicine_3_1756942888851_001.jpg', true);
|
|---|
| 93 | INSERT INTO synergymed.brandedmedicineimage VALUES (60, 3, '/uploads/images/branded_medicine/branded_medicine_3_1756942888851_002.jpg', false);
|
|---|
| 94 | INSERT INTO synergymed.brandedmedicineimage VALUES (61, 4, '/uploads/images/branded_medicine/branded_medicine_4_1756942908650_001.jpg', false);
|
|---|
| 95 | INSERT INTO synergymed.brandedmedicineimage VALUES (62, 4, '/uploads/images/branded_medicine/branded_medicine_4_1756942908650_002.jpg', true);
|
|---|
| 96 | INSERT INTO synergymed.brandedmedicineimage VALUES (63, 1, '/uploads/images/branded_medicine/branded_medicine_1_1756985870285_001.png', false);
|
|---|
| 97 | INSERT INTO synergymed.brandedmedicineimage VALUES (64, 1, '/uploads/images/branded_medicine/branded_medicine_1_1756985870285_002.png', false);
|
|---|
| 98 |
|
|---|
| 99 |
|
|---|
| 100 | INSERT INTO synergymed.deliverycompany VALUES (4);
|
|---|
| 101 |
|
|---|
| 102 |
|
|---|
| 103 | INSERT INTO synergymed.paymentmethod VALUES (1, 'готовина');
|
|---|
| 104 | INSERT INTO synergymed.paymentmethod VALUES (2, 'картичка');
|
|---|
| 105 |
|
|---|
| 106 |
|
|---|
| 107 | INSERT INTO synergymed.payment VALUES (1, 1, 2, '2025-02-02', 420, 'завршено');
|
|---|
| 108 | INSERT INTO synergymed.payment VALUES (2, 2, 1, '2025-03-15', 250, 'завршено');
|
|---|
| 109 | INSERT INTO synergymed.payment VALUES (3, 4, 1, '2025-05-09', 360, 'неуспешно');
|
|---|
| 110 | INSERT INTO synergymed.payment VALUES (10, 1, 2, '2025-09-01', 960, 'завршено');
|
|---|
| 111 | INSERT INTO synergymed.payment VALUES (11, 1, 2, '2025-09-01', 180, 'завршено');
|
|---|
| 112 | INSERT INTO synergymed.payment VALUES (12, 1, 2, '2025-09-01', 240, 'завршено');
|
|---|
| 113 | INSERT INTO synergymed.payment VALUES (13, 1, 2, '2025-09-01', 180, 'завршено');
|
|---|
| 114 | INSERT INTO synergymed.payment VALUES (14, 1, 2, '2025-09-03', 1030, 'завршено');
|
|---|
| 115 | INSERT INTO synergymed.payment VALUES (15, 1, 2, '2025-09-03', 1090, 'завршено');
|
|---|
| 116 | INSERT INTO synergymed.payment VALUES (16, 1, 2, '2025-09-03', 4176, 'завршено');
|
|---|
| 117 | INSERT INTO synergymed.payment VALUES (17, 1, 1, '2025-09-03', 162, 'завршено');
|
|---|
| 118 | INSERT INTO synergymed.payment VALUES (18, 1, 2, '2025-09-03', 1612, 'завршено');
|
|---|
| 119 | INSERT INTO synergymed.payment VALUES (21, 1, 2, '2025-09-03', 100, 'завршено');
|
|---|
| 120 | INSERT INTO synergymed.payment VALUES (22, 1, 2, '2025-09-03', 2440, 'завршено');
|
|---|
| 121 | INSERT INTO synergymed.payment VALUES (25, 1, 2, '2025-09-04', 0, 'завршено');
|
|---|
| 122 | INSERT INTO synergymed.payment VALUES (26, 1, 2, '2025-09-04', 300, 'завршено');
|
|---|
| 123 | INSERT INTO synergymed.payment VALUES (27, 1, 2, '2025-09-04', 430, 'завршено');
|
|---|
| 124 | INSERT INTO synergymed.payment VALUES (28, 1, 2, '2025-09-04', 444, 'завршено');
|
|---|
| 125 | INSERT INTO synergymed.payment VALUES (29, 1, 2, '2025-09-13', 398, 'завршено');
|
|---|
| 126 |
|
|---|
| 127 |
|
|---|
| 128 | INSERT INTO synergymed.clientorder VALUES (1, 1, 4, 1, '2025-02-01', '2025-02-03', 'испорачана', 420);
|
|---|
| 129 | INSERT INTO synergymed.clientorder VALUES (2, 2, 4, 2, '2025-03-14', '2025-03-16', 'испорачана', 250);
|
|---|
| 130 | INSERT INTO synergymed.clientorder VALUES (3, 4, 4, 3, '2025-05-08', '2025-05-10', 'во тек', 360);
|
|---|
| 131 | INSERT INTO synergymed.clientorder VALUES (10, 1, 4, 10, '2025-09-01', '2025-09-08', 'во тек', 960);
|
|---|
| 132 | INSERT INTO synergymed.clientorder VALUES (11, 1, 4, 11, '2025-09-01', '2025-09-08', 'во тек', 180);
|
|---|
| 133 | INSERT INTO synergymed.clientorder VALUES (12, 1, 4, 12, '2025-09-01', '2025-09-08', 'во тек', 240);
|
|---|
| 134 | INSERT INTO synergymed.clientorder VALUES (13, 1, 4, 13, '2025-09-01', '2025-09-08', 'во тек', 180);
|
|---|
| 135 | INSERT INTO synergymed.clientorder VALUES (14, 1, 4, 14, '2025-09-03', '2025-09-10', 'во тек', 1030);
|
|---|
| 136 | INSERT INTO synergymed.clientorder VALUES (15, 1, 4, 15, '2025-09-03', '2025-09-10', 'во тек', 1090);
|
|---|
| 137 | INSERT INTO synergymed.clientorder VALUES (16, 1, 4, 16, '2025-09-03', '2025-09-10', 'во тек', 4176);
|
|---|
| 138 | INSERT INTO synergymed.clientorder VALUES (17, 1, 4, 17, '2025-09-03', '2025-09-10', 'во тек', 162);
|
|---|
| 139 | INSERT INTO synergymed.clientorder VALUES (18, 1, 4, 18, '2025-09-03', '2025-09-10', 'во тек', 1612);
|
|---|
| 140 | INSERT INTO synergymed.clientorder VALUES (21, 1, 4, 21, '2025-09-03', '2025-09-10', 'во тек', 100);
|
|---|
| 141 | INSERT INTO synergymed.clientorder VALUES (22, 1, 4, 22, '2025-09-03', '2025-09-10', 'во тек', 2440);
|
|---|
| 142 | INSERT INTO synergymed.clientorder VALUES (25, 1, 4, 25, '2025-09-04', '2025-09-11', 'во тек', 0);
|
|---|
| 143 | INSERT INTO synergymed.clientorder VALUES (26, 1, 4, 26, '2025-09-04', '2025-09-11', 'во тек', 300);
|
|---|
| 144 | INSERT INTO synergymed.clientorder VALUES (27, 1, 4, 27, '2025-09-04', '2025-09-11', 'во тек', 430);
|
|---|
| 145 | INSERT INTO synergymed.clientorder VALUES (28, 1, 4, 28, '2025-09-04', '2025-09-11', 'во тек', 444);
|
|---|
| 146 | INSERT INTO synergymed.clientorder VALUES (29, 1, 4, 29, '2025-09-13', '2025-09-20', 'во тек', 398);
|
|---|
| 147 |
|
|---|
| 148 |
|
|---|
| 149 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (1, 1, 2);
|
|---|
| 150 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (1, 2, 1);
|
|---|
| 151 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (2, 4, 1);
|
|---|
| 152 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (3, 3, 1);
|
|---|
| 153 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (10, 3, 1);
|
|---|
| 154 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (10, 2, 2);
|
|---|
| 155 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (10, 1, 2);
|
|---|
| 156 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (11, 1, 1);
|
|---|
| 157 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (12, 1, 1);
|
|---|
| 158 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (12, 2, 1);
|
|---|
| 159 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (13, 2, 2);
|
|---|
| 160 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (14, 3, 3);
|
|---|
| 161 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (15, 2, 1);
|
|---|
| 162 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (15, 4, 1);
|
|---|
| 163 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (15, 3, 1);
|
|---|
| 164 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (15, 1, 2);
|
|---|
| 165 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (16, 4, 3);
|
|---|
| 166 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (16, 2, 5);
|
|---|
| 167 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (16, 3, 6);
|
|---|
| 168 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (16, 1, 4);
|
|---|
| 169 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (17, 2, 1);
|
|---|
| 170 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (17, 4, 1);
|
|---|
| 171 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (18, 2, 6);
|
|---|
| 172 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (18, 1, 5);
|
|---|
| 173 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (21, 1, 1);
|
|---|
| 174 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (22, 3, 4);
|
|---|
| 175 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (22, 4, 4);
|
|---|
| 176 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (25, 2, 1);
|
|---|
| 177 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (26, 2, 1);
|
|---|
| 178 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (26, 1, 1);
|
|---|
| 179 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (27, 4, 1);
|
|---|
| 180 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (27, 1, 1);
|
|---|
| 181 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (28, 2, 1);
|
|---|
| 182 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (28, 1, 2);
|
|---|
| 183 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (29, 2, 2);
|
|---|
| 184 | INSERT INTO synergymed.clientorder_brandedmedicine VALUES (29, 1, 1);
|
|---|
| 185 |
|
|---|
| 186 |
|
|---|
| 187 | INSERT INTO synergymed.clubcard VALUES (1, 1, 'Зегин Basic', 39);
|
|---|
| 188 | INSERT INTO synergymed.clubcard VALUES (2, 2, 'Зегин Beonze', 90);
|
|---|
| 189 | INSERT INTO synergymed.clubcard VALUES (3, 4, 'Зегин Silver', 45);
|
|---|
| 190 |
|
|---|
| 191 |
|
|---|
| 192 | INSERT INTO synergymed.facility VALUES (1, 3, 'Зегин Буњаковец', 'ZEG-BUNJAKOVEC');
|
|---|
| 193 | INSERT INTO synergymed.facility VALUES (2, 3, 'Зегин Аеродром', 'ZEG-AERODROM');
|
|---|
| 194 | INSERT INTO synergymed.facility VALUES (3, 3, 'Зегин Чаир', 'ZEG-CHAIR');
|
|---|
| 195 | INSERT INTO synergymed.facility VALUES (4, 1, 'Алкалоид Производствен Комплекс', 'ALK-PROD-1');
|
|---|
| 196 | INSERT INTO synergymed.facility VALUES (5, 1, 'Алкалоид Централен Магацин', 'ALK-WH-1');
|
|---|
| 197 | INSERT INTO synergymed.facility VALUES (6, 2, 'Реплек Производство Козле', 'REP-KOZLE');
|
|---|
| 198 | INSERT INTO synergymed.facility VALUES (7, 2, 'Реплек Дистрибуција', 'REP-DIST-1');
|
|---|
| 199 | INSERT INTO synergymed.facility VALUES (8, 4, 'ЕЛС Логистички Центар', 'ELS-LOG-1');
|
|---|
| 200 |
|
|---|
| 201 |
|
|---|
| 202 | INSERT INTO synergymed.contactinformation VALUES (1, '02/3115-330', 'ул. „Аминта Трети" бр. 22, Центар, 1000 Скопје', NULL, 1);
|
|---|
| 203 | INSERT INTO synergymed.contactinformation VALUES (2, '02/2458-650', 'бул. „Србија" бр. 12, Аеродром, 1000 Скопје', NULL, 2);
|
|---|
| 204 | INSERT INTO synergymed.contactinformation VALUES (3, '02/2620-777', 'бул. „Џон Кенеди" бр. 25, Чаир, 1000 Скопје', NULL, 3);
|
|---|
| 205 | INSERT INTO synergymed.contactinformation VALUES (4, '02/3104-000', 'бул. „Александар Македонски" бр. 12, 1000 Скопје', NULL, 4);
|
|---|
| 206 | INSERT INTO synergymed.contactinformation VALUES (5, '02/3104-014', 'ул. „16-та Македонска Бригада" бр. 18, 1000 Скопје', NULL, 5);
|
|---|
| 207 | INSERT INTO synergymed.contactinformation VALUES (6, '02/3099-200', 'ул. „Козле" бр. 188, Карпош, 1000 Скопје', NULL, 6);
|
|---|
| 208 | INSERT INTO synergymed.contactinformation VALUES (7, '02/3099-250', 'ул. „Илинденска" бр. 2А, Карпош, 1000 Скопје', NULL, 7);
|
|---|
| 209 | INSERT INTO synergymed.contactinformation VALUES (8, '13 990', 'ул. „Киро Глигоров" бр. 1, 1000 Скопје', NULL, 8);
|
|---|
| 210 | INSERT INTO synergymed.contactinformation VALUES (10, '071/335-778', 'бул. „Св. Климент Охридски" бр. 54, Центар, 1000 Скопје', 2, NULL);
|
|---|
| 211 | INSERT INTO synergymed.contactinformation VALUES (11, '072/990-224', 'ул. „Македонија" бр. 12, Центар, 1000 Скопје', 3, NULL);
|
|---|
| 212 | INSERT INTO synergymed.contactinformation VALUES (12, '075/640-113', 'бул. „Јане Сандански" бр. 98, Аеродром, 1000 Скопје', 4, NULL);
|
|---|
| 213 | INSERT INTO synergymed.contactinformation VALUES (13, '076/521-740', 'ул. „Методија Шаторов-Шарло" бр. 14, Кисела Вода, 1000 Скопје', 5, NULL);
|
|---|
| 214 | INSERT INTO synergymed.contactinformation VALUES (14, '077/884-209', 'бул. „Партизански Одреди" бр. 73, Карпош, 1000 Скопје', 6, NULL);
|
|---|
| 215 | INSERT INTO synergymed.contactinformation VALUES (17, '+389 078 236 371', 'ул. „Орце Николов" бр. 45, Центар, 1000 Куманово', 1, NULL);
|
|---|
| 216 | INSERT INTO synergymed.contactinformation VALUES (26, '+38978326371', 'ул. „Орце Николов" бр. 45, Центар, 1000 Куманово', 7, NULL);
|
|---|
| 217 |
|
|---|
| 218 |
|
|---|
| 219 | INSERT INTO synergymed.distributor VALUES (1);
|
|---|
| 220 | INSERT INTO synergymed.distributor VALUES (2);
|
|---|
| 221 |
|
|---|
| 222 |
|
|---|
| 223 | INSERT INTO synergymed.distributor_brandedmedicine VALUES (1, 1);
|
|---|
| 224 | INSERT INTO synergymed.distributor_brandedmedicine VALUES (2, 2);
|
|---|
| 225 | INSERT INTO synergymed.distributor_brandedmedicine VALUES (2, 3);
|
|---|
| 226 | INSERT INTO synergymed.distributor_brandedmedicine VALUES (2, 4);
|
|---|
| 227 |
|
|---|
| 228 |
|
|---|
| 229 | INSERT INTO synergymed.inventory VALUES (1, 1);
|
|---|
| 230 | INSERT INTO synergymed.inventory VALUES (2, 2);
|
|---|
| 231 | INSERT INTO synergymed.inventory VALUES (3, 3);
|
|---|
| 232 | INSERT INTO synergymed.inventory VALUES (4, 4);
|
|---|
| 233 | INSERT INTO synergymed.inventory VALUES (5, 5);
|
|---|
| 234 | INSERT INTO synergymed.inventory VALUES (6, 6);
|
|---|
| 235 | INSERT INTO synergymed.inventory VALUES (7, 7);
|
|---|
| 236 | INSERT INTO synergymed.inventory VALUES (8, 8);
|
|---|
| 237 |
|
|---|
| 238 |
|
|---|
| 239 | INSERT INTO synergymed.inventory_brandedmedicine VALUES (1, 1, 110, '2025-09-15');
|
|---|
| 240 | INSERT INTO synergymed.inventory_brandedmedicine VALUES (1, 2, 176, '2025-09-15');
|
|---|
| 241 | INSERT INTO synergymed.inventory_brandedmedicine VALUES (1, 3, 25, '2025-09-15');
|
|---|
| 242 | INSERT INTO synergymed.inventory_brandedmedicine VALUES (1, 4, 4, '2025-09-15');
|
|---|
| 243 | INSERT INTO synergymed.inventory_brandedmedicine VALUES (2, 2, 16, '2025-09-15');
|
|---|
| 244 | INSERT INTO synergymed.inventory_brandedmedicine VALUES (2, 3, 63, '2025-09-15');
|
|---|
| 245 | INSERT INTO synergymed.inventory_brandedmedicine VALUES (2, 4, 76, '2025-09-15');
|
|---|
| 246 | INSERT INTO synergymed.inventory_brandedmedicine VALUES (3, 1, 110, '2025-09-15');
|
|---|
| 247 | INSERT INTO synergymed.inventory_brandedmedicine VALUES (3, 2, 150, '2025-09-15');
|
|---|
| 248 | INSERT INTO synergymed.inventory_brandedmedicine VALUES (4, 1, 5000, '2025-09-15');
|
|---|
| 249 | INSERT INTO synergymed.inventory_brandedmedicine VALUES (5, 1, 8000, '2025-09-15');
|
|---|
| 250 | INSERT INTO synergymed.inventory_brandedmedicine VALUES (6, 2, 7000, '2025-09-15');
|
|---|
| 251 | INSERT INTO synergymed.inventory_brandedmedicine VALUES (6, 3, 4000, '2025-09-15');
|
|---|
| 252 | INSERT INTO synergymed.inventory_brandedmedicine VALUES (6, 4, 2500, '2025-09-15');
|
|---|
| 253 | INSERT INTO synergymed.inventory_brandedmedicine VALUES (7, 3, 5000, '2025-09-15');
|
|---|
| 254 | INSERT INTO synergymed.inventory_brandedmedicine VALUES (7, 4, 3000, '2025-09-15');
|
|---|
| 255 | INSERT INTO synergymed.inventory_brandedmedicine VALUES (7, 2, 8999, '2025-09-15');
|
|---|
| 256 | INSERT INTO synergymed.inventory_brandedmedicine VALUES (8, 2, 300, '2025-09-15');
|
|---|
| 257 | INSERT INTO synergymed.inventory_brandedmedicine VALUES (8, 3, 150, '2025-09-15');
|
|---|
| 258 |
|
|---|
| 259 |
|
|---|
| 260 | INSERT INTO synergymed.medicineinteraction VALUES (1, 3, 'фармакодинамичка', 'Кофеинот може да ја потенцира аналгезијата на парацетамол и да ја забрза апсорпцијата; следење за несоница/нервоза.', 'ниска');
|
|---|
| 261 | INSERT INTO synergymed.medicineinteraction VALUES (1, 4, 'фармакодинамичка', 'Комбинацијата ја засилува аналгезијата во споредба со парацетамол самостојно; очекувана е поспаност и запек.', 'ниска');
|
|---|
| 262 | INSERT INTO synergymed.medicineinteraction VALUES (1, 5, 'фармакодинамичка', 'Адитивен аналгетски ефект при акутна болка; почитувајте максимални дози и интервали; минимален PK ефект.', 'ниска');
|
|---|
| 263 | INSERT INTO synergymed.medicineinteraction VALUES (2, 3, 'фармакодинамичка', 'Кофеинот ја зголемува антиноцицептивната ефикасност на пропифеназон без значаен PK ефект.', 'ниска');
|
|---|
| 264 | INSERT INTO synergymed.medicineinteraction VALUES (2, 5, 'фармакодинамичка', 'Комбинирање два НСАИЛ го зголемува ризикот за ГИ несакани ефекти/крварење; избегнувајте хронична ко-употреба.', 'умерена');
|
|---|
| 265 | INSERT INTO synergymed.medicineinteraction VALUES (3, 4, 'фармакодинамичка', 'Потенцијално скромно подобрување на аналгезијата со кофеинот како адјуванс; следете за нервоза и тахикардија.', 'ниска');
|
|---|
| 266 |
|
|---|
| 267 |
|
|---|
| 268 | INSERT INTO synergymed.pharmacist VALUES (7);
|
|---|
| 269 | INSERT INTO synergymed.pharmacist VALUES (8);
|
|---|
| 270 |
|
|---|
| 271 |
|
|---|
| 272 | INSERT INTO synergymed.pharmacy VALUES (3);
|
|---|
| 273 |
|
|---|
| 274 |
|
|---|
| 275 | INSERT INTO synergymed.pharmacy_catalog VALUES (3, 1);
|
|---|
| 276 | INSERT INTO synergymed.pharmacy_catalog VALUES (3, 2);
|
|---|
| 277 | INSERT INTO synergymed.pharmacy_catalog VALUES (3, 3);
|
|---|
| 278 | INSERT INTO synergymed.pharmacy_catalog VALUES (3, 4);
|
|---|
| 279 |
|
|---|
| 280 |
|
|---|
| 281 | INSERT INTO synergymed.prescription VALUES (1, 1, 5, 'Д-р Петар Наумов', '2025-02-01', '2025-05-01', '1403990411230');
|
|---|
| 282 | INSERT INTO synergymed.prescription VALUES (2, 2, 7, 'Д-р Весна Спасова', '2025-03-12', '2025-04-30', '2307992616231');
|
|---|
| 283 | INSERT INTO synergymed.prescription VALUES (3, 4, 6, 'Д-р Александар Глигоров', '2025-05-07', '2025-08-07', '2901950415232');
|
|---|
| 284 |
|
|---|
| 285 |
|
|---|
| 286 | INSERT INTO synergymed.sensitiveclientdata VALUES (1, 1, 7, '1403990411230', '/uploads/images/portraits/portrait_2_77a593bd-e156-415d-9571-c8f4a48183b1.png', 'верифицирано');
|
|---|
| 287 | INSERT INTO synergymed.sensitiveclientdata VALUES (4, 4, 8, '2901950415232', '/uploads/images/portrait/portrait_15_e43ffa39-7d9f-49a1-9869-5c573661234d.png', 'oдбиено');
|
|---|
| 288 | INSERT INTO synergymed.sensitiveclientdata VALUES (6, 6, 8, '0804932616236', '/uploads/images/portrait/portrait_16_9e22ab3b-5ef6-4c56-bdb0-df0e0bc92b02.png', 'верифицирано');
|
|---|
| 289 |
|
|---|
| 290 |
|
|---|
| 291 | INSERT INTO synergymed.shoppingcart VALUES (1, 1);
|
|---|
| 292 | INSERT INTO synergymed.shoppingcart VALUES (2, 2);
|
|---|
| 293 | INSERT INTO synergymed.shoppingcart VALUES (3, 3);
|
|---|
| 294 | INSERT INTO synergymed.shoppingcart VALUES (4, 4);
|
|---|
| 295 | INSERT INTO synergymed.shoppingcart VALUES (5, 5);
|
|---|
| 296 | INSERT INTO synergymed.shoppingcart VALUES (6, 6);
|
|---|
| 297 |
|
|---|
| 298 |
|
|---|
| 299 | INSERT INTO synergymed.shoppingcart_brandedmedicine VALUES (1, 3, 1);
|
|---|
| 300 | INSERT INTO synergymed.shoppingcart_brandedmedicine VALUES (3, 2, 1);
|
|---|
| 301 | INSERT INTO synergymed.shoppingcart_brandedmedicine VALUES (4, 3, 1);
|
|---|
| 302 | INSERT INTO synergymed.shoppingcart_brandedmedicine VALUES (5, 1, 2);
|
|---|
| 303 | INSERT INTO synergymed.shoppingcart_brandedmedicine VALUES (6, 2, 1);
|
|---|
| 304 |
|
|---|
| 305 |
|
|---|
| 306 | INSERT INTO synergymed.supplyorder VALUES (1, 2, 3, '2025-09-03', '2025-09-10', 'во тек', 1);
|
|---|
| 307 | INSERT INTO synergymed.supplyorder VALUES (2, 1, 3, '2025-09-03', '2025-09-10', 'во тек', 3);
|
|---|
| 308 | INSERT INTO synergymed.supplyorder VALUES (3, 2, 3, '2025-09-03', '2025-09-10', 'во тек', 1);
|
|---|
| 309 | INSERT INTO synergymed.supplyorder VALUES (4, 2, 3, '2025-09-04', '2025-09-11', 'во тек', 2);
|
|---|
| 310 | INSERT INTO synergymed.supplyorder VALUES (5, 2, 3, '2025-09-04', '2025-09-11', 'во тек', 2);
|
|---|
| 311 | INSERT INTO synergymed.supplyorder VALUES (6, 2, 3, '2025-09-13', '2025-09-20', 'во тек', 2);
|
|---|
| 312 |
|
|---|
| 313 |
|
|---|
| 314 | INSERT INTO synergymed.supplyorder_brandedmedicine VALUES (1, 2, 5);
|
|---|
| 315 | INSERT INTO synergymed.supplyorder_brandedmedicine VALUES (1, 3, 5);
|
|---|
| 316 | INSERT INTO synergymed.supplyorder_brandedmedicine VALUES (1, 4, 4);
|
|---|
| 317 | INSERT INTO synergymed.supplyorder_brandedmedicine VALUES (2, 1, 50);
|
|---|
| 318 | INSERT INTO synergymed.supplyorder_brandedmedicine VALUES (3, 3, 20);
|
|---|
| 319 | INSERT INTO synergymed.supplyorder_brandedmedicine VALUES (4, 2, 1);
|
|---|
| 320 | INSERT INTO synergymed.supplyorder_brandedmedicine VALUES (5, 2, 5);
|
|---|
| 321 | INSERT INTO synergymed.supplyorder_brandedmedicine VALUES (5, 4, 10);
|
|---|
| 322 | INSERT INTO synergymed.supplyorder_brandedmedicine VALUES (6, 2, 10);
|
|---|
| 323 | INSERT INTO synergymed.supplyorder_brandedmedicine VALUES (6, 4, 30);
|
|---|
