source: sql/dml.sql@ 48d2bed

Last change on this file since 48d2bed was 48d2bed, checked in by MBK <marija.karapandzova@…>, 13 hours ago

Remote database setup, fixed models and application properties
  • Property mode set to 100644
File size: 160.5 KB
Line 
1BEGIN;
2INSERT INTO doctor_level (level_id, level) VALUES
3 (1, 'INTERN'),
4 (2, 'RESIDENT'),
5 (3, 'GENERAL_DOCTOR'),
6 (4, 'SPECIALIST'),
7 (5, 'CONSULTANT');
8
9
10INSERT INTO doctor_specialization (specialization_id, specialization_name) VALUES
11 (1, 'PULMONOLOGY'),
12 (2, 'CARDIOLOGY'),
13 (3, 'NEUROLOGY'),
14 (4, 'ORTHOPEDICS'),
15 (5, 'GYNECOLOGY'),
16 (6, 'ENT'),
17 (7, 'OPHTHALMOLOGY'),
18 (8, 'PATHOLOGY'),
19 (9, 'RADIOLOGY'),
20 (10, 'GASTROENTEROLOGY'),
21 (11, 'UROLOGY'),
22 (12, 'NEPHROLOGY'),
23 (13, 'ONCOLOGY'),
24 (14, 'DERMATOLOGY'),
25 (15, 'PEDIATRICS'),
26 (16, 'PSYCHIATRY'),
27 (17, 'REHABILITATION'),
28 (18, 'HEMATOLOGY'),
29 (19, 'INFECTIOUS_DISEASES'),
30 (20, 'NEUROSURGERY'),
31 (21, 'CARDIAC_SURGERY'),
32 (22, 'PLASTIC_SURGERY'),
33 (23, 'GENERAL_SURGERY'),
34 (24, 'DENTISTRY'),
35 (25, 'ENDOCRINOLOGY');
36
37INSERT INTO departments (department_id, department_name) VALUES
38 (1, 'PULMONOLOGY_DEPT'),
39 (2, 'CARDIOLOGY_DEPT'),
40 (3, 'NEUROLOGY_DEPT'),
41 (4, 'ORTHOPEDICS_DEPT'),
42 (5, 'GYNECOLOGY_DEPT'),
43 (6, 'ENT_DEPT'),
44 (7, 'OPHTHALMOLOGY_DEPT'),
45 (8, 'PATHOLOGY_DEPT'),
46 (9, 'RADIOLOGY_DEPT'),
47 (10, 'GASTROENTEROLOGY_DEPT'),
48 (11, 'UROLOGY_DEPT'),
49 (12, 'NEPHROLOGY_DEPT'),
50 (13, 'ONCOLOGY_DEPT'),
51 (14, 'DERMATOLOGY_DEPT'),
52 (15, 'PEDIATRICS_DEPT'),
53 (16, 'PSYCHIATRY_DEPT'),
54 (17, 'REHABILITATION_DEPT'),
55 (18, 'HEMATOLOGY_DEPT'),
56 (19, 'INFECTIOUS_DISEASES_DEPT'),
57 (20, 'NEUROSURGERY_DEPT'),
58 (21, 'CARDIAC_SURGERY_DEPT'),
59 (22, 'PLASTIC_SURGERY_DEPT'),
60 (23, 'GENERAL_SURGERY_DEPT'),
61 (24, 'DENTISTRY_DEPT');
62
63
64INSERT INTO allergies (allergy_id, name, allergy_severity) VALUES
65 (1, 'PENICILLIN', 'HIGH'),
66 (2, 'AMOXICILLIN', 'HIGH'),
67 (3, 'ASPIRIN', 'MEDIUM'),
68 (4, 'IBUPROFEN', 'MEDIUM'),
69 (5, 'PARACETAMOL', 'LOW'),
70 (6, 'CODEINE', 'HIGH'),
71 (7, 'MORPHINE', 'CRITICAL'),
72 (8, 'SULFA_DRUGS', 'HIGH'),
73 (9, 'CEPHALOSPORINS', 'HIGH'),
74 (10, 'ANESTHESIA', 'CRITICAL'),
75 (11, 'LIDOCAINE', 'HIGH'),
76 (12, 'CONTRAST_DYE', 'HIGH'),
77 (13, 'PEANUTS', 'CRITICAL'),
78 (14, 'TREE_NUTS', 'CRITICAL'),
79 (15, 'ALMONDS', 'HIGH'),
80 (16, 'WALNUTS', 'HIGH'),
81 (17, 'HAZELNUTS', 'HIGH'),
82 (18, 'CASHEWS', 'HIGH'),
83 (19, 'PISTACHIOS', 'HIGH'),
84 (20, 'SESAME', 'HIGH'),
85 (21, 'MILK', 'MEDIUM'),
86 (22, 'EGGS', 'MEDIUM'),
87 (23, 'WHEAT', 'MEDIUM'),
88 (24, 'GLUTEN', 'MEDIUM'),
89 (25, 'SOY', 'MEDIUM'),
90 (26, 'FISH', 'HIGH'),
91 (27, 'SHELLFISH', 'HIGH'),
92 (28, 'SHRIMP', 'HIGH'),
93 (29, 'CRAB', 'HIGH'),
94 (30, 'LOBSTER', 'HIGH'),
95 (31, 'STRAWBERRIES', 'LOW'),
96 (32, 'KIWI', 'LOW'),
97 (33, 'BANANA', 'LOW'),
98 (34, 'APPLE', 'LOW'),
99 (35, 'CHOCOLATE', 'LOW'),
100 (36, 'CAFFEINE', 'LOW'),
101 (37, 'POLLEN', 'LOW'),
102 (38, 'GRASS_POLLEN', 'LOW'),
103 (39, 'TREE_POLLEN', 'LOW'),
104 (40, 'RAGWEED', 'LOW'),
105 (41, 'DUST_MITES', 'LOW'),
106 (42, 'MOLD', 'MEDIUM'),
107 (43, 'MILDEW', 'MEDIUM'),
108 (44, 'PET_DANDER_CAT', 'MEDIUM'),
109 (45, 'PET_DANDER_DOG', 'MEDIUM'),
110 (46, 'FEATHERS', 'LOW'),
111 (47, 'BEE_VENOM', 'HIGH'),
112 (48, 'WASP_VENOM', 'HIGH'),
113 (49, 'HORNET_VENOM', 'HIGH'),
114 (50, 'FIRE_ANT_STINGS', 'HIGH'),
115 (51, 'LATEX', 'HIGH'),
116 (52, 'NICKEL', 'MEDIUM'),
117 (53, 'COBALT', 'MEDIUM'),
118 (54, 'CHROMIUM', 'MEDIUM'),
119 (55, 'FORMALDEHYDE', 'HIGH'),
120 (56, 'FRAGRANCES', 'MEDIUM'),
121 (57, 'PERFUMES', 'MEDIUM'),
122 (58, 'DETERGENTS', 'MEDIUM'),
123 (59, 'CLEANING_CHEMICALS', 'HIGH'),
124 (60, 'HAIR_DYE', 'MEDIUM'),
125 (61, 'IODINE', 'MEDIUM'),
126 (62, 'MRI_CONTRAST', 'HIGH'),
127 (63, 'CT_CONTRAST', 'HIGH'),
128 (64, 'PLASTER_CAST_MATERIAL', 'LOW'),
129 (65, 'OXYCODONE', 'HIGH'),
130 (66, 'TRAMADOL', 'HIGH'),
131 (67, 'DICLOFENAC', 'MEDIUM'),
132 (68, 'NAPROXEN', 'MEDIUM'),
133 (69, 'AZITHROMYCIN', 'MEDIUM'),
134 (70, 'CLARITHROMYCIN', 'MEDIUM'),
135 (71, 'METRONIDAZOLE', 'MEDIUM'),
136 (72, 'INSULIN', 'HIGH'),
137 (73, 'TOMATOES', 'LOW'),
138 (74, 'POTATOES', 'LOW'),
139 (75, 'CORN', 'LOW'),
140 (76, 'CARROTS', 'LOW'),
141 (77, 'CELERY', 'MEDIUM'),
142 (78, 'ONION', 'LOW'),
143 (79, 'GARLIC', 'LOW'),
144 (80, 'MUSTARD', 'MEDIUM'),
145 (81, 'PEACHES', 'LOW'),
146 (82, 'PEARS', 'LOW'),
147 (83, 'PLUMS', 'LOW'),
148 (84, 'GRAPES', 'LOW'),
149 (85, 'MELON', 'LOW'),
150 (86, 'SMOKE', 'MEDIUM'),
151 (87, 'CIGARETTE_SMOKE', 'MEDIUM'),
152 (88, 'AIRBORNE_CHEMICALS', 'HIGH'),
153 (89, 'POLLUTED_AIR', 'MEDIUM'),
154 (90, 'CAT_DANDER', 'MEDIUM'),
155 (91, 'DOG_DANDER', 'MEDIUM'),
156 (92, 'HORSE_DANDER', 'LOW'),
157 (93, 'PREDNISONE', 'HIGH'),
158 (94, 'HYDROCORTISONE', 'MEDIUM'),
159 (95, 'VACCINE_COMPONENTS', 'HIGH'),
160 (96, 'GLYCERIN', 'LOW'),
161 (97, 'LANOLIN', 'MEDIUM'),
162 (98, 'ALCOHOL_BASED_PRODUCTS', 'MEDIUM'),
163 (99, 'SOAP', 'LOW'),
164 (100, 'SHAMPOO', 'LOW'),
165 (101, 'LATEX_GLOVES', 'HIGH'),
166 (102, 'SURGICAL_ADHESIVES', 'HIGH'),
167 (103, 'DENTAL_MATERIALS', 'MEDIUM'),
168 (104, 'METAL_IMPLANTS', 'HIGH'),
169 (105, 'TITANIUM', 'MEDIUM'),
170 (106, 'STAINLESS_STEEL', 'MEDIUM'),
171 (107, 'PENICILLIN_DERIVATIVES', 'HIGH'),
172 (108, 'VANCOMYCIN', 'HIGH'),
173 (109, 'HEPARIN', 'HIGH'),
174 (110, 'BLOOD_PRODUCTS', 'HIGH'),
175 (111, 'LATEX_BALLOONS', 'HIGH'),
176 (112, 'HOUSE_DUST', 'LOW'),
177 (113, 'WOOD_DUST', 'MEDIUM'),
178 (114, 'PAPER_DUST', 'LOW'),
179 (115, 'TEXTILE_DYES', 'MEDIUM'),
180 (116, 'INKS', 'LOW'),
181 (117, 'GLUE', 'MEDIUM'),
182 (118, 'PAINT_FUMES', 'HIGH'),
183 (119, 'SOLVENTS', 'HIGH'),
184 (120, 'RUBBER', 'HIGH'),
185 (121, 'AMPICILLIN', 'HIGH'),
186 (122, 'PIPERACILLIN', 'HIGH'),
187 (123, 'CEFTRIAXONE', 'HIGH'),
188 (124, 'CEFEPIME', 'HIGH'),
189 (125, 'MEROPENEM', 'CRITICAL'),
190 (126, 'IMIPENEM', 'CRITICAL'),
191 (127, 'ACETAMINOPHEN', 'LOW'),
192 (128, 'DIPHENHYDRAMINE', 'MEDIUM'),
193 (129, 'LORATADINE', 'LOW'),
194 (130, 'CETIRIZINE', 'LOW'),
195 (131, 'IBUPROFEN_HIGH_DOSE', 'MEDIUM'),
196 (132, 'KETOROLAC', 'HIGH'),
197 (133, 'MELOXICAM', 'MEDIUM'),
198 (134, 'CELECOXIB', 'MEDIUM'),
199 (135, 'FENTANYL', 'CRITICAL'),
200 (136, 'METHADONE', 'CRITICAL'),
201 (137, 'BUPRENORPHINE', 'HIGH'),
202 (138, 'PROPOFOL', 'CRITICAL'),
203 (139, 'SEVOFLURANE', 'HIGH'),
204 (140, 'ISOFLURANE', 'HIGH'),
205 (141, 'METFORMIN', 'MEDIUM'),
206 (142, 'INSULIN_ANALOGS', 'HIGH'),
207 (143, 'ATENOLOL', 'MEDIUM'),
208 (144, 'METOPROLOL', 'MEDIUM'),
209 (145, 'LISINOPRIL', 'HIGH'),
210 (146, 'ENALAPRIL', 'HIGH'),
211 (147, 'WARFARIN', 'HIGH'),
212 (148, 'HEPARIN_SODIUM', 'HIGH'),
213 (149, 'SERTRALINE', 'MEDIUM'),
214 (150, 'FLUOXETINE', 'MEDIUM'),
215 (151, 'CITALOPRAM', 'MEDIUM'),
216 (152, 'CISPLATIN', 'CRITICAL'),
217 (153, 'DOXORUBICIN', 'CRITICAL'),
218 (154, 'CYCLOPHOSPHAMIDE', 'CRITICAL'),
219 (155, 'PREDNISOLONE', 'HIGH'),
220 (156, 'DEXAMETHASONE', 'HIGH'),
221 (157, 'ALBUTEROL', 'MEDIUM'),
222 (158, 'SALBUTAMOL', 'MEDIUM'),
223 (159, 'LEVOFLOXACIN', 'HIGH');
224
225INSERT INTO symptoms (symptom_id, name, description) VALUES
226 (1, 'ACID_REFLUX_IN_BABIES', 'Reflux in infants'),
227 (2, 'ACID_REFLUX', 'Stomach acid rising into esophagus'),
228 (3, 'AMNESIA', 'Memory loss'),
229 (4, 'ANAL_PAIN', 'Pain in anal region'),
230 (5, 'ANGER', 'Emotional irritation or rage'),
231 (6, 'ANKLE_PAIN', 'Pain in ankle'),
232 (7, 'SWOLLEN_ANKLES_FEET_LEGS', 'Swelling in lower limbs'),
233 (8, 'ANOSMIA', 'Loss of smell'),
234 (9, 'ITCHY_BOTTOM', 'Itching around anus'),
235 (10, 'ANXIETY', 'Fear and panic symptoms'),
236 (11, 'ARM_PAIN', 'Pain in arm'),
237 (12, 'BACK_PAIN', 'Pain in back'),
238 (13, 'BAD_BREATH', 'Unpleasant mouth odor'),
239 (14, 'BEDWETTING', 'Night-time urination'),
240 (15, 'VOMITING', 'Expulsion of stomach contents'),
241 (16, 'POSTMENOPAUSAL_BLEEDING', 'Bleeding after menopause'),
242 (17, 'BLEEDING_BETWEEN_PERIODS', 'Bleeding between periods'),
243 (18, 'RECTAL_BLEEDING', 'Bleeding from rectum'),
244 (19, 'BLEEDING_IN_PREGNANCY', 'Bleeding during pregnancy'),
245 (20, 'BLOATING', 'Abdominal swelling'),
246 (21, 'BLOOD_IN_PHLEGM', 'Blood in mucus'),
247 (22, 'BLOOD_IN_SEMEN', 'Blood in semen'),
248 (23, 'BLOOD_IN_URINE', 'Blood in urine'),
249 (24, 'CYANOSIS', 'Blue skin or lips'),
250 (25, 'BLUSHING', 'Facial redness'),
251 (26, 'BODY_ODOR', 'Strong smell'),
252 (27, 'BOWEL_INCONTINENCE', 'Loss of bowel control'),
253 (28, 'BREAST_LUMPS', 'Mass in breast'),
254 (29, 'BREAST_PAIN', 'Pain in breast'),
255 (30, 'EXOPHTHALMOS', 'Bulging eyes'),
256 (31, 'CATARRH', 'Excess mucus'),
257 (32, 'CHEST_PAIN', 'Chest pain'),
258 (33, 'COCCYX_PAIN', 'Tailbone pain'),
259 (34, 'CONFUSION', 'Sudden confusion'),
260 (35, 'CONSTIPATION', 'Hard stools'),
261 (36, 'COUGH', 'Cough reflex'),
262 (37, 'COUGHING_BLOOD', 'Blood in cough'),
263 (38, 'DEAFNESS', 'Hearing loss'),
264 (39, 'DEHYDRATION', 'Fluid loss'),
265 (40, 'DELIRIUM', 'Acute confusion'),
266 (41, 'DENTAL_PAIN', 'Tooth pain'),
267 (42, 'DIARRHEA_VOMITING', 'Digestive upset'),
268 (43, 'DIZZINESS', 'Balance disturbance'),
269 (44, 'DOUBLE_VISION', 'Seeing double'),
270 (45, 'DRY_EYES', 'Eye dryness'),
271 (46, 'DRY_LIPS', 'Dry lips'),
272 (47, 'DRY_MOUTH', 'Lack of saliva'),
273 (48, 'DYSPHAGIA', 'Swallowing difficulty'),
274 (49, 'EARACHE', 'Pain in ear'),
275 (50, 'EJACULATION_PROBLEMS', 'Problems with ejaculation'),
276 (51, 'ELBOW_AND_ARM_PAIN', 'Pain in elbow or arm'),
277 (52, 'EXCESSIVE_DAYTIME_SLEEPINESS', 'Abnormal daytime sleepiness'),
278 (53, 'EXCESSIVE_HAIR_GROWTH', 'Increased hair growth'),
279 (54, 'EXCESSIVE_SWEATING', 'High sweating levels'),
280 (55, 'EXCESSIVE_THIRST', 'Increased thirst'),
281 (56, 'FLOATERS_AND_FLASHES', 'Visual disturbances in vision'),
282 (57, 'EYE_PAIN', 'Pain in eye'),
283 (58, 'EYELID_PROBLEMS', 'Problems affecting eyelids'),
284 (59, 'FAINTING', 'Temporary loss of consciousness'),
285 (60, 'FLATULENCE', 'Gas in digestive system'),
286 (61, 'NAUSEA', 'Feeling of sickness'),
287 (62, 'FEVER', 'High body temperature'),
288 (63, 'FINGER_PAIN', 'Pain in fingers'),
289 (64, 'SEIZURES', 'Sudden uncontrolled brain activity'),
290 (65, 'FOOT_PAIN', 'Pain in foot'),
291 (66, 'HAIR_LOSS', 'Hair shedding'),
292 (67, 'HALLUCINATIONS_AND_HEARING_VOICES', 'Perception without stimulus'),
293 (68, 'HAND_PAIN', 'Pain in hand'),
294 (69, 'HEADACHE', 'Pain in head'),
295 (70, 'HEARING_LOSS', 'Reduced hearing ability'),
296 (71, 'HEART_PALPITATIONS', 'Irregular heartbeat sensation'),
297 (72, 'HEARTBURN_AND_ACID_REFLUX', 'Burning chest sensation'),
298 (73, 'HEAVY_PERIODS', 'Excess menstrual bleeding'),
299 (74, 'HEEL_PAIN', 'Pain in heel'),
300 (75, 'HICCUPS', 'Involuntary diaphragm spasms'),
301 (76, 'HIP_PAIN', 'Pain in hip'),
302 (77, 'HIVES', 'Skin rash with itching'),
303 (78, 'INDIGESTION', 'Difficulty digesting food'),
304 (79, 'INSOMNIA', 'Difficulty sleeping'),
305 (80, 'ITCHY_SKIN', 'Skin itching'),
306 (81, 'JOINT_PAIN', 'Pain in joints'),
307 (82, 'KNEE_PAIN', 'Pain in knee'),
308 (83, 'LEG_CRAMPS', 'Muscle cramps in legs'),
309 (84, 'LIMPING', 'Difficulty walking normally'),
310 (85, 'LOW_MOOD', 'Depressive mood state'),
311 (86, 'LUMPS', 'Abnormal tissue swelling'),
312 (87, 'MEMORY_LOSS', 'Difficulty remembering information'),
313 (88, 'METALLIC_TASTE', 'Unusual taste in mouth'),
314 (89, 'MISSED_PERIODS', 'Absent menstrual cycle'),
315 (90, 'NAIL_PROBLEMS', 'Abnormal nails'),
316 (91, 'NECK_PAIN', 'Pain in neck'),
317 (92, 'NIGHT_SWEATS', 'Sweating during sleep'),
318 (93, 'NIPPLE_DISCHARGE', 'Fluid from nipple'),
319 (94, 'OVULATION_PAIN', 'Pain during ovulation'),
320 (95, 'TESTICLE_PAIN', 'Pain in testicles'),
321 (96, 'PAINFUL_PERIODS', 'Pain during menstruation'),
322 (97, 'PARALYSIS', 'Loss of movement'),
323 (98, 'PELVIC_PAIN', 'Pain in pelvic area'),
324 (99, 'PINS_AND_NEEDLES', 'Tingling sensation'),
325 (100, 'PRIAPISM', 'Persistent painful erection'),
326 (101, 'RASH', 'Skin eruption or irritation'),
327 (102, 'RED_EYE', 'Redness in eye'),
328 (103, 'RUNNY_NOSE', 'Nasal discharge'),
329 (104, 'SHORTNESS_OF_BREATH', 'Difficulty breathing'),
330 (105, 'SORE_THROAT', 'Pain in throat'),
331 (106, 'SNEEZING', 'Reflex to clear nasal passages'),
332 (107, 'SNORING', 'Noisy breathing during sleep'),
333 (108, 'STOMACH_PAIN', 'Pain in abdomen'),
334 (109, 'STRESS', 'Mental strain condition'),
335 (110, 'STRETCH_MARKS', 'Skin streaking'),
336 (111, 'SWELLING', 'Abnormal enlargement of tissue'),
337 (112, 'SWOLLEN_GLANDS', 'Enlarged lymph nodes'),
338 (113, 'TASTE_CHANGE', 'Altered taste perception'),
339 (114, 'TREMOR', 'Uncontrolled shaking'),
340 (115, 'TIREDNESS', 'Fatigue'),
341 (116, 'TINNITUS', 'Ringing in ears'),
342 (117, 'TOOTHACHE', 'Pain in teeth'),
343 (118, 'TWITCHING', 'Muscle spasms'),
344 (119, 'UNINTENTIONAL_WEIGHT_LOSS', 'Weight loss without trying'),
345 (120, 'URINARY_INCONTINENCE', 'Loss of bladder control'),
346 (121, 'VAGINAL_BLEEDING', 'Bleeding from vagina'),
347 (122, 'VISION_LOSS', 'Reduced vision ability'),
348 (123, 'VOMITING_BLOOD', 'Blood in vomit'),
349 (124, 'WATERING_EYES', 'Excess tear production'),
350 (125, 'WHEEZING', 'Whistling breathing sound'),
351 (126, 'WRIST_PAIN', 'Pain in wrist');
352
353INSERT INTO users (user_id, username, password, role, first_name, last_name, is_active) VALUES
354 (1, 'admin', '$2b$12$VPUSCKLqfMU1ojKg4TncaOmqRZ.vCaguidmfvdAN3QM.qNRkkm/Ka', 'ADMIN', 'System', 'Administrator', true),
355 (2, '1402994123456', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Maja', 'Veljanova', true),
356 (3, '2106991123457', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Kristijan', 'Bojkov', true),
357 (4, '0311000123458', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Tamara', 'Gorgieva', true),
358 (5, '1009988123459', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Aleks', 'Nikolovski', true),
359 (6, '2512997123460', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Sara', 'Milevska', true),
360 (7, '1804993123461', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Stefan', 'Arsovski', true),
361 (8, '0907999123462', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Elena', 'Petreska', true),
362 (9, '3001990123463', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Viktor', 'Stankov', true),
363 (10, '1205995123464', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Ivana', 'Dimitrova', true),
364 (11, '2208987123465', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Marko', 'Lazarevski', true),
365 (12, '1703001123466', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Jana', 'Trajkovska', true),
366 (13, '0510992123467', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Petar', 'Kostov', true),
367 (14, '2806996123468', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Ana', 'Ristova', true),
368 (15, '1102989123469', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Nikola', 'Sokolov', true),
369 (16, '1909022123470', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Mila', 'Petrova', true),
370 (17, '1111994123471', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Dejan', 'Ilievski', true),
371 (18, '1401988123472', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Kristina', 'Markovska', true),
372 (19, '0707986123473', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Goran', 'Petrov', true),
373 (20, '0212000123474', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Sofija', 'Nikolova', true),
374 (21, '0303991123475', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Dimitar', 'Angelov', true),
375 (22, '0808997123476', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Teodora', 'Hristova', true),
376 (23, '1505993123477', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Filip', 'Stojanov', true),
377 (24, '1010999123478', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Marija', 'Kirovska', true),
378 (25, '1212988123479', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Ivan', 'Bojkov', true),
379 (26, '0404001123480', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Lina', 'Petrovska', true),
380 (27, '2002992123481', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Bojan', 'Spasov', true),
381 (28, '0909995123482', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Ana', 'Dimovska', true),
382 (29, '1606987123483', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Vladimir', 'Ristovski', true),
383 (30, '0101033123484', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Katerina', 'Todorova', true),
384 (31, '2311990123485', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Martin', 'Iliev', true),
385 (32, '1303996123486', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Elena', 'Trajkov', true),
386 (33, '2707994123487', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Aleksandar', 'Petrovski', true),
387 (34, '1809998123488', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Maja', 'Stojanovska', true),
388 (35, '0505989123489', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Nikola', 'Gligorov', true),
389 (36, '1212022123490', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Sara', 'Ilieva', true),
390 (37, '0303993123491', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Petar', 'Markovski', true),
391 (38, '0707997123492', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Ivana', 'Petrovska', true),
392 (39, '1010986123493', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Goran', 'Nikolovski', true),
393 (40, '2001000123494', '$2b$12$DGgh6fp1e67.0JwWEyvK2uif9xtpYPU2MPHOO1qquedRXsrOS/8sK', 'PATIENT', 'Jana', 'Ristova', true),
394 (41, 'ivan.stojanov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivan', 'Stojanov', true),
395 (42, 'elena.kirova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Elena', 'Kirova', true),
396 (43, 'nikola.trajkov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Nikola', 'Trajkov', true),
397 (44, 'sara.dimova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sara', 'Dimova', true),
398 (45, 'marija.bajramovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Marija', 'Bajramovska', true),
399 (46, 'ana.petrova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ana', 'Petrova', true),
400 (47, 'petar.iliev@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Petar', 'Iliev', true),
401 (48, 'mila.stojanova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Mila', 'Stojanova', true),
402 (49, 'dejan.markovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Dejan', 'Markovski', true),
403 (50, 'kristina.todorova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Kristina', 'Todorova', true),
404 (51, 'goran.spasov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Goran', 'Spasov', true),
405 (52, 'ivana.hristova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivana', 'Hristova', true),
406 (53, 'bojan.nikolovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Bojan', 'Nikolovski', true),
407 (54, 'tea.angelova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Tea', 'Angelova', true),
408 (55, 'filip.jovanov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Filip', 'Jovanov', true),
409 (56, 'natasha.petkovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Natasha', 'Petkovska', true),
410 (57, 'viktor.andreev@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Viktor', 'Andreev', true),
411 (58, 'sofija.marinova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sofija', 'Marinova', true),
412 (59, 'luka.nikolov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Luka', 'Nikolov', true),
413 (60, 'marija.damjanova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Marija', 'Damjanova', true),
414 (61, 'katerina.ilieva@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Katerina', 'Ilieva', true),
415 (62, 'dimitar.petrov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Dimitar', 'Petrov', true),
416 (63, 'jana.kostova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Jana', 'Kostova', true),
417 (64, 'stefan.todorov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Stefan', 'Todorov', true),
418 (65, 'elena.markova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Elena', 'Markova', true),
419 (66, 'aleksandar.ristovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Aleksandar', 'Ristovski', true),
420 (67, 'ivana.trajkovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivana', 'Trajkovska', true),
421 (68, 'goran.nikolov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Goran', 'Nikolov', true),
422 (69, 'mila.stojkova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Mila', 'Stojkova', true),
423 (70, 'bojan.petrov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Bojan', 'Petrov', true),
424 (71, 'petar.angelov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Petar', 'Angelov', true),
425 (72, 'ana.dimovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ana', 'Dimovska', true),
426 (73, 'nikola.kostadinov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Nikola', 'Kostadinov', true),
427 (74, 'sara.petrova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sara', 'Petrova', true),
428 (75, 'marko.stojanovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Marko', 'Stojanovski', true),
429 (76, 'elena.markovic@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Elena', 'Markovic', true),
430 (77, 'ivan.petrovic@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivan', 'Petrovic', true),
431 (78, 'dejan.ilievski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Dejan', 'Ilievski', true),
432 (79, 'kristina.ristova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Kristina', 'Ristova', true),
433 (80, 'filip.sokolov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Filip', 'Sokolov', true),
434 (81, 'goran.spasovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Goran', 'Spasovski', true),
435 (82, 'ivana.hristovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivana', 'Hristovska', true),
436 (83, 'bojan.nikolovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Bojan', 'Nikolovska', true),
437 (84, 'tea.angelkovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Tea', 'Angelkovska', true),
438 (85, 'luka.petrovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Luka', 'Petrovski', true),
439 (86, 'marija.ristova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Marija', 'Ristova', true),
440 (87, 'viktor.stojanovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Viktor', 'Stojanovski', true),
441 (88, 'sofija.markovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sofija', 'Markovska', true),
442 (89, 'dimitar.ilievski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Dimitar', 'Ilievski', true),
443 (90, 'jana.petrovska2@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Jana', 'Petrovska', true),
444 (91, 'stefan.nikolov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Stefan', 'Nikolov', true),
445 (92, 'elena.trajkovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Elena', 'Trajkovska', true),
446 (93, 'nikola.angelov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Nikola', 'Angelov', true),
447 (94, 'sara.dimovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sara', 'Dimovska', true),
448 (95, 'ivan.kostov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivan', 'Kostov', true),
449 (96, 'petar.hristov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Petar', 'Hristov', true),
450 (97, 'ana.petrovska3@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ana', 'Petrovska', true),
451 (98, 'dejan.stojkov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Dejan', 'Stojkov', true),
452 (99, 'kristina.ristovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Kristina', 'Ristovska', true),
453 (100, 'goran.nikolovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Goran', 'Nikolovski', true),
454 (101, 'ivana.markov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivana', 'Markov', true),
455 (102, 'bojan.petrovski1@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Bojan', 'Petrovski', true),
456 (103, 'tea.ilieva@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Tea', 'Ilieva', true),
457 (104, 'filip.spasov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Filip', 'Spasov', true),
458 (105, 'marija.angelova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Marija', 'Angelova', true),
459 (106, 'viktor.kirov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Viktor', 'Kirov', true),
460 (107, 'sofija.petrovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sofija', 'Petrovska', true),
461 (108, 'luka.ristovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Luka', 'Ristovski', true),
462 (109, 'dimitar.markov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Dimitar', 'Markov', true),
463 (110, 'jana.nikolova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Jana', 'Nikolova', true),
464 (111, 'marko.stojanov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Marko', 'Stojanov', true),
465 (112, 'elena.ilievska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Elena', 'Ilievska', true),
466 (113, 'nikola.petrov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Nikola', 'Petrov', true),
467 (114, 'sara.trajkovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sara', 'Trajkovska', true),
468 (115, 'ivan.dimov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivan', 'Dimov', true),
469 (116, 'goran.ristov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Goran', 'Ristov', true),
470 (117, 'ivana.kostadinova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivana', 'Kostadinova', true),
471 (118, 'bojan.petkov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Bojan', 'Petkov', true),
472 (119, 'tea.markovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Tea', 'Markovska', true),
473 (120, 'filip.stojanov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Filip', 'Stojanov', true),
474 (121, 'marija.hristovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Marija', 'Hristovska', true),
475 (122, 'viktor.iliev@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Viktor', 'Iliev', true),
476 (123, 'sofija.petrovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sofija', 'Petrovski', true),
477 (124, 'luka.angelovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Luka', 'Angelovska', true),
478 (125, 'dimitar.kirovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Dimitar', 'Kirovski', true),
479 (126, 'jana.ristova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Jana', 'Ristova', true),
480 (127, 'marko.petrovic@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Marko', 'Petrovic', true),
481 (128, 'elena.stojkovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Elena', 'Stojkovska', true),
482 (129, 'nikola.trajkovic@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Nikola', 'Trajkovic', true),
483 (130, 'sara.dimkovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sara', 'Dimkovska', true),
484 (131, 'ivan.spasov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivan', 'Spasov', true),
485 (132, 'petar.nikolov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Petar', 'Nikolov', true),
486 (133, 'ana.markovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ana', 'Markovska', true),
487 (134, 'dejan.iliev@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Dejan', 'Iliev', true),
488 (135, 'kristina.petrova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Kristina', 'Petrova', true),
489 (136, 'goran.stojanovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Goran', 'Stojanovski', true),
490 (137, 'ivana.hristova1@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivana', 'Hristova', true),
491 (138, 'bojan.kostov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Bojan', 'Kostov', true),
492 (139, 'tea.petrovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Tea', 'Petrovska', true),
493 (140, 'filip.ristovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Filip', 'Ristovski', true),
494 (141, 'marija.angelovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Marija', 'Angelovska', true),
495 (142, 'viktor.markovski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Viktor', 'Markovski', true),
496 (143, 'sofija.petrova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sofija', 'Petrova', true),
497 (144, 'luka.ilievski@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Luka', 'Ilievski', true),
498 (145, 'dimitar.stojanov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Dimitar', 'Stojanov', true),
499 (146, 'jana.kirovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Jana', 'Kirovska', true),
500 (147, 'marko.petkov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Marko', 'Petkov', true),
501 (148, 'elena.ristova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Elena', 'Ristova', true),
502 (149, 'nikola.dimov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Nikola', 'Dimov', true),
503 (150, 'sara.nikolova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Sara', 'Nikolova', true),
504 (151, 'ivan.trajkov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivan', 'Trajkov', true),
505 (152, 'petar.stojkov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Petar', 'Stojkov', true),
506 (153, 'ana.petrovska1@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ana', 'Petrovska', true),
507 (154, 'dejan.markov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Dejan', 'Markov', true),
508 (155, 'kristina.ilieva@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Kristina', 'Ilieva', true),
509 (156, 'filip.kostadinov@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Filip', 'Kostadinov', true),
510 (157, 'ivana.spasova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Ivana', 'Spasova', true),
511 (158, 'bojan.petrovski2@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Bojan', 'Petrovski', true),
512 (159, 'teodora.angelova@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Teodora', 'Angelova', true),
513 (160, 'mila.lukanovska@medora.com', '$2b$12$slaz0XboBErLVSsQBaQSQOkl2uOd8/RiEzyovbImHAS95rtMvKDiO', 'DOCTOR', 'Mila', 'Lukanovska', true),
514 (161, 'lab_darko', '$2b$12$kEFZrjIohMSoqaQgr6a5Pep80r9Lf7C8ju4vVP1zNFlBDedhp.xHm', 'LAB_TECHNICIAN', 'Darko', 'Milosev', true),
515 (162, 'lab_biljana', '$2b$12$kEFZrjIohMSoqaQgr6a5Pep80r9Lf7C8ju4vVP1zNFlBDedhp.xHm', 'LAB_TECHNICIAN', 'Biljana', 'Trajkovska', true),
516 (163, 'lab_stefan', '$2b$12$kEFZrjIohMSoqaQgr6a5Pep80r9Lf7C8ju4vVP1zNFlBDedhp.xHm', 'LAB_TECHNICIAN', 'Stefan', 'Nikolovski', true),
517 (164, 'lab_marina', '$2b$12$kEFZrjIohMSoqaQgr6a5Pep80r9Lf7C8ju4vVP1zNFlBDedhp.xHm', 'LAB_TECHNICIAN', 'Marina', 'Petreska', true),
518 (165, 'lab_aleksandar', '$2b$12$kEFZrjIohMSoqaQgr6a5Pep80r9Lf7C8ju4vVP1zNFlBDedhp.xHm', 'LAB_TECHNICIAN', 'Aleksandar', 'Ristovski', true),
519 (166, 'admin_ilija', '$2b$12$ldKfa9rVgeYlftGINw5IWu3/JtyiJRJ6Is1SclgQ0PimuOfsS1m.u', 'BILLING_ADMIN', 'Ilija', 'Stojanov', true),
520 (167, 'admin_elena', '$2b$12$ldKfa9rVgeYlftGINw5IWu3/JtyiJRJ6Is1SclgQ0PimuOfsS1m.u', 'BILLING_ADMIN', 'Elena', 'Kirova', true),
521 (168, 'admin_marjan', '$2b$12$ldKfa9rVgeYlftGINw5IWu3/JtyiJRJ6Is1SclgQ0PimuOfsS1m.u', 'BILLING_ADMIN', 'Marjan', 'Petrov', true),
522 (169, 'admin_vesna', '$2b$12$ldKfa9rVgeYlftGINw5IWu3/JtyiJRJ6Is1SclgQ0PimuOfsS1m.u', 'BILLING_ADMIN', 'Vesna', 'Dimova', true),
523 (170, 'admin_dushanka', '$2b$12$ldKfa9rVgeYlftGINw5IWu3/JtyiJRJ6Is1SclgQ0PimuOfsS1m.u', 'BILLING_ADMIN', 'Dushanka', 'Trajkovska', true);
524
525-- Advance the serial sequence so future INSERTs (without explicit user_id) don't collide
526SELECT setval('users_user_id_seq', (SELECT MAX(user_id) FROM users));
527
528INSERT INTO doctors (doctor_id, first_name, last_name, email_address, level_id, specialization_id, department_id, user_id) VALUES
529 (1, 'Ivan', 'Stojanov', 'ivan.stojanov@medora.com', 1, 1, 1, 41),
530 (2, 'Elena', 'Kirova', 'elena.kirova@medora.com', 2, 1, 1, 42),
531 (3, 'Nikola', 'Trajkov', 'nikola.trajkov@medora.com', 3, 1, 1, 43),
532 (4, 'Sara', 'Dimova', 'sara.dimova@medora.com', 4, 1, 1, 44),
533 (5, 'Marija', 'Bajramovska', 'marija.bajramovska@medora.com', 5, 1, 1, 45),
534 (6, 'Ana', 'Petrova', 'ana.petrova@medora.com', 1, 2, 2, 46),
535 (7, 'Petar', 'Iliev', 'petar.iliev@medora.com', 2, 2, 2, 47),
536 (8, 'Mila', 'Stojanova', 'mila.stojanova@medora.com', 3, 2, 2, 48),
537 (9, 'Dejan', 'Markovski', 'dejan.markovski@medora.com', 4, 2, 2, 49),
538 (10, 'Kristina', 'Todorova', 'kristina.todorova@medora.com', 5, 2, 2, 50),
539 (11, 'Goran', 'Spasov', 'goran.spasov@medora.com', 1, 3, 3, 51),
540 (12, 'Ivana', 'Hristova', 'ivana.hristova@medora.com', 2, 3, 3, 52),
541 (13, 'Bojan', 'Nikolovski', 'bojan.nikolovski@medora.com', 3, 3, 3, 53),
542 (14, 'Tea', 'Angelova', 'tea.angelova@medora.com', 4, 3, 3, 54),
543 (15, 'Filip', 'Jovanov', 'filip.jovanov@medora.com', 5, 3, 3, 55),
544 (16, 'Natasha', 'Petkovska', 'natasha.petkovska@medora.com', 1, 4, 4, 56),
545 (17, 'Viktor', 'Andreev', 'viktor.andreev@medora.com', 2, 4, 4, 57),
546 (18, 'Sofija', 'Marinova', 'sofija.marinova@medora.com', 3, 4, 4, 58),
547 (19, 'Luka', 'Nikolov', 'luka.nikolov@medora.com', 4, 4, 4, 59),
548 (20, 'Marija', 'Damjanova', 'marija.damjanova@medora.com', 5, 4, 4, 60),
549 (21, 'Katerina', 'Ilieva', 'katerina.ilieva@medora.com', 1, 5, 5, 61),
550 (22, 'Dimitar', 'Petrov', 'dimitar.petrov@medora.com', 2, 5, 5, 62),
551 (23, 'Jana', 'Kostova', 'jana.kostova@medora.com', 3, 5, 5, 63),
552 (24, 'Stefan', 'Todorov', 'stefan.todorov@medora.com', 4, 5, 5, 64),
553 (25, 'Elena', 'Markova', 'elena.markova@medora.com', 5, 5, 5, 65),
554 (26, 'Aleksandar', 'Ristovski', 'aleksandar.ristovski@medora.com', 1, 6, 6, 66),
555 (27, 'Ivana', 'Trajkovska', 'ivana.trajkovska@medora.com', 2, 6, 6, 67),
556 (28, 'Goran', 'Nikolov', 'goran.nikolov@medora.com', 3, 6, 6, 68),
557 (29, 'Mila', 'Stojkova', 'mila.stojkova@medora.com', 4, 6, 6, 69),
558 (30, 'Bojan', 'Petrov', 'bojan.petrov@medora.com', 5, 6, 6, 70),
559 (31, 'Petar', 'Angelov', 'petar.angelov@medora.com', 1, 7, 7, 71),
560 (32, 'Ana', 'Dimovska', 'ana.dimovska@medora.com', 2, 7, 7, 72),
561 (33, 'Nikola', 'Kostadinov', 'nikola.kostadinov@medora.com', 3, 7, 7, 73),
562 (34, 'Sara', 'Petrova', 'sara.petrova@medora.com', 4, 7, 7, 74),
563 (35, 'Marko', 'Stojanovski', 'marko.stojanovski@medora.com', 5, 7, 7, 75),
564 (36, 'Elena', 'Markovic', 'elena.markovic@medora.com', 1, 8, 8, 76),
565 (37, 'Ivan', 'Petrovic', 'ivan.petrovic@medora.com', 2, 8, 8, 77),
566 (38, 'Dejan', 'Ilievski', 'dejan.ilievski@medora.com', 3, 8, 8, 78),
567 (39, 'Kristina', 'Ristova', 'kristina.ristova@medora.com', 4, 8, 8, 79),
568 (40, 'Filip', 'Sokolov', 'filip.sokolov@medora.com', 5, 8, 8, 80),
569 (41, 'Goran', 'Spasovski', 'goran.spasovski@medora.com', 1, 9, 9, 81),
570 (42, 'Ivana', 'Hristovska', 'ivana.hristovska@medora.com', 2, 9, 9, 82),
571 (43, 'Bojan', 'Nikolovska', 'bojan.nikolovska@medora.com', 3, 9, 9, 83),
572 (44, 'Tea', 'Angelkovska', 'tea.angelkovska@medora.com', 4, 9, 9, 84),
573 (45, 'Luka', 'Petrovski', 'luka.petrovski@medora.com', 5, 9, 9, 85),
574 (46, 'Marija', 'Ristova', 'marija.ristova@medora.com', 1, 10, 10, 86),
575 (47, 'Viktor', 'Stojanovski', 'viktor.stojanovski@medora.com', 2, 10, 10, 87),
576 (48, 'Sofija', 'Markovska', 'sofija.markovska@medora.com', 3, 10, 10, 88),
577 (49, 'Dimitar', 'Ilievski', 'dimitar.ilievski@medora.com', 4, 10, 10, 89),
578 (50, 'Jana', 'Petrovska', 'jana.petrovska2@medora.com', 5, 10, 10, 90),
579 (51, 'Stefan', 'Nikolov', 'stefan.nikolov@medora.com', 1, 11, 11, 91),
580 (52, 'Elena', 'Trajkovska', 'elena.trajkovska@medora.com', 2, 11, 11, 92),
581 (53, 'Nikola', 'Angelov', 'nikola.angelov@medora.com', 3, 11, 11, 93),
582 (54, 'Sara', 'Dimovska', 'sara.dimovska@medora.com', 4, 11, 11, 94),
583 (55, 'Ivan', 'Kostov', 'ivan.kostov@medora.com', 5, 11, 11, 95),
584 (56, 'Petar', 'Hristov', 'petar.hristov@medora.com', 1, 12, 12, 96),
585 (57, 'Ana', 'Petrovska', 'ana.petrovska3@medora.com', 2, 12, 12, 97),
586 (58, 'Dejan', 'Stojkov', 'dejan.stojkov@medora.com', 3, 12, 12, 98),
587 (59, 'Kristina', 'Ristovska', 'kristina.ristovska@medora.com', 4, 12, 12, 99),
588 (60, 'Goran', 'Nikolovski', 'goran.nikolovski@medora.com', 5, 12, 12, 100),
589 (61, 'Ivana', 'Markov', 'ivana.markov@medora.com', 1, 13, 13, 101),
590 (62, 'Bojan', 'Petrovski', 'bojan.petrovski1@medora.com', 2, 13, 13, 102),
591 (63, 'Tea', 'Ilieva', 'tea.ilieva@medora.com', 3, 13, 13, 103),
592 (64, 'Filip', 'Spasov', 'filip.spasov@medora.com', 4, 13, 13, 104),
593 (65, 'Marija', 'Angelova', 'marija.angelova@medora.com', 5, 13, 13, 105),
594 (66, 'Viktor', 'Kirov', 'viktor.kirov@medora.com', 1, 14, 14, 106),
595 (67, 'Sofija', 'Petrovska', 'sofija.petrovska@medora.com', 2, 14, 14, 107),
596 (68, 'Luka', 'Ristovski', 'luka.ristovski@medora.com', 3, 14, 14, 108),
597 (69, 'Dimitar', 'Markov', 'dimitar.markov@medora.com', 4, 14, 14, 109),
598 (70, 'Jana', 'Nikolova', 'jana.nikolova@medora.com', 5, 14, 14, 110),
599 (71, 'Marko', 'Stojanov', 'marko.stojanov@medora.com', 1, 15, 15, 111),
600 (72, 'Elena', 'Ilievska', 'elena.ilievska@medora.com', 2, 15, 15, 112),
601 (73, 'Nikola', 'Petrov', 'nikola.petrov@medora.com', 3, 15, 15, 113),
602 (74, 'Sara', 'Trajkovska', 'sara.trajkovska@medora.com', 4, 15, 15, 114),
603 (75, 'Ivan', 'Dimov', 'ivan.dimov@medora.com', 5, 15, 15, 115),
604 (76, 'Goran', 'Ristov', 'goran.ristov@medora.com', 1, 16, 16, 116),
605 (77, 'Ivana', 'Kostadinova', 'ivana.kostadinova@medora.com', 2, 16, 16, 117),
606 (78, 'Bojan', 'Petkov', 'bojan.petkov@medora.com', 3, 16, 16, 118),
607 (79, 'Tea', 'Markovska', 'tea.markovska@medora.com', 4, 16, 16, 119),
608 (80, 'Filip', 'Stojanov', 'filip.stojanov@medora.com', 5, 16, 16, 120),
609 (81, 'Marija', 'Hristovska', 'marija.hristovska@medora.com', 1, 17, 17, 121),
610 (82, 'Viktor', 'Iliev', 'viktor.iliev@medora.com', 2, 17, 17, 122),
611 (83, 'Sofija', 'Petrovski', 'sofija.petrovski@medora.com', 3, 17, 17, 123),
612 (84, 'Luka', 'Angelovska', 'luka.angelovska@medora.com', 4, 17, 17, 124),
613 (85, 'Dimitar', 'Kirovski', 'dimitar.kirovski@medora.com', 5, 17, 17, 125),
614 (86, 'Jana', 'Ristova', 'jana.ristova@medora.com', 1, 18, 18, 126),
615 (87, 'Marko', 'Petrovic', 'marko.petrovic@medora.com', 2, 18, 18, 127),
616 (88, 'Elena', 'Stojkovska', 'elena.stojkovska@medora.com', 3, 18, 18, 128),
617 (89, 'Nikola', 'Trajkovic', 'nikola.trajkovic@medora.com', 4, 18, 18, 129),
618 (90, 'Sara', 'Dimkovska', 'sara.dimkovska@medora.com', 5, 18, 18, 130),
619 (91, 'Ivan', 'Spasov', 'ivan.spasov@medora.com', 1, 19, 19, 131),
620 (92, 'Petar', 'Nikolov', 'petar.nikolov@medora.com', 2, 19, 19, 132),
621 (93, 'Ana', 'Markovska', 'ana.markovska@medora.com', 3, 19, 19, 133),
622 (94, 'Dejan', 'Iliev', 'dejan.iliev@medora.com', 4, 19, 19, 134),
623 (95, 'Kristina', 'Petrova', 'kristina.petrova@medora.com', 5, 19, 19, 135),
624 (96, 'Goran', 'Stojanovski', 'goran.stojanovski@medora.com', 1, 20, 20, 136),
625 (97, 'Ivana', 'Hristova', 'ivana.hristova1@medora.com', 2, 20, 20, 137),
626 (98, 'Bojan', 'Kostov', 'bojan.kostov@medora.com', 3, 20, 20, 138),
627 (99, 'Tea', 'Petrovska', 'tea.petrovska@medora.com', 4, 20, 20, 139),
628 (100, 'Filip', 'Ristovski', 'filip.ristovski@medora.com', 5, 20, 20, 140),
629 (101, 'Marija', 'Angelovska', 'marija.angelovska@medora.com', 1, 21, 21, 141),
630 (102, 'Viktor', 'Markovski', 'viktor.markovski@medora.com', 2, 21, 21, 142),
631 (103, 'Sofija', 'Petrova', 'sofija.petrova@medora.com', 3, 21, 21, 143),
632 (104, 'Luka', 'Ilievski', 'luka.ilievski@medora.com', 4, 21, 21, 144),
633 (105, 'Dimitar', 'Stojanov', 'dimitar.stojanov@medora.com', 5, 21, 21, 145),
634 (106, 'Jana', 'Kirovska', 'jana.kirovska@medora.com', 1, 22, 22, 146),
635 (107, 'Marko', 'Petkov', 'marko.petkov@medora.com', 2, 22, 22, 147),
636 (108, 'Elena', 'Ristova', 'elena.ristova@medora.com', 3, 22, 22, 148),
637 (109, 'Nikola', 'Dimov', 'nikola.dimov@medora.com', 4, 22, 22, 149),
638 (110, 'Sara', 'Nikolova', 'sara.nikolova@medora.com', 5, 22, 22, 150),
639 (111, 'Ivan', 'Trajkov', 'ivan.trajkov@medora.com', 1, 23, 23, 151),
640 (112, 'Petar', 'Stojkov', 'petar.stojkov@medora.com', 2, 23, 23, 152),
641 (113, 'Ana', 'Petrovska', 'ana.petrovska1@medora.com', 3, 23, 23, 153),
642 (114, 'Dejan', 'Markov', 'dejan.markov@medora.com', 4, 23, 23, 154),
643 (115, 'Kristina', 'Ilieva', 'kristina.ilieva@medora.com', 5, 23, 23, 155),
644 (116, 'Filip', 'Kostadinov', 'filip.kostadinov@medora.com', 1, 24, 24, 156),
645 (117, 'Ivana', 'Spasova', 'ivana.spasova@medora.com', 2, 24, 24, 157),
646 (118, 'Bojan', 'Petrovski', 'bojan.petrovski2@medora.com', 3, 24, 24, 158),
647 (119, 'Teodora', 'Angelova', 'teodora.angelova@medora.com', 4, 24, 24, 159),
648 (120, 'Mila', 'Lukanovska', 'mila.lukanovska@medora.com', 5, 24, 24, 160);
649
650
651INSERT INTO patients (
652 patient_id, first_name, last_name, email_address, date_of_birth,
653 blood_type, gender, phone_number, embg, user_id
654) VALUES
655 (1, 'Maja', 'Veljanova', 'maja.veljanova@gmail.com', '1994-02-14', 'A+', 'FEMALE', '070111222', '1402994123456', 2),
656 (2, 'Kristijan', 'Bojkov', 'kristijan.bojkov@gmail.com', '1991-06-21', 'O-', 'MALE', '071222333', '2106991123457', 3),
657 (3, 'Tamara', 'Gorgieva', 'tamara.gorgieva@gmail.com', '2000-11-03', 'B+', 'FEMALE', '072333444', '0311000123458', 4),
658 (4, 'Aleks', 'Nikolovski', 'aleks.nikolovski@gmail.com', '1988-09-10', 'AB+', 'MALE', '073444555', '1009988123459', 5),
659 (5, 'Sara', 'Milevska', 'sara.milevska@gmail.com', '1997-12-25', 'A-', 'FEMALE', '074555666', '2512997123460', 6),
660 (6, 'Stefan', 'Arsovski', 'stefan.arsovski@gmail.com', '1993-04-18', 'O+', 'MALE', '075666777', '1804993123461', 7),
661 (7, 'Elena', 'Petreska', 'elena.petreska@gmail.com', '1999-07-09', 'B-', 'FEMALE', '076777888', '0907999123462', 8),
662 (8, 'Viktor', 'Stankov', 'viktor.stankov@gmail.com', '1990-01-30', 'A+', 'MALE', '077888999', '3001990123463', 9),
663 (9, 'Ivana', 'Dimitrova', 'ivana.dimitrova@gmail.com', '1995-05-12', 'O-', 'FEMALE', '078999111', '1205995123464', 10),
664 (10, 'Marko', 'Lazarevski', 'marko.lazarevski@gmail.com', '1987-08-22', 'AB-', 'MALE', '070123456', '2208987123465', 11),
665 (11, 'Jana', 'Trajkovska', 'jana.trajkovska@gmail.com', '2001-03-17', 'A+', 'FEMALE', '071234567', '1703001123466', 12),
666 (12, 'Petar', 'Kostov', 'petar.kostov@gmail.com', '1992-10-05', 'B+', 'MALE', '072345678', '0510992123467', 13),
667 (13, 'Ana', 'Ristova', 'ana.ristova@gmail.com', '1996-06-28', 'O+', 'FEMALE', '073456789', '2806996123468', 14),
668 (14, 'Nikola', 'Sokolov', 'nikola.sokolov@gmail.com', '1989-02-11', 'A-', 'MALE', '074567890', '1102989123469', 15),
669 (15, 'Mila', 'Petrova', 'mila.petrova@gmail.com', '2002-09-19', 'AB+', 'FEMALE', '075678901', '1909022123470', 16),
670 (16, 'Dejan', 'Ilievski', 'dejan.ilievski@gmail.com', '1994-11-11', 'O+', 'MALE', '076789012', '1111994123471', 17),
671 (17, 'Kristina', 'Markovska', 'kristina.markovska@gmail.com', '1998-01-14', 'B+', 'FEMALE', '077890123', '1401988123472', 18),
672 (18, 'Goran', 'Petrov', 'goran.petrov@gmail.com', '1986-07-07', 'A+', 'MALE', '078901234', '0707986123473', 19),
673 (19, 'Sofija', 'Nikolova', 'sofija.nikolova@gmail.com', '2000-12-02', 'O-', 'FEMALE', '070112233', '0212000123474', 20),
674 (20, 'Dimitar', 'Angelov', 'dimitar.angelov@gmail.com', '1991-03-03', 'B-', 'MALE', '071223344', '0303991123475', 21),
675 (21, 'Teodora', 'Hristova', 'teodora.hristova@gmail.com', '1997-08-08', 'A+', 'FEMALE', '072334455', '0808997123476', 22),
676 (22, 'Filip', 'Stojanov', 'filip.stojanov@gmail.com', '1993-05-15', 'AB+', 'MALE', '073445566', '1505993123477', 23),
677 (23, 'Marija', 'Kirovska', 'marija.kirovska@gmail.com', '1999-10-10', 'O+', 'FEMALE', '074556677', '1010999123478', 24),
678 (24, 'Ivan', 'Bojkov', 'ivan.bojkov@gmail.com', '1988-12-12', 'A-', 'MALE', '075667788', '1212988123479', 25),
679 (25, 'Lina', 'Petrovska', 'lina.petrovska@gmail.com', '2001-04-04', 'B+', 'FEMALE', '076778899', '0404001123480', 26),
680 (26, 'Bojan', 'Spasov', 'bojan.spasov@gmail.com', '1992-02-20', 'O+', 'MALE', '077889900', '2002992123481', 27),
681 (27, 'Ana', 'Dimovska', 'ana.dimovska@gmail.com', '1995-09-09', 'A+', 'FEMALE', '078990011', '0909995123482', 28),
682 (28, 'Vladimir', 'Ristovski', 'vladimir.ristovski@gmail.com', '1987-06-16', 'AB-', 'MALE', '070998877', '1606987123483', 29),
683 (29, 'Katerina', 'Todorova', 'katerina.todorova@gmail.com', '2003-01-01', 'O-', 'FEMALE', '071887766', '0101033123484', 30),
684 (30, 'Martin', 'Iliev', 'martin.iliev@gmail.com', '1990-11-23', 'B+', 'MALE', '072776655', '2311990123485', 31),
685 (31, 'Elena', 'Trajkov', 'elena.trajkov@gmail.com', '1996-03-13', 'A-', 'FEMALE', '073665544', '1303996123486', 32),
686 (32, 'Aleksandar', 'Petrovski', 'aleksandar.petrovski@gmail.com', '1994-07-27', 'O+', 'MALE', '074554433', '2707994123487', 33),
687 (33, 'Maja', 'Stojanovska', 'maja.stojanovska@gmail.com', '1998-09-18', 'B-', 'FEMALE', '075443322', '1809998123488', 34),
688 (34, 'Nikola', 'Gligorov', 'nikola.gligorov@gmail.com', '1989-05-05', 'A+', 'MALE', '076332211', '0505989123489', 35),
689 (35, 'Sara', 'Ilieva', 'sara.ilieva@gmail.com', '2002-12-12', 'AB+', 'FEMALE', '077221100', '1212022123490', 36),
690 (36, 'Petar', 'Markovski', 'petar.markovski@gmail.com', '1993-03-03', 'O+', 'MALE', '078110099', '0303993123491', 37),
691 (37, 'Ivana', 'Petrovska', 'ivana.petrovska@gmail.com', '1997-07-07', 'A-', 'FEMALE', '070223344', '0707997123492', 38),
692 (38, 'Goran', 'Nikolovski', 'goran.nikolovski@gmail.com', '1986-10-10', 'B+', 'MALE', '071334455', '1010986123493', 39),
693 (39, 'Jana', 'Ristova', 'jana.ristova@gmail.com', '2000-01-20', 'O-', 'FEMALE', '072445566', '2001000123494', 40);
694
695
696INSERT INTO admin (
697 admin_id,
698 username,
699 name,
700 lastname,
701 email,
702 user_id
703) VALUES
704 (2, 'admin_ilija', 'Ilija', 'Stojanov', 'ilija.stojanov@adminmedora.com', 166),
705 (3, 'admin_elena', 'Elena', 'Kirova', 'elena.kirova@adminmedora.com', 167),
706 (4, 'admin_marjan', 'Marjan', 'Petrov', 'marjan.petrov@adminmedora.com', 168),
707 (5, 'admin_vesna', 'Vesna', 'Dimova', 'vesna.dimova@adminmedora.com', 169),
708 (6, 'admin_dushanka', 'Dushanka', 'Trajkovska', 'drushanka.trajkovska@adminmedora.com', 170);
709
710
711INSERT INTO lab_technician (
712 technician_id,
713 username,
714 name,
715 lastname,
716 email,
717 user_id
718) VALUES
719 (1, 'lab_darko', 'Darko', 'Milosev', 'darko.milosev@labmedora.com', 161),
720 (2, 'lab_biljana', 'Biljana', 'Trajkovska', 'biljana.trajkovska@labmedora.com', 162),
721 (3, 'lab_stefan', 'Stefan', 'Nikolovski', 'stefan.nikolovski@labmedora.com', 163),
722 (4, 'lab_marina', 'Marina', 'Petreska', 'marina.petreska@labmedora.com', 164),
723 (5, 'lab_aleksandar', 'Aleksandar', 'Ristovski', 'aleksandar.ristovski@labmedora.com', 165);
724
725
726INSERT INTO appointments (
727 appointment_id,
728 appointment_date,
729 appointment_time,
730 status,
731 patient_id,
732 doctor_id
733) VALUES
734 (1, '2026-01-10', '09:00:00', 'SCHEDULED', 1, 6),
735 (2, '2026-01-10', '09:30:00', 'COMPLETED', 2, 12),
736 (3, '2026-01-11', '10:00:00', 'COMPLETED', 3, 18),
737 (4, '2026-01-11', '10:30:00', 'CANCELLED', 4, 24),
738 (5, '2026-01-12', '11:00:00', 'SCHEDULED', 5, 31),
739 (6, '2026-01-12', '11:30:00', 'COMPLETED', 6, 37),
740 (7, '2026-01-13', '12:00:00', 'IN_PROGRESS', 7, 43),
741 (8, '2026-01-13', '12:30:00', 'SCHEDULED', 8, 49),
742 (9, '2026-01-14', '13:00:00', 'COMPLETED', 9, 55),
743 (10, '2026-01-14', '13:30:00', 'SCHEDULED', 10, 61);
744
745
746INSERT INTO diagnosis (diagnosis_id, name, description, patient_id, doctor_id) VALUES
747 (1, 'Essential hypertension', 'Persistent high blood pressure', 1, 1),
748 (2, 'Type 2 diabetes mellitus', 'Chronic glucose metabolism disorder', 1, 1),
749 (3, 'Acute bronchitis', 'Inflammation of bronchial tubes', 1, 1),
750 (4, 'Asthma', 'Chronic airway inflammation', 1, 1),
751 (5, 'Pneumonia', 'Lung infection', 1, 1),
752 (6, 'Chronic obstructive pulmonary disease', 'Progressive lung disease', 1, 1),
753 (7, 'Migraine', 'Recurrent severe headaches', 1, 1),
754 (8, 'Epilepsy', 'Neurological seizure disorder', 1, 1),
755 (9, 'Parkinson disease', 'Neurodegenerative movement disorder', 1, 1),
756 (10, 'Alzheimer disease', 'Progressive cognitive decline', 1, 1),
757 (11, 'Osteoarthritis', 'Degenerative joint disease', 1, 1),
758 (12, 'Rheumatoid arthritis', 'Autoimmune joint inflammation', 1, 1),
759 (13, 'Fracture of femur', 'Bone fracture of thigh', 1, 1),
760 (14, 'Lumbar disc herniation', 'Spinal disc displacement', 1, 1),
761 (15, 'Scoliosis', 'Abnormal spine curvature', 1, 1),
762 (16, 'Gastritis', 'Stomach lining inflammation', 1, 1),
763 (17, 'Peptic ulcer disease', 'Ulcer in stomach or duodenum', 1, 1),
764 (18, 'Gastroesophageal reflux disease', 'Acid reflux disorder', 1, 1),
765 (19, 'Appendicitis', 'Inflammation of appendix', 1, 1),
766 (20, 'Cholelithiasis', 'Gallstones', 1, 1),
767 (21, 'Acute kidney injury', 'Sudden kidney failure', 1, 1),
768 (22, 'Chronic kidney disease', 'Long-term kidney damage', 1, 1),
769 (23, 'Urinary tract infection', 'Bacterial urinary infection', 1, 1),
770 (24, 'Nephrotic syndrome', 'Kidney protein loss disorder', 1, 1),
771 (25, 'Kidney stone', 'Renal calculus', 1, 1),
772 (26, 'Breast cancer', 'Malignant tumor of breast', 1, 1),
773 (27, 'Lung cancer', 'Malignant lung tumor', 1, 1),
774 (28, 'Leukemia', 'Blood cancer', 1, 1),
775 (29, 'Lymphoma', 'Lymphatic system cancer', 1, 1),
776 (30, 'Skin melanoma', 'Malignant skin tumor', 1, 1),
777 (31, 'Atopic dermatitis', 'Chronic skin inflammation', 1, 1),
778 (32, 'Psoriasis', 'Autoimmune skin disorder', 1, 1),
779 (33, 'Acne vulgaris', 'Inflammatory skin condition', 1, 1),
780 (34, 'Urticaria', 'Allergic skin reaction', 1, 1),
781 (35, 'Cellulitis', 'Bacterial skin infection', 1, 1),
782 (36, 'Influenza', 'Viral respiratory infection', 1, 1),
783 (37, 'COVID-19', 'Coronavirus infection', 1, 1),
784 (38, 'Hepatitis B', 'Liver viral infection', 1, 1),
785 (39, 'Hepatitis C', 'Chronic liver infection', 1, 1),
786 (40, 'Tuberculosis', 'Mycobacterial infection', 1, 1),
787 (41, 'Anemia', 'Low red blood cell count', 1, 1),
788 (42, 'Iron deficiency anemia', 'Lack of iron in blood', 1, 1),
789 (43, 'Hemophilia', 'Blood clotting disorder', 1, 1),
790 (44, 'Thrombocytopenia', 'Low platelet count', 1, 1),
791 (45, 'Deep vein thrombosis', 'Blood clot in deep veins', 1, 1),
792 (46, 'Pulmonary embolism', 'Blocked lung artery', 1, 1),
793 (47, 'Hyperthyroidism', 'Overactive thyroid gland', 1, 1),
794 (48, 'Hypothyroidism', 'Underactive thyroid gland', 1, 1),
795 (49, 'Cushing syndrome', 'Excess cortisol production', 1, 1),
796 (50, 'Addison disease', 'Adrenal insufficiency', 1, 1),
797 (51, 'Depression', 'Mood disorder', 1, 1),
798 (52, 'Anxiety disorder', 'Chronic anxiety condition', 1, 1),
799 (53, 'Bipolar disorder', 'Mood instability disorder', 1, 1),
800 (54, 'Schizophrenia', 'Psychotic disorder', 1, 1),
801 (55, 'Insomnia', 'Sleep disorder', 1, 1),
802 (56, 'Sleep apnea', 'Breathing interruption during sleep', 1, 1),
803 (57, 'Otitis media', 'Middle ear infection', 1, 1),
804 (58, 'Tonsillitis', 'Tonsil inflammation', 1, 1),
805 (59, 'Sinusitis', 'Sinus infection', 1, 1),
806 (60, 'Hearing loss', 'Reduced hearing ability', 1, 1),
807 (61, 'Cataract', 'Eye lens clouding', 1, 1),
808 (62, 'Glaucoma', 'Optic nerve damage', 1, 1),
809 (63, 'Macular degeneration', 'Retinal deterioration', 1, 1),
810 (64, 'Conjunctivitis', 'Eye inflammation', 1, 1),
811 (65, 'Dry eye syndrome', 'Insufficient tear production', 1, 1),
812 (66, 'Obesity', 'Excess body fat', 1, 1),
813 (67, 'Metabolic syndrome', 'Cluster of metabolic disorders', 1, 1),
814 (68, 'Hyperlipidemia', 'High cholesterol levels', 1, 1),
815 (69, 'Vitamin D deficiency', 'Low vitamin D levels', 1, 1),
816 (70, 'Osteoporosis', 'Bone density loss', 1, 1),
817 (71, 'Gout', 'Uric acid crystal arthritis', 1, 1),
818 (72, 'Fibromyalgia', 'Chronic pain disorder', 1, 1),
819 (73, 'Multiple sclerosis', 'Autoimmune nerve disorder', 1, 1),
820 (74, 'Myocardial infarction', 'Heart attack', 1, 1),
821 (75, 'Heart failure', 'Reduced heart pumping function', 1, 1),
822 (76, 'Arrhythmia', 'Irregular heartbeat', 1, 1),
823 (77, 'Cardiomyopathy', 'Heart muscle disease', 1, 1),
824 (78, 'Endocarditis', 'Heart infection', 1, 1),
825 (79, 'Pericarditis', 'Heart lining inflammation', 1, 1),
826 (80, 'Atherosclerosis', 'Artery plaque buildup', 1, 1),
827 (81, 'Sepsis', 'Systemic infection response', 1, 1),
828 (82, 'Meningitis', 'Brain membrane infection', 1, 1),
829 (83, 'Encephalitis', 'Brain inflammation', 1, 1),
830 (84, 'Stroke', 'Brain blood flow interruption', 1, 1),
831 (85, 'Transient ischemic attack', 'Mini-stroke', 1, 1),
832 (86, 'Pancreatitis', 'Pancreas inflammation', 1, 1),
833 (87, 'Liver cirrhosis', 'Chronic liver damage', 1, 1),
834 (88, 'Fatty liver disease', 'Fat accumulation in liver', 1, 1),
835 (89, 'Cholecystitis', 'Gallbladder inflammation', 1, 1),
836 (90, 'Hernia', 'Organ protrusion through muscle', 1, 1),
837 (91, 'Eczema', 'Skin inflammation', 1, 1),
838 (92, 'Dermatitis', 'General skin irritation', 1, 1),
839 (93, 'Allergic rhinitis', 'Nasal allergy', 1, 1),
840 (94, 'Food allergy reaction', 'Immune response to food', 1, 1),
841 (95, 'Drug allergy reaction', 'Adverse medication reaction', 1, 1),
842 (96, 'Anaphylaxis', 'Severe allergic reaction', 1, 1),
843 (97, 'Heat stroke', 'Overheating condition', 1, 1),
844 (98, 'Hypothermia', 'Low body temperature', 1, 1),
845 (99, 'Dehydration', 'Fluid loss condition', 1, 1),
846 (100, 'Electrolyte imbalance', 'Disturbed mineral levels', 1, 1),
847 (101, 'Hypertensive crisis', 'Severely elevated blood pressure emergency', 1, 1),
848 (102, 'Stable angina', 'Chest pain due to reduced blood flow', 1, 1),
849 (103, 'Unstable angina', 'Acute coronary syndrome symptom', 1, 1),
850 (104, 'Atrial fibrillation', 'Irregular heart rhythm', 1, 1),
851 (105, 'Ventricular tachycardia', 'Fast abnormal heart rhythm', 1, 1),
852 (106, 'Bronchiectasis', 'Permanent airway dilation', 1, 1),
853 (107, 'Pleural effusion', 'Fluid in lung cavity', 1, 1),
854 (108, 'Pneumothorax', 'Collapsed lung', 1, 1),
855 (109, 'Pulmonary fibrosis', 'Lung tissue scarring', 1, 1),
856 (110, 'Respiratory failure', 'Inadequate oxygen exchange', 1, 1),
857 (111, 'Bell palsy', 'Facial nerve paralysis', 1, 1),
858 (112, 'Trigeminal neuralgia', 'Facial nerve pain disorder', 1, 1),
859 (113, 'Carpal tunnel syndrome', 'Median nerve compression', 1, 1),
860 (114, 'Peripheral neuropathy', 'Nerve damage disorder', 1, 1),
861 (115, 'Restless legs syndrome', 'Uncontrolled leg movement urge', 1, 1),
862 (116, 'Cervical spondylosis', 'Neck spine degeneration', 1, 1),
863 (117, 'Spinal stenosis', 'Narrowing of spinal canal', 1, 1),
864 (118, 'Sciatica', 'Sciatic nerve pain', 1, 1),
865 (119, 'Tension headache', 'Muscle contraction headache', 1, 1),
866 (120, 'Cluster headache', 'Severe recurring headaches', 1, 1),
867 (121, 'Crohn disease', 'Inflammatory bowel disease', 1, 1),
868 (122, 'Ulcerative colitis', 'Colon inflammation disease', 1, 1),
869 (123, 'Irritable bowel syndrome', 'Functional bowel disorder', 1, 1),
870 (124, 'Celiac disease', 'Gluten intolerance disorder', 1, 1),
871 (125, 'Lactose intolerance', 'Milk sugar digestion disorder', 1, 1),
872 (126, 'Hemorrhoids', 'Swollen rectal veins', 1, 1),
873 (127, 'Anal fissure', 'Small tear in anal lining', 1, 1),
874 (128, 'Diverticulitis', 'Colon pouch inflammation', 1, 1),
875 (129, 'Intestinal obstruction', 'Blocked bowel passage', 1, 1),
876 (130, 'Peritonitis', 'Abdominal cavity infection', 1, 1),
877 (131, 'Prostatitis', 'Prostate gland inflammation', 1, 1),
878 (132, 'Benign prostatic hyperplasia', 'Prostate enlargement', 1, 1),
879 (133, 'Erectile dysfunction', 'Male sexual dysfunction', 1, 1),
880 (134, 'End stage renal disease', 'Kidney failure stage 5', 1, 1),
881 (135, 'Glomerulonephritis', 'Kidney filter inflammation', 1, 1),
882 (136, 'Pyelonephritis', 'Kidney infection', 1, 1),
883 (137, 'Bladder cancer', 'Malignant bladder tumor', 1, 1),
884 (138, 'Testicular torsion', 'Twisted testicle condition', 1, 1),
885 (139, 'Ovarian cyst', 'Fluid-filled ovary sac', 1, 1),
886 (140, 'Endometriosis', 'Uterine tissue outside uterus', 1, 1),
887 (141, 'Thyroid nodule', 'Thyroid gland lump', 1, 1),
888 (142, 'Goiter', 'Thyroid enlargement', 1, 1),
889 (143, 'Hyperparathyroidism', 'Excess parathyroid hormone', 1, 1),
890 (144, 'Hypoparathyroidism', 'Low parathyroid function', 1, 1),
891 (145, 'Diabetic ketoacidosis', 'Diabetes metabolic emergency', 1, 1),
892 (146, 'Hypoglycemia', 'Low blood sugar', 1, 1),
893 (147, 'Hyperglycemia', 'High blood sugar', 1, 1),
894 (148, 'Metabolic acidosis', 'Excess acid in blood', 1, 1),
895 (149, 'Respiratory acidosis', 'CO2 buildup in blood', 1, 1),
896 (150, 'Respiratory alkalosis', 'Low CO2 in blood', 1, 1),
897 (151, 'Septic shock', 'Severe infection-induced shock', 1, 1),
898 (152, 'Systemic inflammatory response syndrome', 'Body-wide inflammation', 1, 1),
899 (153, 'Bacterial meningitis', 'Bacterial brain infection', 1, 1),
900 (154, 'Viral meningitis', 'Viral brain infection', 1, 1),
901 (155, 'Hepatic encephalopathy', 'Liver-related brain dysfunction', 1, 1),
902 (156, 'Alcoholic liver disease', 'Alcohol-related liver damage', 1, 1),
903 (157, 'Cholangitis', 'Bile duct infection', 1, 1),
904 (158, 'Pancreatic necrosis', 'Severe pancreatic tissue death', 1, 1),
905 (159, 'Gastroenteritis', 'Stomach and intestinal infection', 1, 1),
906 (160, 'Food poisoning', 'Toxin or bacteria ingestion illness', 1, 1),
907 (161, 'Psoriatic arthritis', 'Joint inflammation from psoriasis', 1, 1),
908 (162, 'Systemic lupus erythematosus', 'Autoimmune systemic disease', 1, 1),
909 (163, 'Scleroderma', 'Skin hardening autoimmune disease', 1, 1),
910 (164, 'Vasculitis', 'Blood vessel inflammation', 1, 1),
911 (165, 'Raynaud disease', 'Blood flow restriction in extremities', 1, 1),
912 (166, 'Cellulitis of leg', 'Skin bacterial infection in leg', 1, 1),
913 (167, 'Impetigo', 'Contagious skin infection', 1, 1),
914 (168, 'Herpes simplex infection', 'Viral skin infection', 1, 1),
915 (169, 'Shingles', 'Reactivation of chickenpox virus', 1, 1),
916 (170, 'Warts', 'HPV skin growths', 1, 1),
917 (171, 'Vitamin B12 deficiency', 'Low B12 levels', 1, 1),
918 (172, 'Folate deficiency', 'Low folic acid levels', 1, 1),
919 (173, 'Scurvy', 'Vitamin C deficiency disease', 1, 1),
920 (174, 'Rickets', 'Vitamin D deficiency in children', 1, 1),
921 (175, 'Osteomalacia', 'Softening of bones', 1, 1),
922 (176, 'Hypercalcemia', 'High calcium levels', 1, 1),
923 (177, 'Hypocalcemia', 'Low calcium levels', 1, 1),
924 (178, 'Hyponatremia', 'Low sodium levels', 1, 1),
925 (179, 'Hypernatremia', 'High sodium levels', 1, 1),
926 (180, 'Hypokalemia', 'Low potassium levels', 1, 1),
927 (181, 'Hyperkalemia', 'High potassium levels', 1, 1),
928 (182, 'Heat exhaustion', 'Heat-related illness', 1, 1),
929 (183, 'Frostbite', 'Cold-induced tissue damage', 1, 1),
930 (184, 'Carbon monoxide poisoning', 'Toxic gas exposure', 1, 1),
931 (185, 'Drug overdose', 'Excess medication intake', 1, 1),
932 (186, 'Alcohol poisoning', 'Toxic alcohol levels', 1, 1),
933 (187, 'Snake bite', 'Venomous bite injury', 1, 1),
934 (188, 'Animal bite infection', 'Infected bite wound', 1, 1),
935 (189, 'Tetanus', 'Bacterial muscle stiffness disease', 1, 1),
936 (190, 'Rabies exposure', 'Viral bite exposure', 1, 1),
937 (191, 'Acute stress disorder', 'Short-term trauma response', 1, 1),
938 (192, 'Post-traumatic stress disorder', 'Long-term trauma disorder', 1, 1),
939 (193, 'Panic disorder', 'Sudden anxiety attacks', 1, 1),
940 (194, 'Social anxiety disorder', 'Fear of social situations', 1, 1),
941 (195, 'Obsessive compulsive disorder', 'Repetitive thoughts/behavior', 1, 1),
942 (196, 'Attention deficit hyperactivity disorder', 'Attention regulation disorder', 1, 1),
943 (197, 'Autism spectrum disorder', 'Neurodevelopmental condition', 1, 1),
944 (198, 'Intellectual disability', 'Cognitive impairment condition', 1, 1),
945 (199, 'Sleepwalking', 'Parasomnia disorder', 1, 1),
946 (200, 'Night terrors', 'Severe sleep disturbance', 1, 1);
947
948
949INSERT INTO procedures (procedure_id, procedure_type, procedure_date, description, cost, doctor_id) VALUES
950 (1, 'Spirometry', '2026-01-10', 'Lung function test measuring airflow', 50, 1),
951 (2, 'Bronchoscopy', '2026-01-10', 'Endoscopic examination of airways', 200, 1),
952 (3, 'Body plethysmography', '2026-01-11', 'Measurement of lung volumes', 180, 1),
953 (4, 'Diffusion capacity test (DLCO)', '2026-01-11', 'Gas exchange efficiency test', 120, 1),
954 (5, 'Peak flow measurement', '2026-01-12', 'Maximum exhalation speed test', 30, 1),
955 (6, 'Blood gas analysis', '2026-01-12', 'Oxygen and CO2 level test', 70, 1),
956 (7, 'Allergy testing', '2026-01-13', 'Identification of respiratory allergens', 90, 2),
957 (8, 'Bronchodilator test', '2026-01-13', 'Asthma response test after medication', 80, 1),
958 (9, 'ECG', '2026-01-14', 'Electrical heart activity recording', 40, 2),
959 (10, 'Echocardiography', '2026-01-14', 'Ultrasound of the heart', 120, 2),
960 (11, 'Stress test', '2026-01-15', 'Heart performance under exercise', 100, 2),
961 (12, 'Holter ECG', '2026-01-15', '24h heart rhythm monitoring', 150, 2),
962 (13, 'Blood pressure Holter', '2026-01-16', '24h blood pressure monitoring', 140, 2),
963 (14, 'Cardiac catheterization', '2026-01-16', 'Invasive heart vessel examination', 600, 2),
964 (15, 'Coronary angiography', '2026-01-17', 'Imaging of coronary arteries', 700, 2),
965 (16, 'Transesophageal echo', '2026-01-17', 'Internal heart ultrasound', 300, 2),
966 (17, 'EEG', '2026-01-18', 'Brain electrical activity test', 100, 3),
967 (18, 'EMG', '2026-01-18', 'Muscle electrical activity test', 120, 3),
968 (19, 'Evoked potentials', '2026-01-19', 'Nerve response measurement', 130, 3),
969 (20, 'Lumbar puncture', '2026-01-19', 'CSF fluid collection from spine', 250, 3),
970 (21, 'Nerve conduction study', '2026-01-20', 'Nerve signal speed test', 110, 3),
971 (22, 'Carotid Doppler', '2026-01-20', 'Blood flow in neck arteries', 140, 3),
972 (23, 'Arthroscopy', '2026-01-21', 'Joint inspection using camera', 500, 4),
973 (24, 'Hip replacement', '2026-01-21', 'Surgical hip joint replacement', 5000, 4),
974 (25, 'Knee replacement', '2026-01-22', 'Surgical knee joint replacement', 4800, 4),
975 (26, 'Fracture fixation', '2026-01-22', 'Bone stabilization surgery', 1200, 4),
976 (27, 'Ligament reconstruction', '2026-01-23', 'Repair of torn ligaments', 2500, 4),
977 (28, 'Spine surgery', '2026-01-23', 'Surgical spinal intervention', 6000, 4),
978 (29, 'Gynecological ultrasound', '2026-01-24', 'Ultrasound of female reproductive system', 80, 5),
979 (30, 'Pap smear', '2026-01-24', 'Cervical cancer screening test', 60, 5),
980 (31, 'Colposcopy', '2026-01-25', 'Detailed cervix examination', 120, 5),
981 (32, 'Hysteroscopy', '2026-01-25', 'Uterine cavity inspection', 300, 5),
982 (33, 'Laparoscopy', '2026-01-26', 'Minimally invasive abdominal surgery', 700, 5),
983 (34, 'Cesarean section', '2026-01-26', 'Surgical delivery of baby', 1500, 5),
984 (35, 'Delivery', '2026-01-27', 'Natural childbirth', 800, 5),
985 (36, 'Cervical biopsy', '2026-01-27', 'Tissue sampling from cervix', 200, 5),
986 (37, 'Audiometry', '2026-01-28', 'Hearing test', 50, 6),
987 (38, 'Tympanometry', '2026-01-28', 'Middle ear function test', 60, 6),
988 (39, 'Nasal endoscopy', '2026-01-29', 'Nasal cavity examination', 120, 6),
989 (40, 'Laryngoscopy', '2026-01-29', 'Throat and voice box examination', 130, 6),
990 (41, 'Tonsillectomy', '2026-01-30', 'Removal of tonsils', 400, 6),
991 (42, 'Sinus surgery', '2026-01-30', 'Surgical sinus treatment', 1200, 6),
992 (43, 'Vision exam', '2026-02-01', 'Eye vision testing', 40, 7),
993 (44, 'Optical coherence tomography', '2026-02-01', 'Retina imaging', 150, 7),
994 (45, 'Perimetry', '2026-02-02', 'Visual field test', 70, 7),
995 (46, 'Cataract surgery', '2026-02-02', 'Lens replacement surgery', 2000, 7),
996 (47, 'Laser eye surgery', '2026-02-03', 'Vision correction procedure', 2500, 7),
997 (48, 'Complete blood count', '2026-02-03', 'Basic blood analysis', 30, 8),
998 (49, 'Biochemistry panel', '2026-02-04', 'Blood chemical analysis', 50, 8),
999 (50, 'Coagulation tests', '2026-02-04', 'Blood clotting tests', 60, 8),
1000 (51, 'Hormone tests', '2026-02-05', 'Hormonal level analysis', 80, 8),
1001 (52, 'Microbiology tests', '2026-02-05', 'Infection detection tests', 90, 8),
1002 (53, 'PCR test', '2026-02-06', 'DNA/RNA detection test', 100, 8),
1003 (54, 'X-ray', '2026-02-06', 'Basic imaging scan', 50, 9),
1004 (55, 'CT scan', '2026-02-07', 'Cross-sectional imaging', 200, 9),
1005 (56, 'MRI', '2026-02-07', 'Magnetic resonance imaging', 350, 9),
1006 (57, 'Ultrasound', '2026-02-08', 'Sound wave imaging', 70, 9),
1007 (58, 'Mammography', '2026-02-08', 'Breast imaging', 120, 9),
1008 (59, 'Interventional radiology', '2026-02-09', 'Image-guided procedures', 800, 9),
1009 (60, 'Gastroscopy', '2026-02-09', 'Stomach camera examination', 200, 10),
1010 (61, 'Colonoscopy', '2026-02-10', 'Colon examination', 300, 10),
1011 (62, 'Biopsy', '2026-02-10', 'Tissue sampling', 250, 10),
1012 (63, 'ERCP', '2026-02-11', 'Bile duct procedure', 600, 10),
1013 (64, 'Abdominal ultrasound', '2026-02-11', 'Abdominal organ imaging', 90, 9),
1014 (65, 'Urinary tract ultrasound', '2026-02-12', 'Kidney and bladder imaging', 90, 9),
1015 (66, 'Cystoscopy', '2026-02-12', 'Bladder examination', 200, 11),
1016 (67, 'Urodynamic testing', '2026-02-13', 'Urine flow analysis', 150, 11),
1017 (68, 'Lithotripsy', '2026-02-13', 'Kidney stone breaking', 500, 11),
1018 (69, 'TURP', '2026-02-14', 'Prostate surgery', 1200, 11),
1019 (70, 'Prostate biopsy', '2026-02-14', 'Prostate tissue sampling', 250, 11),
1020 (71, 'Hemodialysis', '2026-02-15', 'Blood cleaning procedure', 200, 12),
1021 (72, 'Peritoneal dialysis', '2026-02-15', 'Abdominal dialysis', 180, 12),
1022 (73, 'Kidney biopsy', '2026-02-16', 'Kidney tissue sampling', 300, 12),
1023 (74, 'Renal clearance tests', '2026-02-16', 'Kidney function tests', 100, 12),
1024 (75, 'Electrolyte tests', '2026-02-17', 'Blood mineral analysis', 60, 12),
1025 (76, 'Chemotherapy', '2026-02-17', 'Cancer drug treatment', 2000, 13),
1026 (77, 'Radiotherapy', '2026-02-18', 'Radiation cancer treatment', 2500, 13),
1027 (78, 'Tumor biopsy', '2026-02-18', 'Cancer tissue sampling', 400, 13),
1028 (79, 'PET scan', '2026-02-19', 'Cancer imaging scan', 900, 9),
1029 (80, 'Immunotherapy', '2026-02-19', 'Immune cancer treatment', 3000, 13),
1030 (81, 'Dermatological exam', '2026-02-20', 'Skin examination', 50, 14),
1031 (82, 'Dermatoscopy', '2026-02-20', 'Skin lesion imaging', 80, 14),
1032 (83, 'Skin biopsy', '2026-02-21', 'Skin tissue sampling', 200, 14),
1033 (84, 'Cryotherapy', '2026-02-21', 'Freezing skin treatment', 150, 14),
1034 (85, 'Laser treatments', '2026-02-22', 'Skin laser therapy', 500, 14),
1035 (86, 'Pediatric exam', '2026-02-22', 'Child medical checkup', 60, 15),
1036 (87, 'Vaccination', '2026-02-23', 'Immunization procedure', 40, 15),
1037 (88, 'Neonatal screening', '2026-02-23', 'Newborn testing', 100, 15),
1038 (89, 'Growth assessment', '2026-02-24', 'Child development check', 50, 15),
1039 (90, 'Psychiatric evaluation', '2026-02-24', 'Mental health assessment', 120, 16),
1040 (91, 'Psychotherapy', '2026-02-25', 'Therapy sessions', 100, 16),
1041 (92, 'Cognitive testing', '2026-02-25', 'Brain function testing', 80, 16),
1042 (93, 'Pharmacotherapy', '2026-02-26', 'Psychiatric medication treatment', 150, 16),
1043 (94, 'Physiotherapy', '2026-02-26', 'Physical rehabilitation treatment', 80, 17),
1044 (95, 'Kinesiotherapy', '2026-02-27', 'Movement-based therapy', 90, 17),
1045 (96, 'Electrotherapy', '2026-02-27', 'Electrical stimulation therapy', 70, 17),
1046 (97, 'Hydrotherapy', '2026-02-28', 'Water-based rehabilitation therapy', 100, 17),
1047 (98, 'Blood count', '2026-03-01', 'Detailed blood cell analysis', 40, 8),
1048 (99, 'Bone marrow biopsy', '2026-03-01', 'Bone marrow sampling', 400, 8),
1049 (100, 'Coagulation studies', '2026-03-02', 'Blood clotting analysis', 80, 8),
1050 (101, 'Blood transfusion', '2026-03-02', 'Transfer of blood products', 300, 8),
1051 (102, 'Serology tests', '2026-03-03', 'Antibody detection tests', 90, 8),
1052 (103, 'PCR diagnostics', '2026-03-03', 'Molecular infection detection', 120, 8),
1053 (104, 'Microbial cultures', '2026-03-04', 'Bacteria growth testing', 100, 8),
1054 (105, 'Antibiotic therapy', '2026-03-04', 'Infection treatment with antibiotics', 200, 1),
1055 (106, 'Brain surgery', '2026-03-05', 'Surgical brain intervention', 8000, 3),
1056 (107, 'Spine surgery', '2026-03-05', 'Surgical spinal operation', 7000, 4),
1057 (108, 'Tumor removal', '2026-03-06', 'Removal of brain tumors', 9000, 3),
1058 (109, 'Shunt procedure', '2026-03-06', 'CSF drainage surgery', 6000, 3),
1059 (110, 'CABG', '2026-03-07', 'Heart bypass surgery', 10000, 2),
1060 (111, 'Valve replacement', '2026-03-07', 'Heart valve surgery', 9500, 2),
1061 (112, 'Pacemaker implantation', '2026-03-08', 'Heart rhythm device installation', 5000, 2),
1062 (113, 'Reconstructive surgery', '2026-03-08', 'Restoration of body structures', 4000, 4),
1063 (114, 'Cosmetic surgery', '2026-03-09', 'Aesthetic body improvement', 3500, 14),
1064 (115, 'Liposuction', '2026-03-09', 'Fat removal procedure', 3000, 14),
1065 (116, 'Rhinoplasty', '2026-03-10', 'Nose reshaping surgery', 3200, 6),
1066 (117, 'Appendectomy', '2026-03-10', 'Appendix removal surgery', 1500, 10),
1067 (118, 'Hernia repair', '2026-03-11', 'Hernia correction surgery', 1800, 10),
1068 (119, 'Gallbladder removal', '2026-03-11', 'Cholecystectomy procedure', 2000, 10),
1069 (120, 'Surgical biopsy', '2026-03-12', 'Tissue sampling surgery', 900, 13),
1070 (121, 'Tooth extraction', '2026-03-12', 'Removal of tooth', 100, 18),
1071 (122, 'Dental filling', '2026-03-13', 'Cavity repair', 120, 18),
1072 (123, 'Dental implants', '2026-03-13', 'Artificial tooth implantation', 1500, 18),
1073 (124, 'Teeth cleaning', '2026-03-14', 'Dental plaque removal', 80, 18);
1074
1075
1076INSERT INTO procedure_results (
1077 result_id,
1078 result_description,
1079 result_date,
1080 procedure_id
1081) VALUES
1082 (1, 'Normal lung capacity detected', '2026-01-10', 1),
1083 (2, 'Mild airway obstruction observed', '2026-01-11', 2),
1084 (3, 'Reduced diffusion capacity detected', '2026-01-12', 4),
1085 (4, 'Elevated blood pressure during stress test', '2026-01-13', 11),
1086 (5, 'Normal cardiac rhythm recorded', '2026-01-14', 9),
1087 (6, 'Abnormal EEG activity detected', '2026-01-15', 17),
1088 (7, 'Reduced nerve conduction velocity', '2026-01-16', 21),
1089 (8, 'Successful fracture stabilization', '2026-01-17', 26),
1090 (9, 'Normal cervical screening result', '2026-01-18', 30),
1091 (10, 'Moderate hearing loss detected', '2026-01-19', 37),
1092 (11, 'Cataract successfully removed', '2026-01-20', 46),
1093 (12, 'Elevated glucose levels detected', '2026-01-21', 48),
1094 (13, 'No abnormalities on CT scan', '2026-01-22', 55),
1095 (14, 'Gallstones successfully removed', '2026-01-23', 119),
1096 (15, 'Kidney stones fragmented successfully', '2026-01-24', 68),
1097 (16, 'Tumor biopsy confirmed malignant cells', '2026-01-25', 78),
1098 (17, 'Skin lesion benign after biopsy', '2026-01-26', 83),
1099 (18, 'Patient responded well to physiotherapy', '2026-01-27', 94),
1100 (19, 'Successful pacemaker implantation', '2026-01-28', 112),
1101 (20, 'Dental implant integrated successfully', '2026-01-29', 123);
1102
1103INSERT INTO prescriptions (prescription_id, medication_name) VALUES
1104 (1, 'Paracetamol'),
1105 (2, 'Ibuprofen'),
1106 (3, 'Amoxicillin'),
1107 (4, 'Azithromycin'),
1108 (5, 'Ciprofloxacin'),
1109 (6, 'Metformin'),
1110 (7, 'Insulin Glargine'),
1111 (8, 'Atorvastatin'),
1112 (9, 'Simvastatin'),
1113 (10, 'Omeprazole'),
1114 (11, 'Pantoprazole'),
1115 (12, 'Ranitidine'),
1116 (13, 'Lisinopril'),
1117 (14, 'Amlodipine'),
1118 (15, 'Losartan'),
1119 (16, 'Bisoprolol'),
1120 (17, 'Salbutamol'),
1121 (18, 'Fluticasone'),
1122 (19, 'Montelukast'),
1123 (20, 'Cetirizine'),
1124 (21, 'Loratadine'),
1125 (22, 'Dexamethasone'),
1126 (23, 'Prednisone'),
1127 (24, 'Hydrocortisone'),
1128 (25, 'Diclofenac'),
1129 (26, 'Naproxen'),
1130 (27, 'Tramadol'),
1131 (28, 'Morphine'),
1132 (29, 'Codeine'),
1133 (30, 'Diazepam'),
1134 (31, 'Lorazepam'),
1135 (32, 'Alprazolam'),
1136 (33, 'Sertraline'),
1137 (34, 'Fluoxetine'),
1138 (35, 'Citalopram'),
1139 (36, 'Escitalopram'),
1140 (37, 'Quetiapine'),
1141 (38, 'Risperidone'),
1142 (39, 'Haloperidol'),
1143 (40, 'Levodopa'),
1144 (41, 'Carbidopa'),
1145 (42, 'Donepezil'),
1146 (43, 'Memantine'),
1147 (44, 'Gabapentin'),
1148 (45, 'Pregabalin'),
1149 (46, 'Carbamazepine'),
1150 (47, 'Valproic acid'),
1151 (48, 'Lamotrigine'),
1152 (49, 'Clopidogrel'),
1153 (50, 'Aspirin'),
1154 (51, 'Warfarin'),
1155 (52, 'Heparin'),
1156 (53, 'Enoxaparin'),
1157 (54, 'Furosemide'),
1158 (55, 'Spironolactone'),
1159 (56, 'Hydrochlorothiazide'),
1160 (57, 'Digoxin'),
1161 (58, 'Nitroglycerin'),
1162 (59, 'Isosorbide mononitrate'),
1163 (60, 'Sildenafil'),
1164 (61, 'Tamsulosin'),
1165 (62, 'Finasteride'),
1166 (63, 'Dutasteride'),
1167 (64, 'Levothyroxine'),
1168 (65, 'Methimazole'),
1169 (66, 'Propylthiouracil'),
1170 (67, 'Metoclopramide'),
1171 (68, 'Ondansetron'),
1172 (69, 'Loperamide'),
1173 (70, 'Lactulose'),
1174 (71, 'Rifaximin'),
1175 (72, 'Metronidazole'),
1176 (73, 'Vancomycin'),
1177 (74, 'Linezolid'),
1178 (75, 'Doxycycline'),
1179 (76, 'Tetracycline'),
1180 (77, 'Clarithromycin'),
1181 (78, 'Erythromycin'),
1182 (79, 'Nystatin'),
1183 (80, 'Fluconazole'),
1184 (81, 'Ketoconazole'),
1185 (82, 'Aciclovir'),
1186 (83, 'Valaciclovir'),
1187 (84, 'Oseltamivir'),
1188 (85, 'Zanamivir'),
1189 (86, 'Ribavirin'),
1190 (87, 'Interferon alfa'),
1191 (88, 'Methotrexate'),
1192 (89, 'Cyclophosphamide'),
1193 (90, 'Cisplatin'),
1194 (91, 'Doxorubicin'),
1195 (92, 'Imatinib'),
1196 (93, 'Trastuzumab'),
1197 (94, 'Bevacizumab'),
1198 (95, 'Epoetin alfa'),
1199 (96, 'Filgrastim'),
1200 (97, 'Calcium carbonate'),
1201 (98, 'Vitamin D3'),
1202 (99, 'Iron sulfate'),
1203 (100, 'Magnesium sulfate');
1204
1205
1206INSERT INTO prescription_restriction (restriction_id, description, prescription_id) VALUES
1207 (1, 'Avoid use in patients with severe liver disease', 1),
1208 (2, 'Do not exceed maximum daily dose', 1),
1209 (3, 'Avoid in patients with active stomach ulcer', 2),
1210 (4, 'Use with caution in elderly patients', 2),
1211 (5, 'Contraindicated in penicillin allergy', 3),
1212 (6, 'Avoid in patients with severe kidney impairment', 5),
1213 (7, 'Monitor blood glucose regularly', 6),
1214 (8, 'Risk of hypoglycemia if meals are skipped', 7),
1215 (9, 'Not recommended during pregnancy', 8),
1216 (10, 'Avoid grapefruit juice consumption', 8),
1217 (11, 'May cause stomach irritation', 10),
1218 (12, 'Take before meals for better absorption', 10),
1219 (13, 'Do not stop abruptly without doctor supervision', 14),
1220 (14, 'Monitor blood pressure regularly', 15),
1221 (15, 'May cause dizziness or fatigue', 16),
1222 (16, 'Use with caution in asthma patients', 17),
1223 (17, 'Avoid sudden discontinuation', 18),
1224 (18, 'May cause drowsiness', 19),
1225 (19, 'Do not drive after administration', 30),
1226 (20, 'Avoid alcohol consumption', 30),
1227 (21, 'Risk of dependency with long-term use', 31),
1228 (22, 'Use only for short-term treatment', 31),
1229 (23, 'May increase suicidal thoughts in young patients', 33),
1230 (24, 'Requires regular liver function monitoring', 34),
1231 (25, 'Can cause weight gain', 37),
1232 (26, 'Avoid in Parkinson disease patients', 39),
1233 (27, 'May cause tremors or rigidity worsening', 40),
1234 (28, 'Monitor heart rate regularly', 49),
1235 (29, 'Risk of bleeding increases with NSAIDs', 50),
1236 (30, 'Avoid in pregnancy unless necessary', 51);
1237
1238
1239INSERT INTO lab_tests (test_id, test_name, description, cost) VALUES
1240 (1, 'Blood test', 'General blood analysis', 30),
1241 (2, 'Urine test', 'Urinalysis examination', 25),
1242 (3, 'Hormone test', 'Endocrine hormone evaluation', 80);
1243
1244
1245INSERT INTO lab_results (result_id, results, result_date, test_id) VALUES
1246 (1, 'WBC 6.2 x10^9/L | RBC 4.7 x10^12/L | Hemoglobin 14.1 g/dL | Hematocrit 42% | Platelets 240 x10^9/L | MCV 88 fL | MCH 29 pg | MCHC 33 g/dL | Glucose 92 mg/dL | Sodium 140 mmol/L | Potassium 4.2 mmol/L | Chloride 103 mmol/L | Bicarbonate 24 mmol/L | BUN 14 mg/dL | Creatinine 0.9 mg/dL | Albumin 4.3 g/dL | Total protein 7.1 g/dL | ALT 22 U/L | AST 20 U/L | ALP 85 U/L | Bilirubin 0.8 mg/dL | Total cholesterol 180 mg/dL | LDL 110 mg/dL | HDL 55 mg/dL | Triglycerides 130 mg/dL', '2026-05-10', 1),
1247 (2, 'WBC 7.5 x10^9/L | RBC 4.1 x10^12/L | Hemoglobin 12.3 g/dL | Hematocrit 38% | Platelets 220 x10^9/L | MCV 85 fL | MCH 27 pg | MCHC 32 g/dL | Glucose 105 mg/dL | Sodium 138 mmol/L | Potassium 4.5 mmol/L | Chloride 101 mmol/L | Bicarbonate 23 mmol/L | BUN 18 mg/dL | Creatinine 1.1 mg/dL | Albumin 4.0 g/dL | ALT 30 U/L | AST 28 U/L | Total cholesterol 210 mg/dL | LDL 140 mg/dL | HDL 42 mg/dL | Triglycerides 180 mg/dL', '2026-05-09', 1),
1248 (3, 'WBC 5.8 x10^9/L | RBC 5.0 x10^12/L | Hemoglobin 15.0 g/dL | Hematocrit 45% | Platelets 260 x10^9/L | MCV 90 fL | MCH 30 pg | MCHC 34 g/dL | Glucose 88 mg/dL | Sodium 141 mmol/L | Potassium 4.0 mmol/L | Chloride 102 mmol/L | Bicarbonate 25 mmol/L | BUN 12 mg/dL | Creatinine 0.8 mg/dL | Albumin 4.5 g/dL | ALT 18 U/L | AST 19 U/L | Total cholesterol 170 mg/dL | LDL 100 mg/dL | HDL 60 mg/dL | Triglycerides 110 mg/dL', '2026-05-08', 1),
1249 (11, 'TSH 2.1 mIU/L | Free T4 1.2 ng/dL | Free T3 3.2 pg/mL | Testosterone 520 ng/dL | Estradiol 35 pg/mL | Progesterone 1.2 ng/mL | FSH 6 IU/L | LH 5 IU/L | SHBG 40 nmol/L | Cortisol 14 µg/dL | DHEA-S 280 µg/dL | Insulin 8 µIU/mL | Prolactin 12 ng/mL | AMH 3.1 ng/mL', '2026-05-10', 3),
1250 (12, 'TSH 6.5 mIU/L | Free T4 0.7 ng/dL | Free T3 2.0 pg/mL | Testosterone 380 ng/dL | Estradiol 20 pg/mL | Progesterone 0.8 ng/mL | FSH 9 IU/L | LH 7 IU/L | SHBG 55 nmol/L | Cortisol 10 µg/dL | DHEA-S 180 µg/dL | Insulin 14 µIU/mL | Prolactin 18 ng/mL | AMH 1.8 ng/mL', '2026-05-09', 3),
1251 (13, 'TSH 1.8 mIU/L | Free T4 1.3 ng/dL | Free T3 3.5 pg/mL | Testosterone 610 ng/dL | Estradiol 40 pg/mL | Progesterone 1.5 ng/mL | FSH 5 IU/L | LH 4 IU/L | SHBG 38 nmol/L | Cortisol 22 µg/dL | DHEA-S 320 µg/dL | Insulin 6 µIU/mL | Prolactin 10 ng/mL | AMH 4.0 ng/mL', '2026-05-08', 3),
1252 (6, 'pH 6.0 | Specific gravity 1.020 | Protein negative | Glucose negative | Ketones negative | RBC none | WBC 0-2/hpf | Bacteria none', '2026-05-10', 2),
1253 (7, 'pH 5.5 | Specific gravity 1.030 | Trace protein | Glucose negative | Ketones negative | WBC 5-10/hpf | Mild bacteriuria', '2026-05-09', 2),
1254 (8, 'pH 6.2 | Specific gravity 1.015 | Protein negative | Glucose negative | Ketones negative | Normal sediment', '2026-05-08', 2),
1255 (9, 'pH 5.8 | Specific gravity 1.025 | Leukocytes ++ | Nitrites positive | Bacteria present | UTI suspected', '2026-05-07', 2),
1256 (10, 'pH 6.0 | Specific gravity 1.018 | RBC trace | Protein negative | Glucose negative | Further evaluation required', '2026-05-06', 2);
1257
1258
1259INSERT INTO medical_records (record_id, patient_id) VALUES
1260 (1, 1),
1261 (2, 2),
1262 (3, 3),
1263 (4, 4),
1264 (5, 5),
1265 (6, 6),
1266 (7, 7),
1267 (8, 8),
1268 (9, 9),
1269 (10, 10),
1270 (11, 11),
1271 (12, 12),
1272 (13, 13),
1273 (14, 14),
1274 (15, 15);
1275
1276
1277INSERT INTO referrals (referral_id, reason, referral_date, record_id, from_doctor_id, to_doctor_id) VALUES
1278 (1, 'Suspected cardiac condition requiring specialist evaluation', '2026-05-10', 3, 1, 5),
1279 (2, 'Neurological symptoms and recurrent headaches', '2026-05-09', 6, 2, 8),
1280 (3, 'Persistent respiratory issues for pulmonology review', '2026-05-08', 1, 3, 6),
1281 (4, 'Orthopedic follow-up for post-surgery assessment', '2026-05-07', 4, 4, 7),
1282 (5, 'Suspected endocrine disorder requiring hormone testing', '2026-05-06', 10, 5, 9),
1283 (6, 'Dermatological evaluation for chronic skin rash', '2026-05-05', 8, 6, 10),
1284 (7, 'Pediatric developmental concern check', '2026-05-04', 7, 7, 11),
1285 (8, 'Gastrointestinal pain requiring endoscopy', '2026-05-03', 9, 8, 12),
1286 (9, 'Abnormal lab results requiring hematology review', '2026-05-02', 10, 9, 13),
1287 (10, 'Possible kidney dysfunction requiring nephrology assessment', '2026-05-01', 10, 10, 14);
1288
1289
1290INSERT INTO medical_report (report_id, description, report_date, record_id, doctor_id) VALUES
1291 (1, 'Pulmonary function assessment confirms mild asthma. Recommended inhaler therapy.', '2026-05-10', 1, 3),
1292 (2, 'Cardiology report indicates elevated blood pressure and possible hypertension.', '2026-05-09', 2, 1),
1293 (3, 'Neurological evaluation shows no acute abnormalities. Follow-up recommended.', '2026-05-08', 6, 2),
1294 (4, 'Orthopedic post-surgery report shows stable recovery and good mobility.', '2026-05-07', 4, 4),
1295 (5, 'Gynecological report: normal ultrasound findings, no pathological changes.', '2026-05-06', 5, 5),
1296 (6, 'Dermatology report confirms allergic dermatitis. Topical treatment prescribed.', '2026-05-05', 8, 6),
1297 (7, 'Pediatric assessment: normal growth and development indicators.', '2026-05-04', 7, 7),
1298 (8, 'Gastroenterology report suggests possible gastritis. Further endoscopy advised.', '2026-05-03', 9, 8),
1299 (9, 'Laboratory review indicates mild iron deficiency anemia.', '2026-05-02', 10, 9),
1300 (10, 'Nephrology report suggests early signs of reduced kidney function.', '2026-05-01', 10, 10);
1301
1302
1303INSERT INTO billing (bill_id, total_cost, payment_status, payment_date, record_id, admin_id) VALUES
1304 (1, 230, 'PAID', '2026-05-11', 1, 2),
1305 (2, 340, 'PENDING', NULL, 2, 2),
1306 (3, 900, 'PAID', '2026-05-10', 3, 3),
1307 (4, 5200, 'PAID', '2026-05-09', 4, 2),
1308 (5, 180, 'PAID', '2026-05-08', 5, 4),
1309 (6, 420, 'PENDING', NULL, 6, 3),
1310 (7, 160, 'PAID', '2026-05-07', 7, 4),
1311 (8, 780, 'PENDING', NULL, 8, 2),
1312 (9, 250, 'PAID', '2026-05-06', 9, 3),
1313 (10, 610, 'PENDING', NULL, 10, 4);
1314
1315
1316INSERT INTO patient_allergies (patient_id, allergy_id) VALUES
1317(1, 1),
1318(1, 3),
1319(2, 2),
1320(2, 5),
1321(3, 4),
1322(4, 1),
1323(4, 6),
1324(5, 3),
1325(5, 2),
1326(6, 7),
1327(7, 5),
1328(7, 8),
1329(8, 4),
1330(8, 1),
1331(9, 6),
1332(10, 2);
1333
1334
1335INSERT INTO allergy_prescription_restrictions (allergy_id, restriction_id) VALUES
1336(1, 1),
1337(1, 2),
1338(2, 3),
1339(2, 4),
1340(3, 5),
1341(4, 6),
1342(5, 5),
1343(6, 7),
1344(6, 8),
1345(7, 3),
1346(7, 9),
1347(8, 10),
1348(1, 6),
1349(2, 6),
1350(3, 10);
1351
1352
1353INSERT INTO patient_symptoms (patient_id, symptom_id) VALUES
1354(1, 1),
1355(1, 2),
1356(1, 5),
1357(2, 3),
1358(2, 4),
1359(3, 6),
1360(3, 2),
1361(4, 7),
1362(4, 5),
1363(5, 8),
1364(5, 9),
1365(6, 1),
1366(6, 6),
1367(7, 10),
1368(7, 5),
1369(8, 3),
1370(8, 9),
1371(9, 4),
1372(9, 2),
1373(10, 11),
1374(10, 5);
1375
1376INSERT INTO diagnosis_symptoms (diagnosis_id, symptom_id) VALUES
1377 (1,1),
1378 (1,2),
1379 (1,5),
1380 (2,3),
1381 (2,4),
1382 (3,6),
1383 (3,2),
1384 (4,7),
1385 (4,5),
1386 (5,8),
1387 (5,9),
1388 (6,1),
1389 (6,6),
1390 (7,10),
1391 (7,5),
1392 (8,3),
1393 (8,9),
1394 (9,4),
1395 (9,2),
1396 (10,11),
1397 (10,5);
1398
1399INSERT INTO specialization_procedures (specialization_id, procedure_id) VALUES
1400 (1,1),
1401 (1,2),
1402 (1,3),
1403 (2,4),
1404 (2,5),
1405 (2,6),
1406 (3,7),
1407 (3,8),
1408 (3,9),
1409 (4,10),
1410 (4,11),
1411 (4,12),
1412 (5,13),
1413 (5,14),
1414 (5,15),
1415 (6,16),
1416 (6,17),
1417 (6,18),
1418 (7,19),
1419 (7,20);
1420
1421INSERT INTO department_procedures (department_id, procedure_id) VALUES
1422 (1,1),
1423 (1,2),
1424 (1,3),
1425 (2,4),
1426 (2,5),
1427 (2,6),
1428 (3,7),
1429 (3,8),
1430 (3,9),
1431 (4,10),
1432 (4,11),
1433 (4,12),
1434 (5,13),
1435 (5,14),
1436 (5,15),
1437 (6,16),
1438 (6,17),
1439 (6,18),
1440 (7,19),
1441 (7,20);
1442
1443INSERT INTO billing_procedures (bill_id, procedure_id) VALUES
1444 (1,1),
1445 (1,2),
1446 (1,3),
1447 (2,4),
1448 (2,5),
1449 (2,6),
1450 (3,7),
1451 (3,8),
1452 (3,9),
1453 (4,10),
1454 (4,11),
1455 (4,12),
1456 (5,13),
1457 (5,14),
1458 (5,15),
1459 (6,16),
1460 (6,17),
1461 (6,18),
1462 (7,19),
1463 (7,20);
1464
1465INSERT INTO billing_lab_tests (bill_id, test_id) VALUES
1466 (1,1),
1467 (1,2),
1468 (1,3),
1469 (2,1),
1470 (2,2),
1471 (2,3),
1472 (3,1),
1473 (3,2),
1474 (4,2),
1475 (4,3),
1476 (5,1),
1477 (5,3),
1478 (6,2),
1479 (6,3),
1480 (7,1),
1481 (7,2),
1482 (8,3),
1483 (9,1),
1484 (10,2);
1485
1486INSERT INTO diagnosis_medical_records (diagnosis_id, record_id) VALUES
1487 (1,1),
1488 (2,2),
1489 (3,3),
1490 (4,4),
1491 (5,5),
1492 (6,6),
1493 (7,7),
1494 (8,8),
1495 (9,9),
1496 (10,10),
1497 (1,11),
1498 (2,12),
1499 (3,13),
1500 (4,14),
1501 (5,15);
1502
1503
1504INSERT INTO prescription_medical_records (prescription_id, record_id, dosage, frequency, duration, notes) VALUES
1505 (1,1,'500mg','Twice daily','7 days','Take after meals'),
1506 (2,2,'250mg','Once daily','5 days','Mild infection treatment'),
1507 (3,3,'10mg','Once daily','10 days','Monitor blood pressure'),
1508 (4,4,'20mg','Once daily','14 days','Use in morning'),
1509 (5,5,'5mg','Twice daily','7 days','Short term therapy'),
1510 (6,6,'1 tablet','Once daily','30 days','Chronic management'),
1511 (7,7,'2 puffs','As needed','14 days','Respiratory relief'),
1512 (8,8,'50mg','Once daily','5 days','Anti-inflammatory'),
1513 (9,9,'100mg','Twice daily','10 days','Pain management'),
1514 (10,10,'1 dose','Once daily','3 days','Acute condition'),
1515 (1,11,'500mg','Twice daily','7 days','Repeat treatment'),
1516 (2,12,'250mg','Once daily','5 days','Follow-up course'),
1517 (3,13,'10mg','Once daily','10 days','Stable condition'),
1518 (4,14,'20mg','Once daily','14 days','Adjusted dosage'),
1519 (5,15,'5mg','Twice daily','7 days','Monitor response');
1520
1521
1522INSERT INTO medical_report_lab_results (report_id, result_id) VALUES
1523 (1,1),
1524 (1,2),
1525 (1,3),
1526 (2,1),
1527 (2,2),
1528 (3,3),
1529 (3,1),
1530 (4,2),
1531 (4,3),
1532 (5,1),
1533 (6,2),
1534 (7,3),
1535 (8,1),
1536 (9,2),
1537 (10,3);
1538
1539INSERT INTO performed_procedures (performed_id, procedure_id, doctor_id, patient_id, diagnosis_id, procedure_date, notes) VALUES
1540 (1,1,1,1,1,'2026-05-01','Routine procedure completed successfully'),
1541 (2,2,1,2,2,'2026-05-02','No complications'),
1542 (3,3,2,3,3,'2026-05-03','Patient stable during procedure'),
1543 (4,4,2,4,4,'2026-05-04','Follow-up recommended'),
1544 (5,5,3,5,5,'2026-05-05','Procedure successful'),
1545 (6,6,3,6,6,'2026-05-06','Mild post-op observation'),
1546 (7,7,4,7,7,'2026-05-07','No issues detected'),
1547 (8,8,4,8,8,'2026-05-08','Standard recovery'),
1548 (9,9,5,9,9,'2026-05-09','Patient responded well'),
1549 (10,10,5,10,10,'2026-05-10','Stable condition'),
1550 (11,11,6,1,1,'2026-05-11','Additional procedure done'),
1551 (12,12,6,2,2,'2026-05-12','Routine check'),
1552 (13,13,7,3,3,'2026-05-13','No complications'),
1553 (14,14,7,4,4,'2026-05-14','Observation required'),
1554 (15,15,8,5,5,'2026-05-15','Procedure completed'),
1555 (16,16,8,6,6,'2026-05-16','Patient recovered well'),
1556 (17,17,9,7,7,'2026-05-17','Stable vitals'),
1557 (18,18,9,8,8,'2026-05-18','Minor discomfort reported'),
1558 (19,19,10,9,9,'2026-05-19','All normal'),
1559 (20,20,10,10,10,'2026-05-20','Discharged after procedure');
1560
1561INSERT INTO performed_lab_tests (performed_test_id, test_id, patient_id, doctor_id, technician_id, test_date, notes) VALUES
1562 (1,1,1,1,1,'2026-05-01','Blood test routine check'),
1563 (2,2,2,2,1,'2026-05-02','Urine infection screening'),
1564 (3,3,3,3,2,'2026-05-03','Hormone imbalance check'),
1565 (4,1,4,1,2,'2026-05-04','CBC follow-up'),
1566 (5,2,5,2,3,'2026-05-05','Urine analysis repeat'),
1567 (6,3,6,3,3,'2026-05-06','Hormone panel evaluation'),
1568 (7,1,7,4,1,'2026-05-07','General blood screening'),
1569 (8,2,8,5,2,'2026-05-08','UTI suspicion test'),
1570 (9,3,9,6,3,'2026-05-09','Endocrine evaluation'),
1571 (10,1,10,7,1,'2026-05-10','Blood count check'),
1572 (11,2,1,8,2,'2026-05-11','Kidney/urine check'),
1573 (12,3,2,9,3,'2026-05-12','Thyroid hormone test'),
1574 (13,1,3,10,1,'2026-05-13','Routine blood panel'),
1575 (14,2,4,1,2,'2026-05-14','Urine follow-up'),
1576 (15,3,5,2,3,'2026-05-15','Hormone monitoring'),
1577 (16,1,6,3,1,'2026-05-16','CBC repeat test'),
1578 (17,2,7,4,2,'2026-05-17','Urine culture'),
1579 (18,3,8,5,3,'2026-05-18','Hormone levels check'),
1580 (19,1,9,6,1,'2026-05-19','Inflammation blood test'),
1581 (20,2,10,7,2,'2026-05-20','Routine urinalysis');
1582
1583INSERT INTO medical_record_lab_results (record_id, result_id) VALUES
1584 (1,1),
1585 (1,2),
1586 (1,3),
1587 (2,1),
1588 (2,2),
1589 (2,3),
1590 (3,1),
1591 (3,2),
1592 (4,1),
1593 (4,2),
1594 (5,3),
1595 (6,1),
1596 (7,2),
1597 (8,3),
1598 (9,1),
1599 (10,2);
1600
1601INSERT INTO medical_record_procedures (record_id, procedure_id) VALUES
1602 (1,1),
1603 (1,2),
1604 (1,3),
1605 (2,4),
1606 (2,5),
1607 (2,6),
1608 (3,7),
1609 (3,8),
1610 (3,9),
1611 (4,10),
1612 (4,11),
1613 (4,12),
1614 (5,13),
1615 (5,14),
1616 (5,15),
1617 (6,16),
1618 (6,17),
1619 (6,18),
1620 (7,19),
1621 (7,20),
1622 (8,1),
1623 (8,2),
1624 (9,3),
1625 (9,4),
1626 (10,5),
1627 (10,6);
1628
1629INSERT INTO medical_record_symptoms (record_id, symptom_id, severity) VALUES
1630 (1,1,'HIGH'),
1631 (1,2,'MEDIUM'),
1632 (1,5,'LOW'),
1633 (2,3,'MEDIUM'),
1634 (2,4,'LOW'),
1635 (3,6,'HIGH'),
1636 (3,2,'MEDIUM'),
1637 (4,7,'HIGH'),
1638 (4,5,'MEDIUM'),
1639 (5,8,'LOW'),
1640 (5,9,'MEDIUM'),
1641 (6,1,'HIGH'),
1642 (6,6,'HIGH'),
1643 (7,10,'MEDIUM'),
1644 (7,5,'LOW'),
1645 (8,3,'MEDIUM'),
1646 (8,9,'LOW'),
1647 (9,4,'MEDIUM'),
1648 (9,2,'LOW'),
1649 (10,11,'LOW'),
1650 (10,5,'MEDIUM');
1651
1652INSERT INTO medical_record_allergies (record_id, allergy_id, reaction, severity) VALUES
1653 (1,1,'Rash','HIGH'),
1654 (1,2,'Swelling','MEDIUM'),
1655 (2,3,'Sneezing','LOW'),
1656 (2,4,'Skin irritation','MEDIUM'),
1657 (3,5,'Coughing','MEDIUM'),
1658 (3,6,'Breathing difficulty','HIGH'),
1659 (4,7,'Nausea','LOW'),
1660 (4,8,'Itching','MEDIUM'),
1661 (5,1,'Hives','HIGH'),
1662 (5,3,'Mild reaction','LOW'),
1663 (6,2,'Swelling','HIGH'),
1664 (6,4,'Skin redness','MEDIUM'),
1665 (7,5,'Respiratory reaction','HIGH'),
1666 (7,6,'Fatigue','MEDIUM'),
1667 (8,7,'Sneezing','LOW'),
1668 (8,8,'Irritation','MEDIUM'),
1669 (9,1,'Rash','MEDIUM'),
1670 (9,2,'Swelling','HIGH'),
1671 (10,3,'Mild itching','LOW'),
1672 (10,4,'Skin reaction','MEDIUM');
1673
1674COMMIT;
Note: See TracBrowser for help on using the repository browser.