BEGIN; INSERT INTO doctor_level (level_id, level) VALUES (1, 'INTERN'), (2, 'RESIDENT'), (3, 'GENERAL_DOCTOR'), (4, 'SPECIALIST'), (5, 'CONSULTANT'); INSERT INTO doctor_specialization (specialization_id, specialization_name) VALUES (1, 'PULMONOLOGY'), (2, 'CARDIOLOGY'), (3, 'NEUROLOGY'), (4, 'ORTHOPEDICS'), (5, 'GYNECOLOGY'), (6, 'ENT'), (7, 'OPHTHALMOLOGY'), (8, 'PATHOLOGY'), (9, 'RADIOLOGY'), (10, 'GASTROENTEROLOGY'), (11, 'UROLOGY'), (12, 'NEPHROLOGY'), (13, 'ONCOLOGY'), (14, 'DERMATOLOGY'), (15, 'PEDIATRICS'), (16, 'PSYCHIATRY'), (17, 'REHABILITATION'), (18, 'HEMATOLOGY'), (19, 'INFECTIOUS_DISEASES'), (20, 'NEUROSURGERY'), (21, 'CARDIAC_SURGERY'), (22, 'PLASTIC_SURGERY'), (23, 'GENERAL_SURGERY'), (24, 'DENTISTRY'), (25, 'ENDOCRINOLOGY'); INSERT INTO departments (department_id, department_name) VALUES (1, 'PULMONOLOGY_DEPT'), (2, 'CARDIOLOGY_DEPT'), (3, 'NEUROLOGY_DEPT'), (4, 'ORTHOPEDICS_DEPT'), (5, 'GYNECOLOGY_DEPT'), (6, 'ENT_DEPT'), (7, 'OPHTHALMOLOGY_DEPT'), (8, 'PATHOLOGY_DEPT'), (9, 'RADIOLOGY_DEPT'), (10, 'GASTROENTEROLOGY_DEPT'), (11, 'UROLOGY_DEPT'), (12, 'NEPHROLOGY_DEPT'), (13, 'ONCOLOGY_DEPT'), (14, 'DERMATOLOGY_DEPT'), (15, 'PEDIATRICS_DEPT'), (16, 'PSYCHIATRY_DEPT'), (17, 'REHABILITATION_DEPT'), (18, 'HEMATOLOGY_DEPT'), (19, 'INFECTIOUS_DISEASES_DEPT'), (20, 'NEUROSURGERY_DEPT'), (21, 'CARDIAC_SURGERY_DEPT'), (22, 'PLASTIC_SURGERY_DEPT'), (23, 'GENERAL_SURGERY_DEPT'), (24, 'DENTISTRY_DEPT'); INSERT INTO allergies (allergy_id, name, allergy_severity) VALUES (1, 'PENICILLIN', 'HIGH'), (2, 'AMOXICILLIN', 'HIGH'), (3, 'ASPIRIN', 'MEDIUM'), (4, 'IBUPROFEN', 'MEDIUM'), (5, 'PARACETAMOL', 'LOW'), (6, 'CODEINE', 'HIGH'), (7, 'MORPHINE', 'CRITICAL'), (8, 'SULFA_DRUGS', 'HIGH'), (9, 'CEPHALOSPORINS', 'HIGH'), (10, 'ANESTHESIA', 'CRITICAL'), (11, 'LIDOCAINE', 'HIGH'), (12, 'CONTRAST_DYE', 'HIGH'), (13, 'PEANUTS', 'CRITICAL'), (14, 'TREE_NUTS', 'CRITICAL'), (15, 'ALMONDS', 'HIGH'), (16, 'WALNUTS', 'HIGH'), (17, 'HAZELNUTS', 'HIGH'), (18, 'CASHEWS', 'HIGH'), (19, 'PISTACHIOS', 'HIGH'), (20, 'SESAME', 'HIGH'), (21, 'MILK', 'MEDIUM'), (22, 'EGGS', 'MEDIUM'), (23, 'WHEAT', 'MEDIUM'), (24, 'GLUTEN', 'MEDIUM'), (25, 'SOY', 'MEDIUM'), (26, 'FISH', 'HIGH'), (27, 'SHELLFISH', 'HIGH'), (28, 'SHRIMP', 'HIGH'), (29, 'CRAB', 'HIGH'), (30, 'LOBSTER', 'HIGH'), (31, 'STRAWBERRIES', 'LOW'), (32, 'KIWI', 'LOW'), (33, 'BANANA', 'LOW'), (34, 'APPLE', 'LOW'), (35, 'CHOCOLATE', 'LOW'), (36, 'CAFFEINE', 'LOW'), (37, 'POLLEN', 'LOW'), (38, 'GRASS_POLLEN', 'LOW'), (39, 'TREE_POLLEN', 'LOW'), (40, 'RAGWEED', 'LOW'), (41, 'DUST_MITES', 'LOW'), (42, 'MOLD', 'MEDIUM'), (43, 'MILDEW', 'MEDIUM'), (44, 'PET_DANDER_CAT', 'MEDIUM'), (45, 'PET_DANDER_DOG', 'MEDIUM'), (46, 'FEATHERS', 'LOW'), (47, 'BEE_VENOM', 'HIGH'), (48, 'WASP_VENOM', 'HIGH'), (49, 'HORNET_VENOM', 'HIGH'), (50, 'FIRE_ANT_STINGS', 'HIGH'), (51, 'LATEX', 'HIGH'), (52, 'NICKEL', 'MEDIUM'), (53, 'COBALT', 'MEDIUM'), (54, 'CHROMIUM', 'MEDIUM'), (55, 'FORMALDEHYDE', 'HIGH'), (56, 'FRAGRANCES', 'MEDIUM'), (57, 'PERFUMES', 'MEDIUM'), (58, 'DETERGENTS', 'MEDIUM'), (59, 'CLEANING_CHEMICALS', 'HIGH'), (60, 'HAIR_DYE', 'MEDIUM'), (61, 'IODINE', 'MEDIUM'), (62, 'MRI_CONTRAST', 'HIGH'), (63, 'CT_CONTRAST', 'HIGH'), (64, 'PLASTER_CAST_MATERIAL', 'LOW'), (65, 'OXYCODONE', 'HIGH'), (66, 'TRAMADOL', 'HIGH'), (67, 'DICLOFENAC', 'MEDIUM'), (68, 'NAPROXEN', 'MEDIUM'), (69, 'AZITHROMYCIN', 'MEDIUM'), (70, 'CLARITHROMYCIN', 'MEDIUM'), (71, 'METRONIDAZOLE', 'MEDIUM'), (72, 'INSULIN', 'HIGH'), (73, 'TOMATOES', 'LOW'), (74, 'POTATOES', 'LOW'), (75, 'CORN', 'LOW'), (76, 'CARROTS', 'LOW'), (77, 'CELERY', 'MEDIUM'), (78, 'ONION', 'LOW'), (79, 'GARLIC', 'LOW'), (80, 'MUSTARD', 'MEDIUM'), (81, 'PEACHES', 'LOW'), (82, 'PEARS', 'LOW'), (83, 'PLUMS', 'LOW'), (84, 'GRAPES', 'LOW'), (85, 'MELON', 'LOW'), (86, 'SMOKE', 'MEDIUM'), (87, 'CIGARETTE_SMOKE', 'MEDIUM'), (88, 'AIRBORNE_CHEMICALS', 'HIGH'), (89, 'POLLUTED_AIR', 'MEDIUM'), (90, 'CAT_DANDER', 'MEDIUM'), (91, 'DOG_DANDER', 'MEDIUM'), (92, 'HORSE_DANDER', 'LOW'), (93, 'PREDNISONE', 'HIGH'), (94, 'HYDROCORTISONE', 'MEDIUM'), (95, 'VACCINE_COMPONENTS', 'HIGH'), (96, 'GLYCERIN', 'LOW'), (97, 'LANOLIN', 'MEDIUM'), (98, 'ALCOHOL_BASED_PRODUCTS', 'MEDIUM'), (99, 'SOAP', 'LOW'), (100, 'SHAMPOO', 'LOW'), (101, 'LATEX_GLOVES', 'HIGH'), (102, 'SURGICAL_ADHESIVES', 'HIGH'), (103, 'DENTAL_MATERIALS', 'MEDIUM'), (104, 'METAL_IMPLANTS', 'HIGH'), (105, 'TITANIUM', 'MEDIUM'), (106, 'STAINLESS_STEEL', 'MEDIUM'), (107, 'PENICILLIN_DERIVATIVES', 'HIGH'), (108, 'VANCOMYCIN', 'HIGH'), (109, 'HEPARIN', 'HIGH'), (110, 'BLOOD_PRODUCTS', 'HIGH'), (111, 'LATEX_BALLOONS', 'HIGH'), (112, 'HOUSE_DUST', 'LOW'), (113, 'WOOD_DUST', 'MEDIUM'), (114, 'PAPER_DUST', 'LOW'), (115, 'TEXTILE_DYES', 'MEDIUM'), (116, 'INKS', 'LOW'), (117, 'GLUE', 'MEDIUM'), (118, 'PAINT_FUMES', 'HIGH'), (119, 'SOLVENTS', 'HIGH'), (120, 'RUBBER', 'HIGH'), (121, 'AMPICILLIN', 'HIGH'), (122, 'PIPERACILLIN', 'HIGH'), (123, 'CEFTRIAXONE', 'HIGH'), (124, 'CEFEPIME', 'HIGH'), (125, 'MEROPENEM', 'CRITICAL'), (126, 'IMIPENEM', 'CRITICAL'), (127, 'ACETAMINOPHEN', 'LOW'), (128, 'DIPHENHYDRAMINE', 'MEDIUM'), (129, 'LORATADINE', 'LOW'), (130, 'CETIRIZINE', 'LOW'), (131, 'IBUPROFEN_HIGH_DOSE', 'MEDIUM'), (132, 'KETOROLAC', 'HIGH'), (133, 'MELOXICAM', 'MEDIUM'), (134, 'CELECOXIB', 'MEDIUM'), (135, 'FENTANYL', 'CRITICAL'), (136, 'METHADONE', 'CRITICAL'), (137, 'BUPRENORPHINE', 'HIGH'), (138, 'PROPOFOL', 'CRITICAL'), (139, 'SEVOFLURANE', 'HIGH'), (140, 'ISOFLURANE', 'HIGH'), (141, 'METFORMIN', 'MEDIUM'), (142, 'INSULIN_ANALOGS', 'HIGH'), (143, 'ATENOLOL', 'MEDIUM'), (144, 'METOPROLOL', 'MEDIUM'), (145, 'LISINOPRIL', 'HIGH'), (146, 'ENALAPRIL', 'HIGH'), (147, 'WARFARIN', 'HIGH'), (148, 'HEPARIN_SODIUM', 'HIGH'), (149, 'SERTRALINE', 'MEDIUM'), (150, 'FLUOXETINE', 'MEDIUM'), (151, 'CITALOPRAM', 'MEDIUM'), (152, 'CISPLATIN', 'CRITICAL'), (153, 'DOXORUBICIN', 'CRITICAL'), (154, 'CYCLOPHOSPHAMIDE', 'CRITICAL'), (155, 'PREDNISOLONE', 'HIGH'), (156, 'DEXAMETHASONE', 'HIGH'), (157, 'ALBUTEROL', 'MEDIUM'), (158, 'SALBUTAMOL', 'MEDIUM'), (159, 'LEVOFLOXACIN', 'HIGH'); INSERT INTO symptoms (symptom_id, name, description) VALUES (1, 'ACID_REFLUX_IN_BABIES', 'Reflux in infants'), (2, 'ACID_REFLUX', 'Stomach acid rising into esophagus'), (3, 'AMNESIA', 'Memory loss'), (4, 'ANAL_PAIN', 'Pain in anal region'), (5, 'ANGER', 'Emotional irritation or rage'), (6, 'ANKLE_PAIN', 'Pain in ankle'), (7, 'SWOLLEN_ANKLES_FEET_LEGS', 'Swelling in lower limbs'), (8, 'ANOSMIA', 'Loss of smell'), (9, 'ITCHY_BOTTOM', 'Itching around anus'), (10, 'ANXIETY', 'Fear and panic symptoms'), (11, 'ARM_PAIN', 'Pain in arm'), (12, 'BACK_PAIN', 'Pain in back'), (13, 'BAD_BREATH', 'Unpleasant mouth odor'), (14, 'BEDWETTING', 'Night-time urination'), (15, 'VOMITING', 'Expulsion of stomach contents'), (16, 'POSTMENOPAUSAL_BLEEDING', 'Bleeding after menopause'), (17, 'BLEEDING_BETWEEN_PERIODS', 'Bleeding between periods'), (18, 'RECTAL_BLEEDING', 'Bleeding from rectum'), (19, 'BLEEDING_IN_PREGNANCY', 'Bleeding during pregnancy'), (20, 'BLOATING', 'Abdominal swelling'), (21, 'BLOOD_IN_PHLEGM', 'Blood in mucus'), (22, 'BLOOD_IN_SEMEN', 'Blood in semen'), (23, 'BLOOD_IN_URINE', 'Blood in urine'), (24, 'CYANOSIS', 'Blue skin or lips'), (25, 'BLUSHING', 'Facial redness'), (26, 'BODY_ODOR', 'Strong smell'), (27, 'BOWEL_INCONTINENCE', 'Loss of bowel control'), (28, 'BREAST_LUMPS', 'Mass in breast'), (29, 'BREAST_PAIN', 'Pain in breast'), (30, 'EXOPHTHALMOS', 'Bulging eyes'), (31, 'CATARRH', 'Excess mucus'), (32, 'CHEST_PAIN', 'Chest pain'), (33, 'COCCYX_PAIN', 'Tailbone pain'), (34, 'CONFUSION', 'Sudden confusion'), (35, 'CONSTIPATION', 'Hard stools'), (36, 'COUGH', 'Cough reflex'), (37, 'COUGHING_BLOOD', 'Blood in cough'), (38, 'DEAFNESS', 'Hearing loss'), (39, 'DEHYDRATION', 'Fluid loss'), (40, 'DELIRIUM', 'Acute confusion'), (41, 'DENTAL_PAIN', 'Tooth pain'), (42, 'DIARRHEA_VOMITING', 'Digestive upset'), (43, 'DIZZINESS', 'Balance disturbance'), (44, 'DOUBLE_VISION', 'Seeing double'), (45, 'DRY_EYES', 'Eye dryness'), (46, 'DRY_LIPS', 'Dry lips'), (47, 'DRY_MOUTH', 'Lack of saliva'), (48, 'DYSPHAGIA', 'Swallowing difficulty'), (49, 'EARACHE', 'Pain in ear'), (50, 'EJACULATION_PROBLEMS', 'Problems with ejaculation'), (51, 'ELBOW_AND_ARM_PAIN', 'Pain in elbow or arm'), (52, 'EXCESSIVE_DAYTIME_SLEEPINESS', 'Abnormal daytime sleepiness'), (53, 'EXCESSIVE_HAIR_GROWTH', 'Increased hair growth'), (54, 'EXCESSIVE_SWEATING', 'High sweating levels'), (55, 'EXCESSIVE_THIRST', 'Increased thirst'), (56, 'FLOATERS_AND_FLASHES', 'Visual disturbances in vision'), (57, 'EYE_PAIN', 'Pain in eye'), (58, 'EYELID_PROBLEMS', 'Problems affecting eyelids'), (59, 'FAINTING', 'Temporary loss of consciousness'), (60, 'FLATULENCE', 'Gas in digestive system'), (61, 'NAUSEA', 'Feeling of sickness'), (62, 'FEVER', 'High body temperature'), (63, 'FINGER_PAIN', 'Pain in fingers'), (64, 'SEIZURES', 'Sudden uncontrolled brain activity'), (65, 'FOOT_PAIN', 'Pain in foot'), (66, 'HAIR_LOSS', 'Hair shedding'), (67, 'HALLUCINATIONS_AND_HEARING_VOICES', 'Perception without stimulus'), (68, 'HAND_PAIN', 'Pain in hand'), (69, 'HEADACHE', 'Pain in head'), (70, 'HEARING_LOSS', 'Reduced hearing ability'), (71, 'HEART_PALPITATIONS', 'Irregular heartbeat sensation'), (72, 'HEARTBURN_AND_ACID_REFLUX', 'Burning chest sensation'), (73, 'HEAVY_PERIODS', 'Excess menstrual bleeding'), (74, 'HEEL_PAIN', 'Pain in heel'), (75, 'HICCUPS', 'Involuntary diaphragm spasms'), (76, 'HIP_PAIN', 'Pain in hip'), (77, 'HIVES', 'Skin rash with itching'), (78, 'INDIGESTION', 'Difficulty digesting food'), (79, 'INSOMNIA', 'Difficulty sleeping'), (80, 'ITCHY_SKIN', 'Skin itching'), (81, 'JOINT_PAIN', 'Pain in joints'), (82, 'KNEE_PAIN', 'Pain in knee'), (83, 'LEG_CRAMPS', 'Muscle cramps in legs'), (84, 'LIMPING', 'Difficulty walking normally'), (85, 'LOW_MOOD', 'Depressive mood state'), (86, 'LUMPS', 'Abnormal tissue swelling'), (87, 'MEMORY_LOSS', 'Difficulty remembering information'), (88, 'METALLIC_TASTE', 'Unusual taste in mouth'), (89, 'MISSED_PERIODS', 'Absent menstrual cycle'), (90, 'NAIL_PROBLEMS', 'Abnormal nails'), (91, 'NECK_PAIN', 'Pain in neck'), (92, 'NIGHT_SWEATS', 'Sweating during sleep'), (93, 'NIPPLE_DISCHARGE', 'Fluid from nipple'), (94, 'OVULATION_PAIN', 'Pain during ovulation'), (95, 'TESTICLE_PAIN', 'Pain in testicles'), (96, 'PAINFUL_PERIODS', 'Pain during menstruation'), (97, 'PARALYSIS', 'Loss of movement'), (98, 'PELVIC_PAIN', 'Pain in pelvic area'), (99, 'PINS_AND_NEEDLES', 'Tingling sensation'), (100, 'PRIAPISM', 'Persistent painful erection'), (101, 'RASH', 'Skin eruption or irritation'), (102, 'RED_EYE', 'Redness in eye'), (103, 'RUNNY_NOSE', 'Nasal discharge'), (104, 'SHORTNESS_OF_BREATH', 'Difficulty breathing'), (105, 'SORE_THROAT', 'Pain in throat'), (106, 'SNEEZING', 'Reflex to clear nasal passages'), (107, 'SNORING', 'Noisy breathing during sleep'), (108, 'STOMACH_PAIN', 'Pain in abdomen'), (109, 'STRESS', 'Mental strain condition'), (110, 'STRETCH_MARKS', 'Skin streaking'), (111, 'SWELLING', 'Abnormal enlargement of tissue'), (112, 'SWOLLEN_GLANDS', 'Enlarged lymph nodes'), (113, 'TASTE_CHANGE', 'Altered taste perception'), (114, 'TREMOR', 'Uncontrolled shaking'), (115, 'TIREDNESS', 'Fatigue'), (116, 'TINNITUS', 'Ringing in ears'), (117, 'TOOTHACHE', 'Pain in teeth'), (118, 'TWITCHING', 'Muscle spasms'), (119, 'UNINTENTIONAL_WEIGHT_LOSS', 'Weight loss without trying'), (120, 'URINARY_INCONTINENCE', 'Loss of bladder control'), (121, 'VAGINAL_BLEEDING', 'Bleeding from vagina'), (122, 'VISION_LOSS', 'Reduced vision ability'), (123, 'VOMITING_BLOOD', 'Blood in vomit'), (124, 'WATERING_EYES', 'Excess tear production'), (125, 'WHEEZING', 'Whistling breathing sound'), (126, 'WRIST_PAIN', 'Pain in wrist'); INSERT INTO doctors (doctor_id, first_name, last_name, email_address, level_id, specialization_id, department_id) VALUES (1, 'Ivan', 'Stojanov', 'ivan.stojanov@medora.com', 1, 1, 1), (2, 'Elena', 'Kirova', 'elena.kirova@medora.com', 2, 1, 1), (3, 'Nikola', 'Trajkov', 'nikola.trajkov@medora.com', 3, 1, 1), (4, 'Sara', 'Dimova', 'sara.dimova@medora.com', 4, 1, 1), (5, 'Marija', 'Bajramceska Karapandzova', 'marija.bajramceska.karapandzova@medora.com', 5, 1, 1), (6, 'Ana', 'Petrova', 'ana.petrova@medora.com', 1, 2, 2), (7, 'Petar', 'Iliev', 'petar.iliev@medora.com', 2, 2, 2), (8, 'Mila', 'Stojanova', 'mila.stojanova@medora.com', 3, 2, 2), (9, 'Dejan', 'Markovski', 'dejan.markovski@medora.com', 4, 2, 2), (10, 'Kristina', 'Todorova', 'kristina.todorova@medora.com', 5, 2, 2), (11, 'Goran', 'Spasov', 'goran.spasov@medora.com', 1, 3, 3), (12, 'Ivana', 'Hristova', 'ivana.hristova@medora.com', 2, 3, 3), (13, 'Bojan', 'Nikolovski', 'bojan.nikolovski@medora.com', 3, 3, 3), (14, 'Tea', 'Angelova', 'tea.angelova@medora.com', 4, 3, 3), (15, 'Filip', 'Jovanov', 'filip.jovanov@medora.com', 5, 3, 3), (16, 'Natasha', 'Petkovska', 'natasha.petkovska@medora.com', 1, 4, 4), (17, 'Viktor', 'Andreev', 'viktor.andreev@medora.com', 2, 4, 4), (18, 'Sofija', 'Marinova', 'sofija.marinova@medora.com', 3, 4, 4), (19, 'Luka', 'Nikolov', 'luka.nikolov@medora.com', 4, 4, 4), (20, 'Marija', 'Damjanova', 'marija.damjanova@medora.com', 5, 4, 4), (21, 'Katerina', 'Ilieva', 'katerina.ilieva@medora.com', 1, 5, 5), (22, 'Dimitar', 'Petrov', 'dimitar.petrov@medora.com', 2, 5, 5), (23, 'Jana', 'Kostova', 'jana.kostova@medora.com', 3, 5, 5), (24, 'Stefan', 'Todorov', 'stefan.todorov@medora.com', 4, 5, 5), (25, 'Elena', 'Markova', 'elena.markova@medora.com', 5, 5, 5), (26, 'Aleksandar', 'Ristovski', 'aleksandar.ristovski@medora.com', 1, 6, 6), (27, 'Ivana', 'Trajkovska', 'ivana.trajkovska@medora.com', 2, 6, 6), (28, 'Goran', 'Nikolov', 'goran.nikolov@medora.com', 3, 6, 6), (29, 'Mila', 'Stojkova', 'mila.stojkova@medora.com', 4, 6, 6), (30, 'Bojan', 'Petrov', 'bojan.petrov@medora.com', 5, 6, 6), (31, 'Petar', 'Angelov', 'petar.angelov@medora.com', 1, 7, 7), (32, 'Ana', 'Dimovska', 'ana.dimovska@medora.com', 2, 7, 7), (33, 'Nikola', 'Kostadinov', 'nikola.kostadinov@medora.com', 3, 7, 7), (34, 'Sara', 'Petrova', 'sara.petrova@medora.com', 4, 7, 7), (35, 'Marko', 'Stojanovski', 'marko.stojanovski@medora.com', 5, 7, 7), (36, 'Elena', 'Markovic', 'elena.markovic@medora.com', 1, 8, 8), (37, 'Ivan', 'Petrovic', 'ivan.petrovic@medora.com', 2, 8, 8), (38, 'Dejan', 'Ilievski', 'dejan.ilievski@medora.com', 3, 8, 8), (39, 'Kristina', 'Ristova', 'kristina.ristova@medora.com', 4, 8, 8), (40, 'Filip', 'Sokolov', 'filip.sokolov@medora.com', 5, 8, 8), (41, 'Goran', 'Spasovski', 'goran.spasovski@medora.com', 1, 9, 9), (42, 'Ivana', 'Hristovska', 'ivana.hristovska@medora.com', 2, 9, 9), (43, 'Bojan', 'Nikolovska', 'bojan.nikolovska@medora.com', 3, 9, 9), (44, 'Tea', 'Angelkovska', 'tea.angelkovska@medora.com', 4, 9, 9), (45, 'Luka', 'Petrovski', 'luka.petrovski@medora.com', 5, 9, 9), (46, 'Marija', 'Ristova', 'marija.ristova@medora.com', 1, 10, 10), (47, 'Viktor', 'Stojanovski', 'viktor.stojanovski@medora.com', 2, 10, 10), (48, 'Sofija', 'Markovska', 'sofija.markovska@medora.com', 3, 10, 10), (49, 'Dimitar', 'Ilievski', 'dimitar.ilievski@medora.com', 4, 10, 10), (50, 'Jana', 'Petrovska', 'jana.petrovska2@medora.com', 5, 10, 10), (51, 'Stefan', 'Nikolov', 'stefan.nikolov@medora.com', 1, 11, 11), (52, 'Elena', 'Trajkovska', 'elena.trajkovska@medora.com', 2, 11, 11), (53, 'Nikola', 'Angelov', 'nikola.angelov@medora.com', 3, 11, 11), (54, 'Sara', 'Dimovska', 'sara.dimovska@medora.com', 4, 11, 11), (55, 'Ivan', 'Kostov', 'ivan.kostov@medora.com', 5, 11, 11), (56, 'Petar', 'Hristov', 'petar.hristov@medora.com', 1, 12, 12), (57, 'Ana', 'Petrovska', 'ana.petrovska3@medora.com', 2, 12, 12), (58, 'Dejan', 'Stojkov', 'dejan.stojkov@medora.com', 3, 12, 12), (59, 'Kristina', 'Ristovska', 'kristina.ristovska@medora.com', 4, 12, 12), (60, 'Goran', 'Nikolovski', 'goran.nikolovski@medora.com', 5, 12, 12), (61, 'Ivana', 'Markov', 'ivana.markov@medora.com', 1, 13, 13), (62, 'Bojan', 'Petrovski', 'bojan.petrovski1@medora.com', 2, 13, 13), (63, 'Tea', 'Ilieva', 'tea.ilieva@medora.com', 3, 13, 13), (64, 'Filip', 'Spasov', 'filip.spasov@medora.com', 4, 13, 13), (65, 'Marija', 'Angelova', 'marija.angelova@medora.com', 5, 13, 13), (66, 'Viktor', 'Kirov', 'viktor.kirov@medora.com', 1, 14, 14), (67, 'Sofija', 'Petrovska', 'sofija.petrovska@medora.com', 2, 14, 14), (68, 'Luka', 'Ristovski', 'luka.ristovski@medora.com', 3, 14, 14), (69, 'Dimitar', 'Markov', 'dimitar.markov@medora.com', 4, 14, 14), (70, 'Jana', 'Nikolova', 'jana.nikolova@medora.com', 5, 14, 14), (71, 'Marko', 'Stojanov', 'marko.stojanov@medora.com', 1, 15, 15), (72, 'Elena', 'Ilievska', 'elena.ilievska@medora.com', 2, 15, 15), (73, 'Nikola', 'Petrov', 'nikola.petrov@medora.com', 3, 15, 15), (74, 'Sara', 'Trajkovska', 'sara.trajkovska@medora.com', 4, 15, 15), (75, 'Ivan', 'Dimov', 'ivan.dimov@medora.com', 5, 15, 15), (76, 'Goran', 'Ristov', 'goran.ristov@medora.com', 1, 16, 16), (77, 'Ivana', 'Kostadinova', 'ivana.kostadinova@medora.com', 2, 16, 16), (78, 'Bojan', 'Petkov', 'bojan.petkov@medora.com', 3, 16, 16), (79, 'Tea', 'Markovska', 'tea.markovska@medora.com', 4, 16, 16), (80, 'Filip', 'Stojanov', 'filip.stojanov@medora.com', 5, 16, 16), (81, 'Marija', 'Hristovska', 'marija.hristovska@medora.com', 1, 17, 17), (82, 'Viktor', 'Iliev', 'viktor.iliev@medora.com', 2, 17, 17), (83, 'Sofija', 'Petrovski', 'sofija.petrovski@medora.com', 3, 17, 17), (84, 'Luka', 'Angelovska', 'luka.angelovska@medora.com', 4, 17, 17), (85, 'Dimitar', 'Kirovski', 'dimitar.kirovski@medora.com', 5, 17, 17), (86, 'Jana', 'Ristova', 'jana.ristova@medora.com', 1, 18, 18), (87, 'Marko', 'Petrovic', 'marko.petrovic@medora.com', 2, 18, 18), (88, 'Elena', 'Stojkovska', 'elena.stojkovska@medora.com', 3, 18, 18), (89, 'Nikola', 'Trajkovic', 'nikola.trajkovic@medora.com', 4, 18, 18), (90, 'Sara', 'Dimkovska', 'sara.dimkovska@medora.com', 5, 18, 18), (91, 'Ivan', 'Spasov', 'ivan.spasov@medora.com', 1, 19, 19), (92, 'Petar', 'Nikolov', 'petar.nikolov@medora.com', 2, 19, 19), (93, 'Ana', 'Markovska', 'ana.markovska@medora.com', 3, 19, 19), (94, 'Dejan', 'Iliev', 'dejan.iliev@medora.com', 4, 19, 19), (95, 'Kristina', 'Petrova', 'kristina.petrova@medora.com', 5, 19, 19), (96, 'Goran', 'Stojanovski', 'goran.stojanovski@medora.com', 1, 20, 20), (97, 'Ivana', 'Hristova', 'ivana.hristova1@medora.com', 2, 20, 20), (98, 'Bojan', 'Kostov', 'bojan.kostov@medora.com', 3, 20, 20), (99, 'Tea', 'Petrovska', 'tea.petrovska@medora.com', 4, 20, 20), (100, 'Filip', 'Ristovski', 'filip.ristovski@medora.com', 5, 20, 20), (101, 'Marija', 'Angelovska', 'marija.angelovska@medora.com', 1, 21, 21), (102, 'Viktor', 'Markovski', 'viktor.markovski@medora.com', 2, 21, 21), (103, 'Sofija', 'Petrova', 'sofija.petrova@medora.com', 3, 21, 21), (104, 'Luka', 'Ilievski', 'luka.ilievski@medora.com', 4, 21, 21), (105, 'Dimitar', 'Stojanov', 'dimitar.stojanov@medora.com', 5, 21, 21), (106, 'Jana', 'Kirovska', 'jana.kirovska@medora.com', 1, 22, 22), (107, 'Marko', 'Petkov', 'marko.petkov@medora.com', 2, 22, 22), (108, 'Elena', 'Ristova', 'elena.ristova@medora.com', 3, 22, 22), (109, 'Nikola', 'Dimov', 'nikola.dimov@medora.com', 4, 22, 22), (110, 'Sara', 'Nikolova', 'sara.nikolova@medora.com', 5, 22, 22), (111, 'Ivan', 'Trajkov', 'ivan.trajkov@medora.com', 1, 23, 23), (112, 'Petar', 'Stojkov', 'petar.stojkov@medora.com', 2, 23, 23), (113, 'Ana', 'Petrovska', 'ana.petrovska1@medora.com', 3, 23, 23), (114, 'Dejan', 'Markov', 'dejan.markov@medora.com', 4, 23, 23), (115, 'Kristina', 'Ilieva', 'kristina.ilieva@medora.com', 5, 23, 23), (116, 'Filip', 'Kostadinov', 'filip.kostadinov@medora.com', 1, 24, 24), (117, 'Ivana', 'Spasova', 'ivana.spasova@medora.com', 2, 24, 24), (118, 'Bojan', 'Petrovski', 'bojan.petrovski2@medora.com', 3, 24, 24), (119, 'Teodora', 'Angelova', 'teodora.angelova@medora.com', 4, 24, 24), (120, 'Mila', 'Lukanovska', 'mila.lukanovska@medora.com', 5, 24, 24); INSERT INTO patients ( patient_id, first_name, last_name, email_address, date_of_birth, blood_type, gender, phone_number, embg ) VALUES (1, 'Maja', 'Veljanova', 'maja.veljanova@gmail.com', '1994-02-14', 'A+', 'FEMALE', '070111222', '1402994123456'), (2, 'Kristijan', 'Bojkov', 'kristijan.bojkov@gmail.com', '1991-06-21', 'O-', 'MALE', '071222333', '2106991123457'), (3, 'Tamara', 'Gorgieva', 'tamara.gorgieva@gmail.com', '2000-11-03', 'B+', 'FEMALE', '072333444', '0311000123458'), (4, 'Aleks', 'Nikolovski', 'aleks.nikolovski@gmail.com', '1988-09-10', 'AB+', 'MALE', '073444555', '1009988123459'), (5, 'Sara', 'Milevska', 'sara.milevska@gmail.com', '1997-12-25', 'A-', 'FEMALE', '074555666', '2512997123460'), (6, 'Stefan', 'Arsovski', 'stefan.arsovski@gmail.com', '1993-04-18', 'O+', 'MALE', '075666777', '1804993123461'), (7, 'Elena', 'Petreska', 'elena.petreska@gmail.com', '1999-07-09', 'B-', 'FEMALE', '076777888', '0907999123462'), (8, 'Viktor', 'Stankov', 'viktor.stankov@gmail.com', '1990-01-30', 'A+', 'MALE', '077888999', '3001990123463'), (9, 'Ivana', 'Dimitrova', 'ivana.dimitrova@gmail.com', '1995-05-12', 'O-', 'FEMALE', '078999111', '1205995123464'), (10, 'Marko', 'Lazarevski', 'marko.lazarevski@gmail.com', '1987-08-22', 'AB-', 'MALE', '070123456', '2208987123465'), (11, 'Jana', 'Trajkovska', 'jana.trajkovska@gmail.com', '2001-03-17', 'A+', 'FEMALE', '071234567', '1703001123466'), (12, 'Petar', 'Kostov', 'petar.kostov@gmail.com', '1992-10-05', 'B+', 'MALE', '072345678', '0510992123467'), (13, 'Ana', 'Ristova', 'ana.ristova@gmail.com', '1996-06-28', 'O+', 'FEMALE', '073456789', '2806996123468'), (14, 'Nikola', 'Sokolov', 'nikola.sokolov@gmail.com', '1989-02-11', 'A-', 'MALE', '074567890', '1102989123469'), (15, 'Mila', 'Petrova', 'mila.petrova@gmail.com', '2002-09-19', 'AB+', 'FEMALE', '075678901', '1909022123470'), (16, 'Dejan', 'Ilievski', 'dejan.ilievski@gmail.com', '1994-11-11', 'O+', 'MALE', '076789012', '1111994123471'), (17, 'Kristina', 'Markovska', 'kristina.markovska@gmail.com', '1998-01-14', 'B+', 'FEMALE', '077890123', '1401988123472'), (18, 'Goran', 'Petrov', 'goran.petrov@gmail.com', '1986-07-07', 'A+', 'MALE', '078901234', '0707986123473'), (19, 'Sofija', 'Nikolova', 'sofija.nikolova@gmail.com', '2000-12-02', 'O-', 'FEMALE', '070112233', '0212000123474'), (20, 'Dimitar', 'Angelov', 'dimitar.angelov@gmail.com', '1991-03-03', 'B-', 'MALE', '071223344', '0303991123475'), (21, 'Teodora', 'Hristova', 'teodora.hristova@gmail.com', '1997-08-08', 'A+', 'FEMALE', '072334455', '0808997123476'), (22, 'Filip', 'Stojanov', 'filip.stojanov@gmail.com', '1993-05-15', 'AB+', 'MALE', '073445566', '1505993123477'), (23, 'Marija', 'Kirovska', 'marija.kirovska@gmail.com', '1999-10-10', 'O+', 'FEMALE', '074556677', '1010999123478'), (24, 'Ivan', 'Bojkov', 'ivan.bojkov@gmail.com', '1988-12-12', 'A-', 'MALE', '075667788', '1212988123479'), (25, 'Lina', 'Petrovska', 'lina.petrovska@gmail.com', '2001-04-04', 'B+', 'FEMALE', '076778899', '0404001123480'), (26, 'Bojan', 'Spasov', 'bojan.spasov@gmail.com', '1992-02-20', 'O+', 'MALE', '077889900', '2002992123481'), (27, 'Ana', 'Dimovska', 'ana.dimovska@gmail.com', '1995-09-09', 'A+', 'FEMALE', '078990011', '0909995123482'), (28, 'Vladimir', 'Ristovski', 'vladimir.ristovski@gmail.com', '1987-06-16', 'AB-', 'MALE', '070998877', '1606987123483'), (29, 'Katerina', 'Todorova', 'katerina.todorova@gmail.com', '2003-01-01', 'O-', 'FEMALE', '071887766', '0101033123484'), (30, 'Martin', 'Iliev', 'martin.iliev@gmail.com', '1990-11-23', 'B+', 'MALE', '072776655', '2311990123485'), (31, 'Elena', 'Trajkov', 'elena.trajkov@gmail.com', '1996-03-13', 'A-', 'FEMALE', '073665544', '1303996123486'), (32, 'Aleksandar', 'Petrovski', 'aleksandar.petrovski@gmail.com', '1994-07-27', 'O+', 'MALE', '074554433', '2707994123487'), (33, 'Maja', 'Stojanovska', 'maja.stojanovska@gmail.com', '1998-09-18', 'B-', 'FEMALE', '075443322', '1809998123488'), (34, 'Nikola', 'Gligorov', 'nikola.gligorov@gmail.com', '1989-05-05', 'A+', 'MALE', '076332211', '0505989123489'), (35, 'Sara', 'Ilieva', 'sara.ilieva@gmail.com', '2002-12-12', 'AB+', 'FEMALE', '077221100', '1212022123490'), (36, 'Petar', 'Markovski', 'petar.markovski@gmail.com', '1993-03-03', 'O+', 'MALE', '078110099', '0303993123491'), (37, 'Ivana', 'Petrovska', 'ivana.petrovska@gmail.com', '1997-07-07', 'A-', 'FEMALE', '070223344', '0707997123492'), (38, 'Goran', 'Nikolovski', 'goran.nikolovski@gmail.com', '1986-10-10', 'B+', 'MALE', '071334455', '1010986123493'), (39, 'Jana', 'Ristova', 'jana.ristova@gmail.com', '2000-01-20', 'O-', 'FEMALE', '072445566', '2001000123494'); INSERT INTO admin ( admin_id, username, name, lastname, email ) VALUES (1, 'admin_ilija', 'Ilija', 'Stojanov', 'ilija.stojanov@adminmedora.com'), (2, 'admin_elena', 'Elena', 'Kirova', 'elena.kirova@adminmedora.com'), (3, 'admin_marjan', 'Marjan', 'Petrov', 'marjan.petrov@adminmedora.com'), (4, 'admin_vesna', 'Vesna', 'Dimova', 'vesna.dimova@adminmedora.com'), (5, 'admin_dushanka', 'Dushanka', 'Trajkovska', 'drushanka.trajkovska@adminmedora.com'); INSERT INTO lab_technician ( technician_id, username, name, lastname, email ) VALUES (1, 'lab_darko', 'Darko', 'Milosev', 'darko.milosev@labmedora.com'), (2, 'lab_biljana', 'Biljana', 'Trajkovska', 'biljana.trajkovska@labmedora.com'), (3, 'lab_stefan', 'Stefan', 'Nikolovski', 'stefan.nikolovski@labmedora.com'), (4, 'lab_marina', 'Marina', 'Petreska', 'marina.petreska@labmedora.com'), (5, 'lab_aleksandar', 'Aleksandar', 'Ristovski', 'aleksandar.ristovski@labmedora.com'); -- Insert users for system admin INSERT INTO users (username, password, role, first_name, last_name, is_active) VALUES ('admin', 'admin123', 'ADMIN', 'System', 'Administrator', true) ON CONFLICT (username) DO NOTHING; -- Insert patient users linked to existing patients INSERT INTO users (username, password, role, first_name, last_name, patient_id, is_active) SELECT p.embg, 'password123', 'PATIENT', p.first_name, p.last_name, p.patient_id, true FROM patients p WHERE NOT EXISTS ( SELECT 1 FROM users u WHERE u.username = p.embg ) LIMIT 39; -- Insert doctor users linked to existing doctors INSERT INTO users (username, password, role, first_name, last_name, doctor_id, is_active) SELECT d.email_address, 'doctor123', 'DOCTOR', d.first_name, d.last_name, d.doctor_id, true FROM doctors d WHERE NOT EXISTS ( SELECT 1 FROM users u WHERE u.username = d.email_address ); -- Insert admin users linked to existing admins INSERT INTO users (username, password, role, first_name, last_name, is_active) SELECT a.username, 'admin123', 'ADMIN', a.name, a.lastname, true FROM admin a WHERE NOT EXISTS ( SELECT 1 FROM users u WHERE u.username = a.username ); -- Insert lab technician users linked to existing lab technicians INSERT INTO users (username, password, role, first_name, last_name, is_active) SELECT lt.username, 'lab123', 'LAB_TECHNICIAN', lt.name, lt.lastname, true FROM lab_technician lt WHERE NOT EXISTS ( SELECT 1 FROM users u WHERE u.username = lt.username ); INSERT INTO appointments ( appointment_id, appointment_date, appointment_time, status, patient_id, doctor_id ) VALUES (1, '2026-01-10', '09:00:00', 'SCHEDULED', 1, 6), (2, '2026-01-10', '09:30:00', 'COMPLETED', 2, 12), (3, '2026-01-11', '10:00:00', 'COMPLETED', 3, 18), (4, '2026-01-11', '10:30:00', 'CANCELLED', 4, 24), (5, '2026-01-12', '11:00:00', 'SCHEDULED', 5, 31), (6, '2026-01-12', '11:30:00', 'COMPLETED', 6, 37), (7, '2026-01-13', '12:00:00', 'IN_PROGRESS', 7, 43), (8, '2026-01-13', '12:30:00', 'SCHEDULED', 8, 49), (9, '2026-01-14', '13:00:00', 'COMPLETED', 9, 55), (10, '2026-01-14', '13:30:00', 'SCHEDULED', 10, 61); INSERT INTO diagnosis (diagnosis_id, name, description, patient_id, doctor_id) VALUES (1, 'Essential hypertension', 'Persistent high blood pressure', 1, 1), (2, 'Type 2 diabetes mellitus', 'Chronic glucose metabolism disorder', 1, 1), (3, 'Acute bronchitis', 'Inflammation of bronchial tubes', 1, 1), (4, 'Asthma', 'Chronic airway inflammation', 1, 1), (5, 'Pneumonia', 'Lung infection', 1, 1), (6, 'Chronic obstructive pulmonary disease', 'Progressive lung disease', 1, 1), (7, 'Migraine', 'Recurrent severe headaches', 1, 1), (8, 'Epilepsy', 'Neurological seizure disorder', 1, 1), (9, 'Parkinson disease', 'Neurodegenerative movement disorder', 1, 1), (10, 'Alzheimer disease', 'Progressive cognitive decline', 1, 1), (11, 'Osteoarthritis', 'Degenerative joint disease', 1, 1), (12, 'Rheumatoid arthritis', 'Autoimmune joint inflammation', 1, 1), (13, 'Fracture of femur', 'Bone fracture of thigh', 1, 1), (14, 'Lumbar disc herniation', 'Spinal disc displacement', 1, 1), (15, 'Scoliosis', 'Abnormal spine curvature', 1, 1), (16, 'Gastritis', 'Stomach lining inflammation', 1, 1), (17, 'Peptic ulcer disease', 'Ulcer in stomach or duodenum', 1, 1), (18, 'Gastroesophageal reflux disease', 'Acid reflux disorder', 1, 1), (19, 'Appendicitis', 'Inflammation of appendix', 1, 1), (20, 'Cholelithiasis', 'Gallstones', 1, 1), (21, 'Acute kidney injury', 'Sudden kidney failure', 1, 1), (22, 'Chronic kidney disease', 'Long-term kidney damage', 1, 1), (23, 'Urinary tract infection', 'Bacterial urinary infection', 1, 1), (24, 'Nephrotic syndrome', 'Kidney protein loss disorder', 1, 1), (25, 'Kidney stone', 'Renal calculus', 1, 1), (26, 'Breast cancer', 'Malignant tumor of breast', 1, 1), (27, 'Lung cancer', 'Malignant lung tumor', 1, 1), (28, 'Leukemia', 'Blood cancer', 1, 1), (29, 'Lymphoma', 'Lymphatic system cancer', 1, 1), (30, 'Skin melanoma', 'Malignant skin tumor', 1, 1), (31, 'Atopic dermatitis', 'Chronic skin inflammation', 1, 1), (32, 'Psoriasis', 'Autoimmune skin disorder', 1, 1), (33, 'Acne vulgaris', 'Inflammatory skin condition', 1, 1), (34, 'Urticaria', 'Allergic skin reaction', 1, 1), (35, 'Cellulitis', 'Bacterial skin infection', 1, 1), (36, 'Influenza', 'Viral respiratory infection', 1, 1), (37, 'COVID-19', 'Coronavirus infection', 1, 1), (38, 'Hepatitis B', 'Liver viral infection', 1, 1), (39, 'Hepatitis C', 'Chronic liver infection', 1, 1), (40, 'Tuberculosis', 'Mycobacterial infection', 1, 1), (41, 'Anemia', 'Low red blood cell count', 1, 1), (42, 'Iron deficiency anemia', 'Lack of iron in blood', 1, 1), (43, 'Hemophilia', 'Blood clotting disorder', 1, 1), (44, 'Thrombocytopenia', 'Low platelet count', 1, 1), (45, 'Deep vein thrombosis', 'Blood clot in deep veins', 1, 1), (46, 'Pulmonary embolism', 'Blocked lung artery', 1, 1), (47, 'Hyperthyroidism', 'Overactive thyroid gland', 1, 1), (48, 'Hypothyroidism', 'Underactive thyroid gland', 1, 1), (49, 'Cushing syndrome', 'Excess cortisol production', 1, 1), (50, 'Addison disease', 'Adrenal insufficiency', 1, 1), (51, 'Depression', 'Mood disorder', 1, 1), (52, 'Anxiety disorder', 'Chronic anxiety condition', 1, 1), (53, 'Bipolar disorder', 'Mood instability disorder', 1, 1), (54, 'Schizophrenia', 'Psychotic disorder', 1, 1), (55, 'Insomnia', 'Sleep disorder', 1, 1), (56, 'Sleep apnea', 'Breathing interruption during sleep', 1, 1), (57, 'Otitis media', 'Middle ear infection', 1, 1), (58, 'Tonsillitis', 'Tonsil inflammation', 1, 1), (59, 'Sinusitis', 'Sinus infection', 1, 1), (60, 'Hearing loss', 'Reduced hearing ability', 1, 1), (61, 'Cataract', 'Eye lens clouding', 1, 1), (62, 'Glaucoma', 'Optic nerve damage', 1, 1), (63, 'Macular degeneration', 'Retinal deterioration', 1, 1), (64, 'Conjunctivitis', 'Eye inflammation', 1, 1), (65, 'Dry eye syndrome', 'Insufficient tear production', 1, 1), (66, 'Obesity', 'Excess body fat', 1, 1), (67, 'Metabolic syndrome', 'Cluster of metabolic disorders', 1, 1), (68, 'Hyperlipidemia', 'High cholesterol levels', 1, 1), (69, 'Vitamin D deficiency', 'Low vitamin D levels', 1, 1), (70, 'Osteoporosis', 'Bone density loss', 1, 1), (71, 'Gout', 'Uric acid crystal arthritis', 1, 1), (72, 'Fibromyalgia', 'Chronic pain disorder', 1, 1), (73, 'Multiple sclerosis', 'Autoimmune nerve disorder', 1, 1), (74, 'Myocardial infarction', 'Heart attack', 1, 1), (75, 'Heart failure', 'Reduced heart pumping function', 1, 1), (76, 'Arrhythmia', 'Irregular heartbeat', 1, 1), (77, 'Cardiomyopathy', 'Heart muscle disease', 1, 1), (78, 'Endocarditis', 'Heart infection', 1, 1), (79, 'Pericarditis', 'Heart lining inflammation', 1, 1), (80, 'Atherosclerosis', 'Artery plaque buildup', 1, 1), (81, 'Sepsis', 'Systemic infection response', 1, 1), (82, 'Meningitis', 'Brain membrane infection', 1, 1), (83, 'Encephalitis', 'Brain inflammation', 1, 1), (84, 'Stroke', 'Brain blood flow interruption', 1, 1), (85, 'Transient ischemic attack', 'Mini-stroke', 1, 1), (86, 'Pancreatitis', 'Pancreas inflammation', 1, 1), (87, 'Liver cirrhosis', 'Chronic liver damage', 1, 1), (88, 'Fatty liver disease', 'Fat accumulation in liver', 1, 1), (89, 'Cholecystitis', 'Gallbladder inflammation', 1, 1), (90, 'Hernia', 'Organ protrusion through muscle', 1, 1), (91, 'Eczema', 'Skin inflammation', 1, 1), (92, 'Dermatitis', 'General skin irritation', 1, 1), (93, 'Allergic rhinitis', 'Nasal allergy', 1, 1), (94, 'Food allergy reaction', 'Immune response to food', 1, 1), (95, 'Drug allergy reaction', 'Adverse medication reaction', 1, 1), (96, 'Anaphylaxis', 'Severe allergic reaction', 1, 1), (97, 'Heat stroke', 'Overheating condition', 1, 1), (98, 'Hypothermia', 'Low body temperature', 1, 1), (99, 'Dehydration', 'Fluid loss condition', 1, 1), (100, 'Electrolyte imbalance', 'Disturbed mineral levels', 1, 1), (101, 'Hypertensive crisis', 'Severely elevated blood pressure emergency', 1, 1), (102, 'Stable angina', 'Chest pain due to reduced blood flow', 1, 1), (103, 'Unstable angina', 'Acute coronary syndrome symptom', 1, 1), (104, 'Atrial fibrillation', 'Irregular heart rhythm', 1, 1), (105, 'Ventricular tachycardia', 'Fast abnormal heart rhythm', 1, 1), (106, 'Bronchiectasis', 'Permanent airway dilation', 1, 1), (107, 'Pleural effusion', 'Fluid in lung cavity', 1, 1), (108, 'Pneumothorax', 'Collapsed lung', 1, 1), (109, 'Pulmonary fibrosis', 'Lung tissue scarring', 1, 1), (110, 'Respiratory failure', 'Inadequate oxygen exchange', 1, 1), (111, 'Bell palsy', 'Facial nerve paralysis', 1, 1), (112, 'Trigeminal neuralgia', 'Facial nerve pain disorder', 1, 1), (113, 'Carpal tunnel syndrome', 'Median nerve compression', 1, 1), (114, 'Peripheral neuropathy', 'Nerve damage disorder', 1, 1), (115, 'Restless legs syndrome', 'Uncontrolled leg movement urge', 1, 1), (116, 'Cervical spondylosis', 'Neck spine degeneration', 1, 1), (117, 'Spinal stenosis', 'Narrowing of spinal canal', 1, 1), (118, 'Sciatica', 'Sciatic nerve pain', 1, 1), (119, 'Tension headache', 'Muscle contraction headache', 1, 1), (120, 'Cluster headache', 'Severe recurring headaches', 1, 1), (121, 'Crohn disease', 'Inflammatory bowel disease', 1, 1), (122, 'Ulcerative colitis', 'Colon inflammation disease', 1, 1), (123, 'Irritable bowel syndrome', 'Functional bowel disorder', 1, 1), (124, 'Celiac disease', 'Gluten intolerance disorder', 1, 1), (125, 'Lactose intolerance', 'Milk sugar digestion disorder', 1, 1), (126, 'Hemorrhoids', 'Swollen rectal veins', 1, 1), (127, 'Anal fissure', 'Small tear in anal lining', 1, 1), (128, 'Diverticulitis', 'Colon pouch inflammation', 1, 1), (129, 'Intestinal obstruction', 'Blocked bowel passage', 1, 1), (130, 'Peritonitis', 'Abdominal cavity infection', 1, 1), (131, 'Prostatitis', 'Prostate gland inflammation', 1, 1), (132, 'Benign prostatic hyperplasia', 'Prostate enlargement', 1, 1), (133, 'Erectile dysfunction', 'Male sexual dysfunction', 1, 1), (134, 'End stage renal disease', 'Kidney failure stage 5', 1, 1), (135, 'Glomerulonephritis', 'Kidney filter inflammation', 1, 1), (136, 'Pyelonephritis', 'Kidney infection', 1, 1), (137, 'Bladder cancer', 'Malignant bladder tumor', 1, 1), (138, 'Testicular torsion', 'Twisted testicle condition', 1, 1), (139, 'Ovarian cyst', 'Fluid-filled ovary sac', 1, 1), (140, 'Endometriosis', 'Uterine tissue outside uterus', 1, 1), (141, 'Thyroid nodule', 'Thyroid gland lump', 1, 1), (142, 'Goiter', 'Thyroid enlargement', 1, 1), (143, 'Hyperparathyroidism', 'Excess parathyroid hormone', 1, 1), (144, 'Hypoparathyroidism', 'Low parathyroid function', 1, 1), (145, 'Diabetic ketoacidosis', 'Diabetes metabolic emergency', 1, 1), (146, 'Hypoglycemia', 'Low blood sugar', 1, 1), (147, 'Hyperglycemia', 'High blood sugar', 1, 1), (148, 'Metabolic acidosis', 'Excess acid in blood', 1, 1), (149, 'Respiratory acidosis', 'CO2 buildup in blood', 1, 1), (150, 'Respiratory alkalosis', 'Low CO2 in blood', 1, 1), (151, 'Septic shock', 'Severe infection-induced shock', 1, 1), (152, 'Systemic inflammatory response syndrome', 'Body-wide inflammation', 1, 1), (153, 'Bacterial meningitis', 'Bacterial brain infection', 1, 1), (154, 'Viral meningitis', 'Viral brain infection', 1, 1), (155, 'Hepatic encephalopathy', 'Liver-related brain dysfunction', 1, 1), (156, 'Alcoholic liver disease', 'Alcohol-related liver damage', 1, 1), (157, 'Cholangitis', 'Bile duct infection', 1, 1), (158, 'Pancreatic necrosis', 'Severe pancreatic tissue death', 1, 1), (159, 'Gastroenteritis', 'Stomach and intestinal infection', 1, 1), (160, 'Food poisoning', 'Toxin or bacteria ingestion illness', 1, 1), (161, 'Psoriatic arthritis', 'Joint inflammation from psoriasis', 1, 1), (162, 'Systemic lupus erythematosus', 'Autoimmune systemic disease', 1, 1), (163, 'Scleroderma', 'Skin hardening autoimmune disease', 1, 1), (164, 'Vasculitis', 'Blood vessel inflammation', 1, 1), (165, 'Raynaud disease', 'Blood flow restriction in extremities', 1, 1), (166, 'Cellulitis of leg', 'Skin bacterial infection in leg', 1, 1), (167, 'Impetigo', 'Contagious skin infection', 1, 1), (168, 'Herpes simplex infection', 'Viral skin infection', 1, 1), (169, 'Shingles', 'Reactivation of chickenpox virus', 1, 1), (170, 'Warts', 'HPV skin growths', 1, 1), (171, 'Vitamin B12 deficiency', 'Low B12 levels', 1, 1), (172, 'Folate deficiency', 'Low folic acid levels', 1, 1), (173, 'Scurvy', 'Vitamin C deficiency disease', 1, 1), (174, 'Rickets', 'Vitamin D deficiency in children', 1, 1), (175, 'Osteomalacia', 'Softening of bones', 1, 1), (176, 'Hypercalcemia', 'High calcium levels', 1, 1), (177, 'Hypocalcemia', 'Low calcium levels', 1, 1), (178, 'Hyponatremia', 'Low sodium levels', 1, 1), (179, 'Hypernatremia', 'High sodium levels', 1, 1), (180, 'Hypokalemia', 'Low potassium levels', 1, 1), (181, 'Hyperkalemia', 'High potassium levels', 1, 1), (182, 'Heat exhaustion', 'Heat-related illness', 1, 1), (183, 'Frostbite', 'Cold-induced tissue damage', 1, 1), (184, 'Carbon monoxide poisoning', 'Toxic gas exposure', 1, 1), (185, 'Drug overdose', 'Excess medication intake', 1, 1), (186, 'Alcohol poisoning', 'Toxic alcohol levels', 1, 1), (187, 'Snake bite', 'Venomous bite injury', 1, 1), (188, 'Animal bite infection', 'Infected bite wound', 1, 1), (189, 'Tetanus', 'Bacterial muscle stiffness disease', 1, 1), (190, 'Rabies exposure', 'Viral bite exposure', 1, 1), (191, 'Acute stress disorder', 'Short-term trauma response', 1, 1), (192, 'Post-traumatic stress disorder', 'Long-term trauma disorder', 1, 1), (193, 'Panic disorder', 'Sudden anxiety attacks', 1, 1), (194, 'Social anxiety disorder', 'Fear of social situations', 1, 1), (195, 'Obsessive compulsive disorder', 'Repetitive thoughts/behavior', 1, 1), (196, 'Attention deficit hyperactivity disorder', 'Attention regulation disorder', 1, 1), (197, 'Autism spectrum disorder', 'Neurodevelopmental condition', 1, 1), (198, 'Intellectual disability', 'Cognitive impairment condition', 1, 1), (199, 'Sleepwalking', 'Parasomnia disorder', 1, 1), (200, 'Night terrors', 'Severe sleep disturbance', 1, 1); INSERT INTO procedures (procedure_id, procedure_type, procedure_date, description, cost, doctor_id, diagnosis_id) VALUES (1, 'Spirometry', '2026-01-10', 'Lung function test measuring airflow', 50, 1, 4), (2, 'Bronchoscopy', '2026-01-10', 'Endoscopic examination of airways', 200, 1, 4), (3, 'Body plethysmography', '2026-01-11', 'Measurement of lung volumes', 180, 1, 5), (4, 'Diffusion capacity test (DLCO)', '2026-01-11', 'Gas exchange efficiency test', 120, 1, 106), (5, 'Peak flow measurement', '2026-01-12', 'Maximum exhalation speed test', 30, 1, 4), (6, 'Blood gas analysis', '2026-01-12', 'Oxygen and CO2 level test', 70, 1, 5), (7, 'Allergy testing', '2026-01-13', 'Identification of respiratory allergens', 90, 2, 94), (8, 'Bronchodilator test', '2026-01-13', 'Asthma response test after medication', 80, 1, 4), (9, 'ECG', '2026-01-14', 'Electrical heart activity recording', 40, 2, 74), (10, 'Echocardiography', '2026-01-14', 'Ultrasound of the heart', 120, 2, 75), (11, 'Stress test', '2026-01-15', 'Heart performance under exercise', 100, 2, 74), (12, 'Holter ECG', '2026-01-15', '24h heart rhythm monitoring', 150, 2, 76), (13, 'Blood pressure Holter', '2026-01-16', '24h blood pressure monitoring', 140, 2, 1), (14, 'Cardiac catheterization', '2026-01-16', 'Invasive heart vessel examination', 600, 2, 74), (15, 'Coronary angiography', '2026-01-17', 'Imaging of coronary arteries', 700, 2, 74), (16, 'Transesophageal echo', '2026-01-17', 'Internal heart ultrasound', 300, 2, 75), (17, 'EEG', '2026-01-18', 'Brain electrical activity test', 100, 3, 7), (18, 'EMG', '2026-01-18', 'Muscle electrical activity test', 120, 3, 113), (19, 'Evoked potentials', '2026-01-19', 'Nerve response measurement', 130, 3, 113), (20, 'Lumbar puncture', '2026-01-19', 'CSF fluid collection from spine', 250, 3, 82), (21, 'Nerve conduction study', '2026-01-20', 'Nerve signal speed test', 110, 3, 113), (22, 'Carotid Doppler', '2026-01-20', 'Blood flow in neck arteries', 140, 3, 84), (23, 'Arthroscopy', '2026-01-21', 'Joint inspection using camera', 500, 4, 11), (24, 'Hip replacement', '2026-01-21', 'Surgical hip joint replacement', 5000, 4, 11), (25, 'Knee replacement', '2026-01-22', 'Surgical knee joint replacement', 4800, 4, 11), (26, 'Fracture fixation', '2026-01-22', 'Bone stabilization surgery', 1200, 4, 13), (27, 'Ligament reconstruction', '2026-01-23', 'Repair of torn ligaments', 2500, 4, 11), (28, 'Spine surgery', '2026-01-23', 'Surgical spinal intervention', 6000, 4, 14), (29, 'Gynecological ultrasound', '2026-01-24', 'Ultrasound of female reproductive system', 80, 5, 139), (30, 'Pap smear', '2026-01-24', 'Cervical cancer screening test', 60, 5, 31), (31, 'Colposcopy', '2026-01-25', 'Detailed cervix examination', 120, 5, 31), (32, 'Hysteroscopy', '2026-01-25', 'Uterine cavity inspection', 300, 5, 140), (33, 'Laparoscopy', '2026-01-26', 'Minimally invasive abdominal surgery', 700, 5, 139), (34, 'Cesarean section', '2026-01-26', 'Surgical delivery of baby', 1500, 5, 34), (35, 'Delivery', '2026-01-27', 'Natural childbirth', 800, 5, 35), (36, 'Cervical biopsy', '2026-01-27', 'Tissue sampling from cervix', 200, 5, 30), (37, 'Audiometry', '2026-01-28', 'Hearing test', 50, 6, 60), (38, 'Tympanometry', '2026-01-28', 'Middle ear function test', 60, 6, 57), (39, 'Nasal endoscopy', '2026-01-29', 'Nasal cavity examination', 120, 6, 59), (40, 'Laryngoscopy', '2026-01-29', 'Throat and voice box examination', 130, 6, 58), (41, 'Tonsillectomy', '2026-01-30', 'Removal of tonsils', 400, 6, 58), (42, 'Sinus surgery', '2026-01-30', 'Surgical sinus treatment', 1200, 6, 59), (43, 'Vision exam', '2026-02-01', 'Eye vision testing', 40, 7, 60), (44, 'Optical coherence tomography', '2026-02-01', 'Retina imaging', 150, 7, 63), (45, 'Perimetry', '2026-02-02', 'Visual field test', 70, 7, 62), (46, 'Cataract surgery', '2026-02-02', 'Lens replacement surgery', 2000, 7, 61), (47, 'Laser eye surgery', '2026-02-03', 'Vision correction procedure', 2500, 7, 61), (48, 'Complete blood count', '2026-02-03', 'Basic blood analysis', 30, 8, 41), (49, 'Biochemistry panel', '2026-02-04', 'Blood chemical analysis', 50, 8, 2), (50, 'Coagulation tests', '2026-02-04', 'Blood clotting tests', 60, 8, 43), (51, 'Hormone tests', '2026-02-05', 'Hormonal level analysis', 80, 8, 47), (52, 'Microbiology tests', '2026-02-05', 'Infection detection tests', 90, 8, 40), (53, 'PCR test', '2026-02-06', 'DNA/RNA detection test', 100, 8, 36), (54, 'X-ray', '2026-02-06', 'Basic imaging scan', 50, 9, 13), (55, 'CT scan', '2026-02-07', 'Cross-sectional imaging', 200, 9, 13), (56, 'MRI', '2026-02-07', 'Magnetic resonance imaging', 350, 9, 7), (57, 'Ultrasound', '2026-02-08', 'Sound wave imaging', 70, 9, 139), (58, 'Mammography', '2026-02-08', 'Breast imaging', 120, 9, 26), (59, 'Interventional radiology', '2026-02-09', 'Image-guided procedures', 800, 9, 74), (60, 'Gastroscopy', '2026-02-09', 'Stomach camera examination', 200, 10, 16), (61, 'Colonoscopy', '2026-02-10', 'Colon examination', 300, 10, 121), (62, 'Biopsy', '2026-02-10', 'Tissue sampling', 250, 10, 26), (63, 'ERCP', '2026-02-11', 'Bile duct procedure', 600, 10, 20), (64, 'Abdominal ultrasound', '2026-02-11', 'Abdominal organ imaging', 90, 9, 19), (65, 'Urinary tract ultrasound', '2026-02-12', 'Kidney and bladder imaging', 90, 9, 23), (66, 'Cystoscopy', '2026-02-12', 'Bladder examination', 200, 11, 23), (67, 'Urodynamic testing', '2026-02-13', 'Urine flow analysis', 150, 11, 134), (68, 'Lithotripsy', '2026-02-13', 'Kidney stone breaking', 500, 11, 25), (69, 'TURP', '2026-02-14', 'Prostate surgery', 1200, 11, 131), (70, 'Prostate biopsy', '2026-02-14', 'Prostate tissue sampling', 250, 11, 131), (71, 'Hemodialysis', '2026-02-15', 'Blood cleaning procedure', 200, 12, 22), (72, 'Peritoneal dialysis', '2026-02-15', 'Abdominal dialysis', 180, 12, 22), (73, 'Kidney biopsy', '2026-02-16', 'Kidney tissue sampling', 300, 12, 21), (74, 'Renal clearance tests', '2026-02-16', 'Kidney function tests', 100, 12, 22), (75, 'Electrolyte tests', '2026-02-17', 'Blood mineral analysis', 60, 12, 100), (76, 'Chemotherapy', '2026-02-17', 'Cancer drug treatment', 2000, 13, 26), (77, 'Radiotherapy', '2026-02-18', 'Radiation cancer treatment', 2500, 13, 27), (78, 'Tumor biopsy', '2026-02-18', 'Cancer tissue sampling', 400, 13, 26), (79, 'PET scan', '2026-02-19', 'Cancer imaging scan', 900, 9, 26), (80, 'Immunotherapy', '2026-02-19', 'Immune cancer treatment', 3000, 13, 28), (81, 'Dermatological exam', '2026-02-20', 'Skin examination', 50, 14, 31), (82, 'Dermatoscopy', '2026-02-20', 'Skin lesion imaging', 80, 14, 30), (83, 'Skin biopsy', '2026-02-21', 'Skin tissue sampling', 200, 14, 31), (84, 'Cryotherapy', '2026-02-21', 'Freezing skin treatment', 150, 14, 34), (85, 'Laser treatments', '2026-02-22', 'Skin laser therapy', 500, 14, 34), (86, 'Pediatric exam', '2026-02-22', 'Child medical checkup', 60, 15, 1), (87, 'Vaccination', '2026-02-23', 'Immunization procedure', 40, 15, 1), (88, 'Neonatal screening', '2026-02-23', 'Newborn testing', 100, 15, 1), (89, 'Growth assessment', '2026-02-24', 'Child development check', 50, 15, 1), (90, 'Psychiatric evaluation', '2026-02-24', 'Mental health assessment', 120, 16, 51), (91, 'Psychotherapy', '2026-02-25', 'Therapy sessions', 100, 16, 51), (92, 'Cognitive testing', '2026-02-25', 'Brain function testing', 80, 16, 54), (93, 'Pharmacotherapy', '2026-02-26', 'Psychiatric medication treatment', 150, 16, 51), (94, 'Physiotherapy', '2026-02-26', 'Physical rehabilitation treatment', 80, 17, 11), (95, 'Kinesiotherapy', '2026-02-27', 'Movement-based therapy', 90, 17, 11), (96, 'Electrotherapy', '2026-02-27', 'Electrical stimulation therapy', 70, 17, 72), (97, 'Hydrotherapy', '2026-02-28', 'Water-based rehabilitation therapy', 100, 17, 72), (98, 'Blood count', '2026-03-01', 'Detailed blood cell analysis', 40, 8, 41), (99, 'Bone marrow biopsy', '2026-03-01', 'Bone marrow sampling', 400, 8, 43), (100, 'Coagulation studies', '2026-03-02', 'Blood clotting analysis', 80, 8, 43), (101, 'Blood transfusion', '2026-03-02', 'Transfer of blood products', 300, 8, 45), (102, 'Serology tests', '2026-03-03', 'Antibody detection tests', 90, 8, 36), (103, 'PCR diagnostics', '2026-03-03', 'Molecular infection detection', 120, 8, 40), (104, 'Microbial cultures', '2026-03-04', 'Bacteria growth testing', 100, 8, 40), (105, 'Antibiotic therapy', '2026-03-04', 'Infection treatment with antibiotics', 200, 1, 40), (106, 'Brain surgery', '2026-03-05', 'Surgical brain intervention', 8000, 3, 82), (107, 'Spine surgery', '2026-03-05', 'Surgical spinal operation', 7000, 4, 117), (108, 'Tumor removal', '2026-03-06', 'Removal of brain tumors', 9000, 3, 82), (109, 'Shunt procedure', '2026-03-06', 'CSF drainage surgery', 6000, 3, 82), (110, 'CABG', '2026-03-07', 'Heart bypass surgery', 10000, 2, 74), (111, 'Valve replacement', '2026-03-07', 'Heart valve surgery', 9500, 2, 75), (112, 'Pacemaker implantation', '2026-03-08', 'Heart rhythm device installation', 5000, 2, 76), (113, 'Reconstructive surgery', '2026-03-08', 'Restoration of body structures', 4000, 4, 35), (114, 'Cosmetic surgery', '2026-03-09', 'Aesthetic body improvement', 3500, 14, 33), (115, 'Liposuction', '2026-03-09', 'Fat removal procedure', 3000, 14, 66), (116, 'Rhinoplasty', '2026-03-10', 'Nose reshaping surgery', 3200, 6, 35), (117, 'Appendectomy', '2026-03-10', 'Appendix removal surgery', 1500, 10, 19), (118, 'Hernia repair', '2026-03-11', 'Hernia correction surgery', 1800, 10, 90), (119, 'Gallbladder removal', '2026-03-11', 'Cholecystectomy procedure', 2000, 10, 20), (120, 'Surgical biopsy', '2026-03-12', 'Tissue sampling surgery', 900, 13, 26), (121, 'Tooth extraction', '2026-03-12', 'Removal of tooth', 100, 18, 35), (122, 'Dental filling', '2026-03-13', 'Cavity repair', 120, 18, 35), (123, 'Dental implants', '2026-03-13', 'Artificial tooth implantation', 1500, 18, 35), (124, 'Teeth cleaning', '2026-03-14', 'Dental plaque removal', 80, 18, 35); INSERT INTO procedure_results (result_id, result_description, result_date, procedure_id) VALUES (1, 'Normal lung capacity detected', '2026-01-10', 1), (2, 'Mild airway obstruction observed', '2026-01-11', 2), (3, 'Reduced diffusion capacity detected', '2026-01-12', 4), (4, 'Elevated blood pressure during stress test', '2026-01-13', 11), (5, 'Normal cardiac rhythm recorded', '2026-01-14', 9), (6, 'Abnormal EEG activity detected', '2026-01-15', 17), (7, 'Reduced nerve conduction velocity', '2026-01-16', 21), (8, 'Successful fracture stabilization', '2026-01-17', 26), (9, 'Normal cervical screening result', '2026-01-18', 30), (10, 'Moderate hearing loss detected', '2026-01-19', 37), (11, 'Cataract successfully removed', '2026-01-20', 46), (12, 'Elevated glucose levels detected', '2026-01-21', 48), (13, 'No abnormalities on CT scan', '2026-01-22', 55), (14, 'Gallstones successfully removed', '2026-01-23', 119), (15, 'Kidney stones fragmented successfully', '2026-01-24', 68), (16, 'Tumor biopsy confirmed malignant cells', '2026-01-25', 78), (17, 'Skin lesion benign after biopsy', '2026-01-26', 83), (18, 'Patient responded well to physiotherapy', '2026-01-27', 94), (19, 'Successful pacemaker implantation', '2026-01-28', 112), (20, 'Dental implant integrated successfully', '2026-01-29', 123); INSERT INTO prescriptions (prescription_id, medication_name) VALUES (1, 'Paracetamol'), (2, 'Ibuprofen'), (3, 'Amoxicillin'), (4, 'Azithromycin'), (5, 'Ciprofloxacin'), (6, 'Metformin'), (7, 'Insulin Glargine'), (8, 'Atorvastatin'), (9, 'Simvastatin'), (10, 'Omeprazole'), (11, 'Pantoprazole'), (12, 'Ranitidine'), (13, 'Lisinopril'), (14, 'Amlodipine'), (15, 'Losartan'), (16, 'Bisoprolol'), (17, 'Salbutamol'), (18, 'Fluticasone'), (19, 'Montelukast'), (20, 'Cetirizine'), (21, 'Loratadine'), (22, 'Dexamethasone'), (23, 'Prednisone'), (24, 'Hydrocortisone'), (25, 'Diclofenac'), (26, 'Naproxen'), (27, 'Tramadol'), (28, 'Morphine'), (29, 'Codeine'), (30, 'Diazepam'), (31, 'Lorazepam'), (32, 'Alprazolam'), (33, 'Sertraline'), (34, 'Fluoxetine'), (35, 'Citalopram'), (36, 'Escitalopram'), (37, 'Quetiapine'), (38, 'Risperidone'), (39, 'Haloperidol'), (40, 'Levodopa'), (41, 'Carbidopa'), (42, 'Donepezil'), (43, 'Memantine'), (44, 'Gabapentin'), (45, 'Pregabalin'), (46, 'Carbamazepine'), (47, 'Valproic acid'), (48, 'Lamotrigine'), (49, 'Clopidogrel'), (50, 'Aspirin'), (51, 'Warfarin'), (52, 'Heparin'), (53, 'Enoxaparin'), (54, 'Furosemide'), (55, 'Spironolactone'), (56, 'Hydrochlorothiazide'), (57, 'Digoxin'), (58, 'Nitroglycerin'), (59, 'Isosorbide mononitrate'), (60, 'Sildenafil'), (61, 'Tamsulosin'), (62, 'Finasteride'), (63, 'Dutasteride'), (64, 'Levothyroxine'), (65, 'Methimazole'), (66, 'Propylthiouracil'), (67, 'Metoclopramide'), (68, 'Ondansetron'), (69, 'Loperamide'), (70, 'Lactulose'), (71, 'Rifaximin'), (72, 'Metronidazole'), (73, 'Vancomycin'), (74, 'Linezolid'), (75, 'Doxycycline'), (76, 'Tetracycline'), (77, 'Clarithromycin'), (78, 'Erythromycin'), (79, 'Nystatin'), (80, 'Fluconazole'), (81, 'Ketoconazole'), (82, 'Aciclovir'), (83, 'Valaciclovir'), (84, 'Oseltamivir'), (85, 'Zanamivir'), (86, 'Ribavirin'), (87, 'Interferon alfa'), (88, 'Methotrexate'), (89, 'Cyclophosphamide'), (90, 'Cisplatin'), (91, 'Doxorubicin'), (92, 'Imatinib'), (93, 'Trastuzumab'), (94, 'Bevacizumab'), (95, 'Epoetin alfa'), (96, 'Filgrastim'), (97, 'Calcium carbonate'), (98, 'Vitamin D3'), (99, 'Iron sulfate'), (100, 'Magnesium sulfate'); INSERT INTO prescription_restriction (restriction_id, description, prescription_id) VALUES (1, 'Avoid use in patients with severe liver disease', 1), (2, 'Do not exceed maximum daily dose', 1), (3, 'Avoid in patients with active stomach ulcer', 2), (4, 'Use with caution in elderly patients', 2), (5, 'Contraindicated in penicillin allergy', 3), (6, 'Avoid in patients with severe kidney impairment', 5), (7, 'Monitor blood glucose regularly', 6), (8, 'Risk of hypoglycemia if meals are skipped', 7), (9, 'Not recommended during pregnancy', 8), (10, 'Avoid grapefruit juice consumption', 8), (11, 'May cause stomach irritation', 10), (12, 'Take before meals for better absorption', 10), (13, 'Do not stop abruptly without doctor supervision', 14), (14, 'Monitor blood pressure regularly', 15), (15, 'May cause dizziness or fatigue', 16), (16, 'Use with caution in asthma patients', 17), (17, 'Avoid sudden discontinuation', 18), (18, 'May cause drowsiness', 19), (19, 'Do not drive after administration', 30), (20, 'Avoid alcohol consumption', 30), (21, 'Risk of dependency with long-term use', 31), (22, 'Use only for short-term treatment', 31), (23, 'May increase suicidal thoughts in young patients', 33), (24, 'Requires regular liver function monitoring', 34), (25, 'Can cause weight gain', 37), (26, 'Avoid in Parkinson disease patients', 39), (27, 'May cause tremors or rigidity worsening', 40), (28, 'Monitor heart rate regularly', 49), (29, 'Risk of bleeding increases with NSAIDs', 50), (30, 'Avoid in pregnancy unless necessary', 51); INSERT INTO lab_tests (test_id, test_name, description, cost) VALUES (1, 'Blood test', 'General blood analysis', 30), (2, 'Urine test', 'Urinalysis examination', 25), (3, 'Hormone test', 'Endocrine hormone evaluation', 80); INSERT INTO lab_results (result_id, results, result_date, test_id) VALUES (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), (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), (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), (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 ug/dL | DHEA-S 280 ug/dL | Insulin 8 uIU/mL | Prolactin 12 ng/mL | AMH 3.1 ng/mL', '2026-05-10', 3), (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 ug/dL | DHEA-S 180 ug/dL | Insulin 14 uIU/mL | Prolactin 18 ng/mL | AMH 1.8 ng/mL', '2026-05-09', 3), (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 ug/dL | DHEA-S 320 ug/dL | Insulin 6 uIU/mL | Prolactin 10 ng/mL | AMH 4.0 ng/mL', '2026-05-08', 3), (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), (7, 'pH 5.5 | Specific gravity 1.030 | Trace protein | Glucose negative | Ketones negative | WBC 5-10/hpf | Mild bacteriuria', '2026-05-09', 2), (8, 'pH 6.2 | Specific gravity 1.015 | Protein negative | Glucose negative | Ketones negative | Normal sediment', '2026-05-08', 2), (9, 'pH 5.8 | Specific gravity 1.025 | Leukocytes ++ | Nitrites positive | Bacteria present | UTI suspected', '2026-05-07', 2), (10, 'pH 6.0 | Specific gravity 1.018 | RBC trace | Protein negative | Glucose negative | Further evaluation required', '2026-05-06', 2); INSERT INTO medical_records (record_id, patient_id) VALUES (1, 1), (2, 2), (3, 3), (4, 4), (5, 5), (6, 6), (7, 7), (8, 8), (9, 9), (10, 10), (11, 11), (12, 12), (13, 13), (14, 14), (15, 15); INSERT INTO referrals (referral_id, reason, referral_date, record_id, from_doctor_id, to_doctor_id) VALUES (1, 'Suspected cardiac condition requiring specialist evaluation', '2026-05-10', 3, 1, 5), (2, 'Neurological symptoms and recurrent headaches', '2026-05-09', 6, 2, 8), (3, 'Persistent respiratory issues for pulmonology review', '2026-05-08', 1, 3, 6), (4, 'Orthopedic follow-up for post-surgery assessment', '2026-05-07', 4, 4, 7), (5, 'Suspected endocrine disorder requiring hormone testing', '2026-05-06', 10, 5, 9), (6, 'Dermatological evaluation for chronic skin rash', '2026-05-05', 8, 6, 10), (7, 'Pediatric developmental concern check', '2026-05-04', 7, 7, 11), (8, 'Gastrointestinal pain requiring endoscopy', '2026-05-03', 9, 8, 12), (9, 'Abnormal lab results requiring hematology review', '2026-05-02', 10, 9, 13), (10, 'Possible kidney dysfunction requiring nephrology assessment', '2026-05-01', 10, 10, 14); INSERT INTO medical_report (report_id, description, report_date, record_id, doctor_id) VALUES (1, 'Pulmonary function assessment confirms mild asthma. Recommended inhaler therapy.', '2026-05-10', 1, 3), (2, 'Cardiology report indicates elevated blood pressure and possible hypertension.', '2026-05-09', 2, 1), (3, 'Neurological evaluation shows no acute abnormalities. Follow-up recommended.', '2026-05-08', 6, 2), (4, 'Orthopedic post-surgery report shows stable recovery and good mobility.', '2026-05-07', 4, 4), (5, 'Gynecological report: normal ultrasound findings, no pathological changes.', '2026-05-06', 5, 5), (6, 'Dermatology report confirms allergic dermatitis. Topical treatment prescribed.', '2026-05-05', 8, 6), (7, 'Pediatric assessment: normal growth and development indicators.', '2026-05-04', 7, 7), (8, 'Gastroenterology report suggests possible gastritis. Further endoscopy advised.', '2026-05-03', 9, 8), (9, 'Laboratory review indicates mild iron deficiency anemia.', '2026-05-02', 10, 9), (10, 'Nephrology report suggests early signs of reduced kidney function.', '2026-05-01', 10, 10); INSERT INTO billing (bill_id, total_cost, payment_status, payment_date, record_id, admin_id) VALUES (1, 230, 'PAID', '2026-05-11', 1, 1), (2, 340, 'PENDING', NULL, 2, 1), (3, 900, 'PAID', '2026-05-10', 3, 2), (4, 5200, 'PAID', '2026-05-09', 4, 1), (5, 180, 'PAID', '2026-05-08', 5, 3), (6, 420, 'PENDING', NULL, 6, 2), (7, 160, 'PAID', '2026-05-07', 7, 3), (8, 780, 'PENDING', NULL, 8, 1), (9, 250, 'PAID', '2026-05-06', 9, 2), (10, 610, 'PENDING', NULL, 10, 3); INSERT INTO patient_allergies (patient_id, allergy_id) VALUES (1, 1), (1, 3), (2, 2), (2, 5), (3, 4), (4, 1), (4, 6), (5, 3), (5, 2), (6, 7), (7, 5), (7, 8), (8, 4), (8, 1), (9, 6), (10, 2); INSERT INTO allergy_prescription_restrictions (allergy_id, restriction_id) VALUES (1, 1), (1, 2), (2, 3), (2, 4), (3, 5), (4, 6), (5, 5), (6, 7), (6, 8), (7, 3), (7, 9), (8, 10), (1, 6), (2, 6), (3, 10); INSERT INTO patient_symptoms (patient_id, symptom_id) VALUES (1, 1), (1, 2), (1, 5), (2, 3), (2, 4), (3, 6), (3, 2), (4, 7), (4, 5), (5, 8), (5, 9), (6, 1), (6, 6), (7, 10), (7, 5), (8, 3), (8, 9), (9, 4), (9, 2), (10, 11), (10, 5); INSERT INTO diagnosis_symptoms (diagnosis_id, symptom_id) VALUES (1,1), (1,2), (1,5), (2,3), (2,4), (3,6), (3,2), (4,7), (4,5), (5,8), (5,9), (6,1), (6,6), (7,10), (7,5), (8,3), (8,9), (9,4), (9,2), (10,11), (10,5); INSERT INTO specialization_procedures (specialization_id, procedure_id) VALUES (1,1), (1,2), (1,3), (2,4), (2,5), (2,6), (3,7), (3,8), (3,9), (4,10), (4,11), (4,12), (5,13), (5,14), (5,15), (6,16), (6,17), (6,18), (7,19), (7,20); INSERT INTO diagnosis_procedures (diagnosis_id, procedure_id) VALUES (1,1), (1,2), (2,3), (2,4), (3,5), (3,6), (4,7), (4,8), (5,9), (5,10), (6,11), (6,12), (7,13), (7,14), (8,15), (8,16), (9,17), (9,18), (10,19), (10,20); INSERT INTO department_procedures (department_id, procedure_id) VALUES (1,1), (1,2), (1,3), (2,4), (2,5), (2,6), (3,7), (3,8), (3,9), (4,10), (4,11), (4,12), (5,13), (5,14), (5,15), (6,16), (6,17), (6,18), (7,19), (7,20); INSERT INTO billing_procedures (bill_id, procedure_id) VALUES (1,1), (1,2), (1,3), (2,4), (2,5), (2,6), (3,7), (3,8), (3,9), (4,10), (4,11), (4,12), (5,13), (5,14), (5,15), (6,16), (6,17), (6,18), (7,19), (7,20); INSERT INTO billing_lab_tests (bill_id, test_id) VALUES (1,1), (1,2), (1,3), (2,1), (2,2), (2,3), (3,1), (3,2), (4,2), (4,3), (5,1), (5,3), (6,2), (6,3), (7,1), (7,2), (8,3), (9,1), (10,2); INSERT INTO doctor_medical_records (doctor_id, record_id) VALUES (1,1), (1,2), (1,3), (2,4), (2,5), (2,6), (3,7), (3,8), (3,9), (4,10), (4,11), (5,12), (5,13), (6,14), (6,15); INSERT INTO diagnosis_medical_records (diagnosis_id, record_id) VALUES (1,1), (2,2), (3,3), (4,4), (5,5), (6,6), (7,7), (8,8), (9,9), (10,10), (1,11), (2,12), (3,13), (4,14), (5,15); INSERT INTO prescription_medical_records (prescription_id, record_id, dosage, frequency, duration, notes) VALUES (1,1,'500mg','Twice daily','7 days','Take after meals'), (2,2,'250mg','Once daily','5 days','Mild infection treatment'), (3,3,'10mg','Once daily','10 days','Monitor blood pressure'), (4,4,'20mg','Once daily','14 days','Use in morning'), (5,5,'5mg','Twice daily','7 days','Short term therapy'), (6,6,'1 tablet','Once daily','30 days','Chronic management'), (7,7,'2 puffs','As needed','14 days','Respiratory relief'), (8,8,'50mg','Once daily','5 days','Anti-inflammatory'), (9,9,'100mg','Twice daily','10 days','Pain management'), (10,10,'1 dose','Once daily','3 days','Acute condition'), (1,11,'500mg','Twice daily','7 days','Repeat treatment'), (2,12,'250mg','Once daily','5 days','Follow-up course'), (3,13,'10mg','Once daily','10 days','Stable condition'), (4,14,'20mg','Once daily','14 days','Adjusted dosage'), (5,15,'5mg','Twice daily','7 days','Monitor response'); INSERT INTO medical_report_lab_results (report_id, result_id) VALUES (1,1), (1,2), (1,3), (2,1), (2,2), (3,3), (3,1), (4,2), (4,3), (5,1), (6,2), (7,3), (8,1), (9,2), (10,3); INSERT INTO performed_procedures (performed_id, procedure_id, doctor_id, patient_id, diagnosis_id, procedure_date, notes) VALUES (1,1,1,1,1,'2026-05-01','Routine procedure completed successfully'), (2,2,1,2,2,'2026-05-02','No complications'), (3,3,2,3,3,'2026-05-03','Patient stable during procedure'), (4,4,2,4,4,'2026-05-04','Follow-up recommended'), (5,5,3,5,5,'2026-05-05','Procedure successful'), (6,6,3,6,6,'2026-05-06','Mild post-op observation'), (7,7,4,7,7,'2026-05-07','No issues detected'), (8,8,4,8,8,'2026-05-08','Standard recovery'), (9,9,5,9,9,'2026-05-09','Patient responded well'), (10,10,5,10,10,'2026-05-10','Stable condition'), (11,11,6,1,1,'2026-05-11','Additional procedure done'), (12,12,6,2,2,'2026-05-12','Routine check'), (13,13,7,3,3,'2026-05-13','No complications'), (14,14,7,4,4,'2026-05-14','Observation required'), (15,15,8,5,5,'2026-05-15','Procedure completed'), (16,16,8,6,6,'2026-05-16','Patient recovered well'), (17,17,9,7,7,'2026-05-17','Stable vitals'), (18,18,9,8,8,'2026-05-18','Minor discomfort reported'), (19,19,10,9,9,'2026-05-19','All normal'), (20,20,10,10,10,'2026-05-20','Discharged after procedure'); INSERT INTO performed_lab_tests (performed_test_id, test_id, patient_id, doctor_id, technician_id, test_date, notes) VALUES (1,1,1,1,1,'2026-05-01','Blood test routine check'), (2,2,2,2,1,'2026-05-02','Urine infection screening'), (3,3,3,3,2,'2026-05-03','Hormone imbalance check'), (4,1,4,1,2,'2026-05-04','CBC follow-up'), (5,2,5,2,3,'2026-05-05','Urine analysis repeat'), (6,3,6,3,3,'2026-05-06','Hormone panel evaluation'), (7,1,7,4,1,'2026-05-07','General blood screening'), (8,2,8,5,2,'2026-05-08','UTI suspicion test'), (9,3,9,6,3,'2026-05-09','Endocrine evaluation'), (10,1,10,7,1,'2026-05-10','Blood count check'), (11,2,1,8,2,'2026-05-11','Kidney/urine check'), (12,3,2,9,3,'2026-05-12','Thyroid hormone test'), (13,1,3,10,1,'2026-05-13','Routine blood panel'), (14,2,4,1,2,'2026-05-14','Urine follow-up'), (15,3,5,2,3,'2026-05-15','Hormone monitoring'), (16,1,6,3,1,'2026-05-16','CBC repeat test'), (17,2,7,4,2,'2026-05-17','Urine culture'), (18,3,8,5,3,'2026-05-18','Hormone levels check'), (19,1,9,6,1,'2026-05-19','Inflammation blood test'), (20,2,10,7,2,'2026-05-20','Routine urinalysis'); INSERT INTO medical_record_lab_results (record_id, result_id) VALUES (1,1), (1,2), (1,3), (2,1), (2,2), (2,3), (3,1), (3,2), (4,1), (4,2), (5,3), (6,1), (7,2), (8,3), (9,1), (10,2); INSERT INTO medical_record_procedures (record_id, procedure_id) VALUES (1,1), (1,2), (1,3), (2,4), (2,5), (2,6), (3,7), (3,8), (3,9), (4,10), (4,11), (4,12), (5,13), (5,14), (5,15), (6,16), (6,17), (6,18), (7,19), (7,20), (8,1), (8,2), (9,3), (9,4), (10,5), (10,6); INSERT INTO medical_record_symptoms (record_id, symptom_id, severity) VALUES (1,1,'HIGH'), (1,2,'MEDIUM'), (1,5,'LOW'), (2,3,'MEDIUM'), (2,4,'LOW'), (3,6,'HIGH'), (3,2,'MEDIUM'), (4,7,'HIGH'), (4,5,'MEDIUM'), (5,8,'LOW'), (5,9,'MEDIUM'), (6,1,'HIGH'), (6,6,'HIGH'), (7,10,'MEDIUM'), (7,5,'LOW'), (8,3,'MEDIUM'), (8,9,'LOW'), (9,4,'MEDIUM'), (9,2,'LOW'), (10,11,'LOW'), (10,5,'MEDIUM'); INSERT INTO medical_record_allergies (record_id, allergy_id, reaction, severity) VALUES (1,1,'Rash','HIGH'), (1,2,'Swelling','MEDIUM'), (2,3,'Sneezing','LOW'), (2,4,'Skin irritation','MEDIUM'), (3,5,'Coughing','MEDIUM'), (3,6,'Breathing difficulty','HIGH'), (4,7,'Nausea','LOW'), (4,8,'Itching','MEDIUM'), (5,1,'Hives','HIGH'), (5,3,'Mild reaction','LOW'), (6,2,'Swelling','HIGH'), (6,4,'Skin redness','MEDIUM'), (7,5,'Respiratory reaction','HIGH'), (7,6,'Fatigue','MEDIUM'), (8,7,'Sneezing','LOW'), (8,8,'Irritation','MEDIUM'), (9,1,'Rash','MEDIUM'), (9,2,'Swelling','HIGH'), (10,3,'Mild itching','LOW'), (10,4,'Skin reaction','MEDIUM'); COMMIT;