- Timestamp:
- 09/24/26 12:09:29 (10 hours ago)
- Branches:
- master
- Parents:
- ae6cd79
- Location:
- sql
- Files:
-
- 2 edited
Legend:
- Unmodified
- Added
- Removed
-
sql/ddl.sql
rae6cd79 r48d2bed 1 2 1 BEGIN; 3 2 … … 11 10 DROP TABLE IF EXISTS prescription_medical_records CASCADE; 12 11 DROP TABLE IF EXISTS diagnosis_medical_records CASCADE; 13 DROP TABLE IF EXISTS doctor_medical_records CASCADE;14 12 DROP TABLE IF EXISTS billing_lab_tests CASCADE; 15 13 DROP TABLE IF EXISTS billing_procedures CASCADE; 16 14 DROP TABLE IF EXISTS department_procedures CASCADE; 17 DROP TABLE IF EXISTS diagnosis_procedures CASCADE;18 15 DROP TABLE IF EXISTS specialization_procedures CASCADE; 19 16 DROP TABLE IF EXISTS diagnosis_symptoms CASCADE; … … 43 40 DROP TABLE IF EXISTS doctor_specialization CASCADE; 44 41 DROP TABLE IF EXISTS doctor_level CASCADE; 45 46 47 42 DROP TABLE IF EXISTS users CASCADE; 43 44 45 -- USERS & ROLES --------------------------------------------------------- 46 47 CREATE TABLE users ( 48 user_id SERIAL PRIMARY KEY, 49 username VARCHAR(255) NOT NULL UNIQUE, 50 password VARCHAR(255) NOT NULL, 51 role VARCHAR(50) NOT NULL, 52 first_name VARCHAR(100), 53 last_name VARCHAR(100), 54 is_active BOOLEAN DEFAULT true 55 ); 56 57 58 -- STAFF ------------------------------------------------------------------- 48 59 49 60 CREATE TABLE doctor_level ( 50 51 52 53 54 55 56 57 61 level_id BIGINT, 62 level TEXT NOT NULL, 63 64 CONSTRAINT doctor_level_PK 65 PRIMARY KEY (level_id), 66 67 CONSTRAINT doctor_level_level_UQ 68 UNIQUE (level) 58 69 ); 59 70 60 71 CREATE TABLE doctor_specialization ( 61 62 63 64 65 66 67 68 72 specialization_id BIGINT, 73 specialization_name TEXT NOT NULL, 74 75 CONSTRAINT doctor_specialization_PK 76 PRIMARY KEY (specialization_id), 77 78 CONSTRAINT doctor_specialization_name_UQ 79 UNIQUE (specialization_name) 69 80 ); 70 81 71 82 72 83 CREATE TABLE departments ( 73 74 75 76 77 78 79 80 84 department_id BIGINT, 85 department_name TEXT NOT NULL, 86 87 CONSTRAINT departments_PK 88 PRIMARY KEY (department_id), 89 90 CONSTRAINT departments_name_UQ 91 UNIQUE (department_name) 81 92 ); 82 93 83 94 CREATE TABLE doctors ( 84 doctor_id BIGINT, 85 86 first_name TEXT NOT NULL, 87 last_name TEXT NOT NULL, 88 89 email_address TEXT NOT NULL, 90 91 level_id BIGINT NOT NULL, 92 specialization_id BIGINT NOT NULL, 93 department_id BIGINT NOT NULL, 94 95 CONSTRAINT doctors_PK 96 PRIMARY KEY (doctor_id), 97 98 CONSTRAINT doctors_email_UQ 99 UNIQUE (email_address), 100 101 CONSTRAINT doctors_email_chk 102 CHECK (email_address LIKE '%@%'), 103 104 CONSTRAINT doctors_level_FK 105 FOREIGN KEY (level_id) 106 REFERENCES doctor_level(level_id) 107 ON DELETE RESTRICT, 108 109 CONSTRAINT doctors_specialization_FK 110 FOREIGN KEY (specialization_id) 111 REFERENCES doctor_specialization(specialization_id) 112 ON DELETE RESTRICT, 113 114 CONSTRAINT doctors_department_FK 115 FOREIGN KEY (department_id) 116 REFERENCES departments(department_id) 117 ON DELETE RESTRICT 118 ); 119 120 95 doctor_id BIGINT, 96 97 first_name TEXT NOT NULL, 98 last_name TEXT NOT NULL, 99 100 email_address TEXT NOT NULL, 101 102 level_id BIGINT NOT NULL, 103 specialization_id BIGINT NOT NULL, 104 department_id BIGINT NOT NULL, 105 106 user_id BIGINT NOT NULL, 107 108 CONSTRAINT doctors_PK 109 PRIMARY KEY (doctor_id), 110 111 CONSTRAINT doctors_email_UQ 112 UNIQUE (email_address), 113 114 CONSTRAINT doctors_email_chk 115 CHECK (email_address LIKE '%@%'), 116 117 CONSTRAINT doctors_user_UQ 118 UNIQUE (user_id), 119 120 CONSTRAINT doctors_level_FK 121 FOREIGN KEY (level_id) 122 REFERENCES doctor_level(level_id) 123 ON DELETE RESTRICT, 124 125 CONSTRAINT doctors_specialization_FK 126 FOREIGN KEY (specialization_id) 127 REFERENCES doctor_specialization(specialization_id) 128 ON DELETE RESTRICT, 129 130 CONSTRAINT doctors_department_FK 131 FOREIGN KEY (department_id) 132 REFERENCES departments(department_id) 133 ON DELETE RESTRICT, 134 135 CONSTRAINT doctors_user_FK 136 FOREIGN KEY (user_id) 137 REFERENCES users(user_id) 138 ON DELETE RESTRICT 139 ); 140 141 CREATE TABLE admin ( 142 admin_id BIGINT, 143 144 username TEXT NOT NULL, 145 name TEXT NOT NULL, 146 lastname TEXT NOT NULL, 147 148 email TEXT NOT NULL, 149 150 user_id BIGINT NOT NULL, 151 152 CONSTRAINT admin_PK 153 PRIMARY KEY (admin_id), 154 155 CONSTRAINT admin_username_UQ 156 UNIQUE (username), 157 158 CONSTRAINT admin_email_UQ 159 UNIQUE (email), 160 161 CONSTRAINT admin_email_chk 162 CHECK (email LIKE '%@adminmedora%'), 163 164 CONSTRAINT admin_user_UQ 165 UNIQUE (user_id), 166 167 CONSTRAINT admin_user_FK 168 FOREIGN KEY (user_id) 169 REFERENCES users(user_id) 170 ON DELETE RESTRICT 171 ); 172 173 CREATE TABLE lab_technician ( 174 technician_id BIGINT, 175 176 username TEXT NOT NULL, 177 name TEXT NOT NULL, 178 lastname TEXT NOT NULL, 179 180 email TEXT NOT NULL, 181 182 user_id BIGINT NOT NULL, 183 184 CONSTRAINT lab_technician_PK 185 PRIMARY KEY (technician_id), 186 187 CONSTRAINT lab_technician_username_UQ 188 UNIQUE (username), 189 190 CONSTRAINT lab_technician_email_UQ 191 UNIQUE (email), 192 193 CONSTRAINT lab_technician_email_chk 194 CHECK (email LIKE '%@labmedora%'), 195 196 CONSTRAINT lab_technician_user_UQ 197 UNIQUE (user_id), 198 199 CONSTRAINT lab_technician_user_FK 200 FOREIGN KEY (user_id) 201 REFERENCES users(user_id) 202 ON DELETE RESTRICT 203 ); 204 205 206 -- PATIENTS ------------------------------------------------------------------ 121 207 122 208 CREATE TABLE patients ( 123 patient_id BIGINT, 124 125 first_name TEXT NOT NULL, 126 last_name TEXT NOT NULL, 127 128 email_address TEXT, 129 date_of_birth DATE NOT NULL, 130 131 blood_type TEXT, 132 gender TEXT, 133 134 phone_number TEXT, 135 embg TEXT NOT NULL, 136 137 CONSTRAINT patients_PK 138 PRIMARY KEY (patient_id), 139 140 CONSTRAINT patients_email_UQ 141 UNIQUE (email_address), 142 143 CONSTRAINT patients_embg_UQ 144 UNIQUE (embg), 145 146 CONSTRAINT patients_gender_chk 147 CHECK (gender IN ('MALE', 'FEMALE')), 148 149 CONSTRAINT patients_blood_type_chk 150 CHECK ( 151 blood_type IN ( 152 'A+', 'A-', 153 'B+', 'B-', 154 'AB+', 'AB-', 155 'O+', 'O-' 156 ) 157 ) 158 ); 159 160 CREATE TABLE admin ( 161 admin_id BIGINT, 162 163 username TEXT NOT NULL, 164 name TEXT NOT NULL, 165 lastname TEXT NOT NULL, 166 167 email TEXT NOT NULL, 168 169 CONSTRAINT admin_PK 170 PRIMARY KEY (admin_id), 171 172 CONSTRAINT admin_username_UQ 173 UNIQUE (username), 174 175 CONSTRAINT admin_email_UQ 176 UNIQUE (email), 177 178 CONSTRAINT admin_email_chk 179 CHECK (email LIKE '%@adminmedora%') 180 ); 181 182 CREATE TABLE lab_technician ( 183 technician_id BIGINT, 184 185 username TEXT NOT NULL, 186 name TEXT NOT NULL, 187 lastname TEXT NOT NULL, 188 189 email TEXT NOT NULL, 190 191 CONSTRAINT lab_technician_PK 192 PRIMARY KEY (technician_id), 193 194 CONSTRAINT lab_technician_username_UQ 195 UNIQUE (username), 196 197 CONSTRAINT lab_technician_email_UQ 198 UNIQUE (email), 199 200 CONSTRAINT lab_technician_email_chk 201 CHECK (email LIKE '%@labmedora%') 202 ); 203 204 209 patient_id BIGINT, 210 211 first_name TEXT NOT NULL, 212 last_name TEXT NOT NULL, 213 214 email_address TEXT, 215 date_of_birth DATE NOT NULL, 216 217 blood_type TEXT, 218 gender TEXT, 219 220 phone_number TEXT, 221 embg TEXT NOT NULL, 222 223 user_id BIGINT NOT NULL, 224 225 CONSTRAINT patients_PK 226 PRIMARY KEY (patient_id), 227 228 CONSTRAINT patients_email_UQ 229 UNIQUE (email_address), 230 231 CONSTRAINT patients_embg_UQ 232 UNIQUE (embg), 233 234 CONSTRAINT patients_embg_format_chk 235 CHECK (embg ~ '^[0-9]{13}$'), 236 237 CONSTRAINT patients_gender_chk 238 CHECK (gender IN ('MALE', 'FEMALE')), 239 240 CONSTRAINT patients_blood_type_chk 241 CHECK ( 242 blood_type IN ( 243 'A+', 'A-', 244 'B+', 'B-', 245 'AB+', 'AB-', 246 'O+', 'O-' 247 ) 248 ), 249 250 CONSTRAINT patients_user_UQ 251 UNIQUE (user_id), 252 253 CONSTRAINT patients_user_FK 254 FOREIGN KEY (user_id) 255 REFERENCES users(user_id) 256 ON DELETE RESTRICT 257 ); 258 259 260 -- APPOINTMENTS -------------------------------------------------------------- 205 261 206 262 CREATE TABLE appointments ( 207 appointment_id BIGINT, 208 209 appointment_date DATE NOT NULL, 210 appointment_time TIME NOT NULL, 211 212 status TEXT NOT NULL, 213 214 patient_id BIGINT NOT NULL, 215 doctor_id BIGINT NOT NULL, 216 217 CONSTRAINT appointments_PK 218 PRIMARY KEY (appointment_id), 219 220 CONSTRAINT appointments_status_chk 221 CHECK ( 222 status IN ( 223 'SCHEDULED', 224 'COMPLETED', 225 'CANCELLED', 226 'IN_PROGRESS' 227 ) 228 ), 229 230 CONSTRAINT appointments_patient_FK 231 FOREIGN KEY (patient_id) 232 REFERENCES patients(patient_id) 233 ON DELETE RESTRICT, 234 235 CONSTRAINT appointments_doctor_FK 236 FOREIGN KEY (doctor_id) 237 REFERENCES doctors(doctor_id) 238 ON DELETE RESTRICT 263 appointment_id BIGINT, 264 265 appointment_date DATE NOT NULL, 266 appointment_time TIME NOT NULL, 267 268 status TEXT NOT NULL, 269 270 patient_id BIGINT NOT NULL, 271 doctor_id BIGINT NOT NULL, 272 273 CONSTRAINT appointments_PK 274 PRIMARY KEY (appointment_id), 275 276 CONSTRAINT appointments_status_chk 277 CHECK ( 278 status IN ( 279 'SCHEDULED', 280 'COMPLETED', 281 'CANCELLED', 282 'IN_PROGRESS' 283 ) 284 ), 285 286 CONSTRAINT appointments_patient_FK 287 FOREIGN KEY (patient_id) 288 REFERENCES patients(patient_id) 289 ON DELETE RESTRICT, 290 291 CONSTRAINT appointments_doctor_FK 292 FOREIGN KEY (doctor_id) 293 REFERENCES doctors(doctor_id) 294 ON DELETE RESTRICT 295 ); 296 297 298 -- CLINICAL ENTITIES ----------------------------------------------------- 299 300 CREATE TABLE allergies ( 301 allergy_id BIGINT, 302 303 name TEXT NOT NULL, 304 allergy_severity TEXT NOT NULL, 305 306 CONSTRAINT allergies_PK 307 PRIMARY KEY (allergy_id), 308 309 CONSTRAINT allergies_name_UQ 310 UNIQUE (name), 311 312 CONSTRAINT allergies_name_chk 313 CHECK (length(trim(name)) > 0), 314 315 CONSTRAINT allergies_severity_chk 316 CHECK (allergy_severity IN ('LOW', 'MEDIUM', 'HIGH', 'CRITICAL')) 317 ); 318 319 CREATE TABLE symptoms ( 320 symptom_id BIGINT, 321 322 name TEXT NOT NULL, 323 description TEXT, 324 325 CONSTRAINT symptoms_PK 326 PRIMARY KEY (symptom_id), 327 328 CONSTRAINT symptoms_name_UQ 329 UNIQUE (name), 330 331 CONSTRAINT symptoms_name_chk 332 CHECK (length(trim(name)) > 0), 333 334 CONSTRAINT symptoms_description_chk 335 CHECK ( 336 description IS NULL 337 OR length(trim(description)) > 0 338 ) 239 339 ); 240 340 241 341 CREATE TABLE diagnosis ( 242 diagnosis_id BIGINT, 243 244 name TEXT NOT NULL, 245 description TEXT, 246 247 patient_id BIGINT NOT NULL, 248 doctor_id BIGINT NOT NULL, 249 250 CONSTRAINT diagnosis_PK 251 PRIMARY KEY (diagnosis_id), 252 253 CONSTRAINT diagnosis_patient_FK 254 FOREIGN KEY (patient_id) 255 REFERENCES patients(patient_id) 256 ON DELETE RESTRICT, 257 258 CONSTRAINT diagnosis_doctor_FK 259 FOREIGN KEY (doctor_id) 260 REFERENCES doctors(doctor_id) 261 ON DELETE RESTRICT 262 ); 263 264 265 342 diagnosis_id BIGINT, 343 344 name TEXT NOT NULL, 345 description TEXT, 346 347 patient_id BIGINT NOT NULL, 348 doctor_id BIGINT NOT NULL, 349 350 CONSTRAINT diagnosis_PK 351 PRIMARY KEY (diagnosis_id), 352 353 CONSTRAINT diagnosis_patient_FK 354 FOREIGN KEY (patient_id) 355 REFERENCES patients(patient_id) 356 ON DELETE RESTRICT, 357 358 CONSTRAINT diagnosis_doctor_FK 359 FOREIGN KEY (doctor_id) 360 REFERENCES doctors(doctor_id) 361 ON DELETE RESTRICT 362 ); 363 364 CREATE TABLE diagnosis_symptoms ( 365 diagnosis_id BIGINT NOT NULL, 366 symptom_id BIGINT NOT NULL, 367 368 CONSTRAINT diagnosis_symptoms_PK 369 PRIMARY KEY (diagnosis_id, symptom_id), 370 371 CONSTRAINT diagnosis_symptoms_diagnosis_FK 372 FOREIGN KEY (diagnosis_id) 373 REFERENCES diagnosis(diagnosis_id) 374 ON DELETE RESTRICT, 375 376 CONSTRAINT diagnosis_symptoms_symptom_FK 377 FOREIGN KEY (symptom_id) 378 REFERENCES symptoms(symptom_id) 379 ON DELETE RESTRICT 380 ); 381 382 383 -- PROCEDURES -------------------------------------------------------------- 266 384 267 385 CREATE TABLE procedures ( 268 procedure_id BIGINT, 269 270 procedure_type TEXT NOT NULL, 271 procedure_date DATE NOT NULL, 272 273 description TEXT, 274 cost DECIMAL NOT NULL, 275 276 doctor_id BIGINT NOT NULL, 277 diagnosis_id BIGINT NOT NULL, 278 279 CONSTRAINT procedures_PK 280 PRIMARY KEY (procedure_id), 281 282 CONSTRAINT procedures_cost_chk 283 CHECK (cost >= 0), 284 285 CONSTRAINT procedures_type_chk 286 CHECK (length(trim(procedure_type)) > 0), 287 288 CONSTRAINT procedures_doctor_FK 289 FOREIGN KEY (doctor_id) 290 REFERENCES doctors(doctor_id) 291 ON DELETE RESTRICT, 292 293 CONSTRAINT procedures_diagnosis_FK 294 FOREIGN KEY (diagnosis_id) 295 REFERENCES diagnosis(diagnosis_id) 296 ON DELETE RESTRICT 297 ); 298 299 300 386 procedure_id BIGINT, 387 388 procedure_type TEXT NOT NULL, 389 procedure_date DATE NOT NULL, 390 391 description TEXT, 392 cost DECIMAL NOT NULL, 393 394 doctor_id BIGINT NOT NULL, 395 396 CONSTRAINT procedures_PK 397 PRIMARY KEY (procedure_id), 398 399 CONSTRAINT procedures_cost_chk 400 CHECK (cost >= 0), 401 402 CONSTRAINT procedures_type_chk 403 CHECK (length(trim(procedure_type)) > 0), 404 405 CONSTRAINT procedures_doctor_FK 406 FOREIGN KEY (doctor_id) 407 REFERENCES doctors(doctor_id) 408 ON DELETE RESTRICT 409 ); 301 410 302 411 CREATE TABLE procedure_results ( 303 result_id BIGINT, 304 305 result_description TEXT, 306 result_date DATE NOT NULL, 307 308 procedure_id BIGINT NOT NULL, 309 310 CONSTRAINT procedure_results_PK 311 PRIMARY KEY (result_id), 312 313 CONSTRAINT procedure_results_description_chk 314 CHECK ( 315 result_description IS NULL 316 OR length(trim(result_description)) > 0 317 ), 318 319 CONSTRAINT procedure_results_procedure_FK 320 FOREIGN KEY (procedure_id) 321 REFERENCES procedures(procedure_id) 322 ON DELETE RESTRICT 323 ); 412 result_id BIGINT, 413 414 result_description TEXT, 415 result_date DATE NOT NULL, 416 417 procedure_id BIGINT NOT NULL, 418 419 CONSTRAINT procedure_results_PK 420 PRIMARY KEY (result_id), 421 422 CONSTRAINT procedure_results_description_chk 423 CHECK ( 424 result_description IS NULL 425 OR length(trim(result_description)) > 0 426 ), 427 428 CONSTRAINT procedure_results_procedure_FK 429 FOREIGN KEY (procedure_id) 430 REFERENCES procedures(procedure_id) 431 ON DELETE RESTRICT 432 ); 433 434 CREATE TABLE specialization_procedures ( 435 specialization_id BIGINT NOT NULL, 436 procedure_id BIGINT NOT NULL, 437 438 CONSTRAINT specialization_procedures_PK 439 PRIMARY KEY (specialization_id, procedure_id), 440 441 CONSTRAINT specialization_procedures_specialization_FK 442 FOREIGN KEY (specialization_id) 443 REFERENCES doctor_specialization(specialization_id) 444 ON DELETE RESTRICT, 445 446 CONSTRAINT specialization_procedures_procedure_FK 447 FOREIGN KEY (procedure_id) 448 REFERENCES procedures(procedure_id) 449 ON DELETE RESTRICT 450 ); 451 452 CREATE TABLE department_procedures ( 453 department_id BIGINT NOT NULL, 454 procedure_id BIGINT NOT NULL, 455 456 CONSTRAINT department_procedures_PK 457 PRIMARY KEY (department_id, procedure_id), 458 459 CONSTRAINT department_procedures_department_FK 460 FOREIGN KEY (department_id) 461 REFERENCES departments(department_id) 462 ON DELETE RESTRICT, 463 464 CONSTRAINT department_procedures_procedure_FK 465 FOREIGN KEY (procedure_id) 466 REFERENCES procedures(procedure_id) 467 ON DELETE RESTRICT 468 ); 469 470 471 -- LAB TESTS ----------------------------------------------------------------- 472 473 CREATE TABLE lab_tests ( 474 test_id BIGINT, 475 476 test_name TEXT NOT NULL, 477 description TEXT, 478 cost DECIMAL NOT NULL, 479 480 CONSTRAINT lab_tests_PK 481 PRIMARY KEY (test_id), 482 483 CONSTRAINT lab_tests_cost_chk 484 CHECK (cost >= 0), 485 486 CONSTRAINT lab_tests_name_chk 487 CHECK (length(trim(test_name)) > 0) 488 ); 489 490 CREATE TABLE lab_results ( 491 result_id BIGINT, 492 493 results TEXT NOT NULL, 494 result_date DATE NOT NULL, 495 496 test_id BIGINT NOT NULL, 497 498 CONSTRAINT lab_results_PK 499 PRIMARY KEY (result_id), 500 501 CONSTRAINT lab_results_results_chk 502 CHECK (length(trim(results)) > 0), 503 504 CONSTRAINT lab_results_date_chk 505 CHECK (result_date <= CURRENT_DATE), 506 507 CONSTRAINT lab_results_test_FK 508 FOREIGN KEY (test_id) 509 REFERENCES lab_tests(test_id) 510 ON DELETE RESTRICT 511 ); 512 513 514 -- PRESCRIPTIONS --------------------------------------------------------- 324 515 325 516 CREATE TABLE prescriptions ( 326 327 328 329 330 331 517 prescription_id BIGINT, 518 519 medication_name TEXT NOT NULL, 520 521 CONSTRAINT prescriptions_PK 522 PRIMARY KEY (prescription_id) 332 523 ); 333 524 334 525 CREATE TABLE prescription_restriction ( 335 restriction_id BIGINT, 336 337 description TEXT NOT NULL, 338 339 prescription_id BIGINT NOT NULL, 340 341 CONSTRAINT prescription_restriction_PK 342 PRIMARY KEY (restriction_id), 343 344 CONSTRAINT prescription_restriction_desc_chk 345 CHECK (length(trim(description)) > 0), 346 347 CONSTRAINT prescription_restriction_prescription_FK 348 FOREIGN KEY (prescription_id) 349 REFERENCES prescriptions(prescription_id) 350 ON DELETE RESTRICT 351 ); 352 353 354 CREATE TABLE lab_tests ( 355 test_id BIGINT, 356 357 test_name TEXT NOT NULL, 358 description TEXT, 359 cost DECIMAL NOT NULL, 360 361 CONSTRAINT lab_tests_PK 362 PRIMARY KEY (test_id), 363 364 CONSTRAINT lab_tests_cost_chk 365 CHECK (cost >= 0), 366 367 CONSTRAINT lab_tests_name_chk 368 CHECK (length(trim(test_name)) > 0) 369 ); 370 371 372 CREATE TABLE lab_results ( 373 result_id BIGINT, 374 375 results TEXT NOT NULL, 376 result_date DATE NOT NULL, 377 378 test_id BIGINT NOT NULL, 379 380 CONSTRAINT lab_results_PK 381 PRIMARY KEY (result_id), 382 383 CONSTRAINT lab_results_results_chk 384 CHECK (length(trim(results)) > 0), 385 386 CONSTRAINT lab_results_date_chk 387 CHECK (result_date <= CURRENT_DATE), 388 389 CONSTRAINT lab_results_test_FK 390 FOREIGN KEY (test_id) 391 REFERENCES lab_tests(test_id) 392 ON DELETE RESTRICT 393 ); 526 restriction_id BIGINT, 527 528 description TEXT NOT NULL, 529 530 prescription_id BIGINT NOT NULL, 531 532 CONSTRAINT prescription_restriction_PK 533 PRIMARY KEY (restriction_id), 534 535 CONSTRAINT prescription_restriction_desc_chk 536 CHECK (length(trim(description)) > 0), 537 538 CONSTRAINT prescription_restriction_prescription_FK 539 FOREIGN KEY (prescription_id) 540 REFERENCES prescriptions(prescription_id) 541 ON DELETE RESTRICT 542 ); 543 544 CREATE TABLE allergy_prescription_restrictions ( 545 allergy_id BIGINT NOT NULL, 546 restriction_id BIGINT NOT NULL, 547 548 CONSTRAINT allergy_prescription_restrictions_PK 549 PRIMARY KEY (allergy_id, restriction_id), 550 551 CONSTRAINT allergy_prescription_restrictions_allergy_FK 552 FOREIGN KEY (allergy_id) 553 REFERENCES allergies(allergy_id) 554 ON DELETE RESTRICT, 555 556 CONSTRAINT allergy_prescription_restrictions_restriction_FK 557 FOREIGN KEY (restriction_id) 558 REFERENCES prescription_restriction(restriction_id) 559 ON DELETE RESTRICT 560 ); 561 562 563 -- PATIENTS <-> ALLERGIES / SYMPTOMS ----------------------------------------- 564 565 CREATE TABLE patient_allergies ( 566 patient_id BIGINT NOT NULL, 567 allergy_id BIGINT NOT NULL, 568 569 CONSTRAINT patient_allergies_PK 570 PRIMARY KEY (patient_id, allergy_id), 571 572 CONSTRAINT patient_allergies_patient_FK 573 FOREIGN KEY (patient_id) 574 REFERENCES patients(patient_id) 575 ON DELETE RESTRICT, 576 577 CONSTRAINT patient_allergies_allergy_FK 578 FOREIGN KEY (allergy_id) 579 REFERENCES allergies(allergy_id) 580 ON DELETE RESTRICT 581 ); 582 583 CREATE TABLE patient_symptoms ( 584 patient_id BIGINT NOT NULL, 585 symptom_id BIGINT NOT NULL, 586 587 CONSTRAINT patient_symptoms_PK 588 PRIMARY KEY (patient_id, symptom_id), 589 590 CONSTRAINT patient_symptoms_patient_FK 591 FOREIGN KEY (patient_id) 592 REFERENCES patients(patient_id) 593 ON DELETE RESTRICT, 594 595 CONSTRAINT patient_symptoms_symptom_FK 596 FOREIGN KEY (symptom_id) 597 REFERENCES symptoms(symptom_id) 598 ON DELETE RESTRICT 599 ); 600 601 602 -- MEDICAL RECORDS ------------------------------------------------------- 394 603 395 604 CREATE TABLE medical_records ( 396 record_id BIGINT PRIMARY KEY, 397 398 patient_id BIGINT NOT NULL, 399 400 401 FOREIGN KEY (patient_id) 402 REFERENCES patients(patient_id) 403 ON DELETE RESTRICT 404 ); 405 406 407 408 409 CREATE TABLE allergies ( 410 allergy_id BIGINT, 411 412 name TEXT NOT NULL, 413 allergy_severity TEXT NOT NULL, 414 415 CONSTRAINT allergies_PK 416 PRIMARY KEY (allergy_id), 417 418 CONSTRAINT allergies_name_UQ 419 UNIQUE (name), 420 421 CONSTRAINT allergies_name_chk 422 CHECK (length(trim(name)) > 0), 423 424 CONSTRAINT allergies_severity_chk 425 CHECK (allergy_severity IN ('LOW', 'MEDIUM', 'HIGH', 'CRITICAL')) 426 ); 427 428 429 CREATE TABLE symptoms ( 430 symptom_id BIGINT, 431 432 name TEXT NOT NULL, 433 description TEXT, 434 435 CONSTRAINT symptoms_PK 436 PRIMARY KEY (symptom_id), 437 438 CONSTRAINT symptoms_name_UQ 439 UNIQUE (name), 440 441 CONSTRAINT symptoms_name_chk 442 CHECK (length(trim(name)) > 0), 443 444 CONSTRAINT symptoms_description_chk 445 CHECK ( 446 description IS NULL 447 OR length(trim(description)) > 0 448 ) 449 ); 450 605 record_id BIGINT PRIMARY KEY, 606 607 patient_id BIGINT NOT NULL, 608 609 FOREIGN KEY (patient_id) 610 REFERENCES patients(patient_id) 611 ON DELETE RESTRICT 612 ); 613 614 CREATE TABLE diagnosis_medical_records ( 615 diagnosis_id BIGINT NOT NULL, 616 record_id BIGINT NOT NULL, 617 618 CONSTRAINT diagnosis_medical_records_PK 619 PRIMARY KEY (diagnosis_id, record_id), 620 621 CONSTRAINT diagnosis_medical_records_diagnosis_FK 622 FOREIGN KEY (diagnosis_id) 623 REFERENCES diagnosis(diagnosis_id) 624 ON DELETE RESTRICT, 625 626 CONSTRAINT diagnosis_medical_records_record_FK 627 FOREIGN KEY (record_id) 628 REFERENCES medical_records(record_id) 629 ON DELETE RESTRICT 630 ); 631 632 CREATE TABLE prescription_medical_records ( 633 prescription_id BIGINT NOT NULL, 634 record_id BIGINT NOT NULL, 635 636 dosage TEXT NOT NULL, 637 frequency TEXT NOT NULL, 638 duration TEXT NOT NULL, 639 640 notes TEXT, 641 642 CONSTRAINT prescription_medical_records_PK 643 PRIMARY KEY (prescription_id, record_id), 644 645 CONSTRAINT prescription_medical_records_prescription_FK 646 FOREIGN KEY (prescription_id) 647 REFERENCES prescriptions(prescription_id) 648 ON DELETE RESTRICT, 649 650 CONSTRAINT prescription_medical_records_record_FK 651 FOREIGN KEY (record_id) 652 REFERENCES medical_records(record_id) 653 ON DELETE RESTRICT 654 ); 655 656 CREATE TABLE medical_record_lab_results ( 657 record_id BIGINT NOT NULL, 658 result_id BIGINT NOT NULL, 659 660 PRIMARY KEY (record_id, result_id), 661 662 FOREIGN KEY (record_id) 663 REFERENCES medical_records(record_id) 664 ON DELETE RESTRICT, 665 666 FOREIGN KEY (result_id) 667 REFERENCES lab_results(result_id) 668 ON DELETE RESTRICT 669 ); 670 671 CREATE TABLE medical_record_procedures ( 672 record_id BIGINT NOT NULL, 673 procedure_id BIGINT NOT NULL, 674 675 PRIMARY KEY (record_id, procedure_id), 676 677 FOREIGN KEY (record_id) 678 REFERENCES medical_records(record_id) 679 ON DELETE RESTRICT, 680 681 FOREIGN KEY (procedure_id) 682 REFERENCES procedures(procedure_id) 683 ON DELETE RESTRICT 684 ); 685 686 CREATE TABLE medical_record_symptoms ( 687 record_id BIGINT NOT NULL, 688 symptom_id BIGINT NOT NULL, 689 severity TEXT, 690 691 PRIMARY KEY (record_id, symptom_id), 692 693 FOREIGN KEY (record_id) 694 REFERENCES medical_records(record_id) 695 ON DELETE RESTRICT, 696 697 FOREIGN KEY (symptom_id) 698 REFERENCES symptoms(symptom_id) 699 ON DELETE RESTRICT 700 ); 701 702 CREATE TABLE medical_record_allergies ( 703 record_id BIGINT NOT NULL, 704 allergy_id BIGINT NOT NULL, 705 reaction TEXT, 706 severity TEXT, 707 708 PRIMARY KEY (record_id, allergy_id), 709 710 FOREIGN KEY (record_id) 711 REFERENCES medical_records(record_id) 712 ON DELETE RESTRICT, 713 714 FOREIGN KEY (allergy_id) 715 REFERENCES allergies(allergy_id) 716 ON DELETE RESTRICT 717 ); 718 719 720 -- REPORTS & REFERRALS ----------------------------------------------------- 451 721 452 722 CREATE TABLE referrals ( 453 454 referral_id BIGINT PRIMARY KEY, 455 456 reason TEXT NOT NULL, 457 referral_date DATE NOT NULL, 458 459 record_id BIGINT NOT NULL, 460 from_doctor_id BIGINT NOT NULL, 461 to_doctor_id BIGINT not null, 462 463 CONSTRAINT referrals_reason_chk 464 CHECK (length(trim(reason)) > 0), 465 466 FOREIGN KEY (record_id) 467 REFERENCES medical_records(record_id) 468 ON DELETE RESTRICT, 469 470 FOREIGN KEY (from_doctor_id) 471 REFERENCES doctors(doctor_id) 472 ON DELETE RESTRICT, 473 474 FOREIGN KEY (to_doctor_id) 475 REFERENCES doctors(doctor_id) 476 ON DELETE RESTRICT 723 referral_id BIGINT PRIMARY KEY, 724 725 reason TEXT NOT NULL, 726 referral_date DATE NOT NULL, 727 728 record_id BIGINT NOT NULL, 729 from_doctor_id BIGINT NOT NULL, 730 to_doctor_id BIGINT NOT NULL, 731 732 CONSTRAINT referrals_reason_chk 733 CHECK (length(trim(reason)) > 0), 734 735 FOREIGN KEY (record_id) 736 REFERENCES medical_records(record_id) 737 ON DELETE RESTRICT, 738 739 FOREIGN KEY (from_doctor_id) 740 REFERENCES doctors(doctor_id) 741 ON DELETE RESTRICT, 742 743 FOREIGN KEY (to_doctor_id) 744 REFERENCES doctors(doctor_id) 745 ON DELETE RESTRICT 477 746 ); 478 747 479 748 CREATE TABLE medical_report ( 480 report_id BIGINT PRIMARY KEY, 481 482 description TEXT NOT NULL, 483 report_date DATE NOT NULL, 484 485 record_id BIGINT NOT NULL, 486 doctor_id BIGINT NOT NULL, 487 488 FOREIGN KEY (record_id) 489 REFERENCES medical_records(record_id) 490 ON DELETE RESTRICT, 491 492 FOREIGN KEY (doctor_id) 493 REFERENCES doctors(doctor_id) 494 ON DELETE RESTRICT 495 ); 496 749 report_id BIGINT PRIMARY KEY, 750 751 description TEXT NOT NULL, 752 report_date DATE NOT NULL, 753 754 record_id BIGINT NOT NULL, 755 doctor_id BIGINT NOT NULL, 756 757 FOREIGN KEY (record_id) 758 REFERENCES medical_records(record_id) 759 ON DELETE RESTRICT, 760 761 FOREIGN KEY (doctor_id) 762 REFERENCES doctors(doctor_id) 763 ON DELETE RESTRICT 764 ); 765 766 CREATE TABLE medical_report_lab_results ( 767 report_id BIGINT NOT NULL, 768 result_id BIGINT NOT NULL, 769 770 CONSTRAINT medical_report_lab_results_PK 771 PRIMARY KEY (report_id, result_id), 772 773 CONSTRAINT medical_report_lab_results_report_FK 774 FOREIGN KEY (report_id) 775 REFERENCES medical_report(report_id) 776 ON DELETE RESTRICT, 777 778 CONSTRAINT medical_report_lab_results_result_FK 779 FOREIGN KEY (result_id) 780 REFERENCES lab_results(result_id) 781 ON DELETE RESTRICT 782 ); 783 784 785 -- PERFORMED PROCEDURES / LAB TESTS ----------------------------------------- 786 787 CREATE TABLE performed_procedures ( 788 performed_id BIGINT, 789 790 procedure_id BIGINT NOT NULL, 791 doctor_id BIGINT NOT NULL, 792 patient_id BIGINT NOT NULL, 793 diagnosis_id BIGINT, 794 795 procedure_date DATE NOT NULL, 796 notes TEXT, 797 798 CONSTRAINT performed_procedures_PK 799 PRIMARY KEY (performed_id), 800 801 CONSTRAINT performed_procedures_procedure_FK 802 FOREIGN KEY (procedure_id) 803 REFERENCES procedures(procedure_id) 804 ON DELETE RESTRICT, 805 806 CONSTRAINT performed_procedures_doctor_FK 807 FOREIGN KEY (doctor_id) 808 REFERENCES doctors(doctor_id) 809 ON DELETE RESTRICT, 810 811 CONSTRAINT performed_procedures_patient_FK 812 FOREIGN KEY (patient_id) 813 REFERENCES patients(patient_id) 814 ON DELETE RESTRICT, 815 816 CONSTRAINT performed_procedures_diagnosis_FK 817 FOREIGN KEY (diagnosis_id) 818 REFERENCES diagnosis(diagnosis_id) 819 ON DELETE RESTRICT 820 ); 821 822 CREATE TABLE performed_lab_tests ( 823 performed_test_id BIGINT, 824 825 test_id BIGINT NOT NULL, 826 patient_id BIGINT NOT NULL, 827 doctor_id BIGINT NOT NULL, 828 technician_id BIGINT NOT NULL, 829 830 test_date DATE NOT NULL, 831 notes TEXT, 832 created_at TIMESTAMP DEFAULT now(), 833 834 CONSTRAINT performed_lab_tests_PK 835 PRIMARY KEY (performed_test_id), 836 837 CONSTRAINT performed_lab_tests_test_FK 838 FOREIGN KEY (test_id) 839 REFERENCES lab_tests(test_id) 840 ON DELETE RESTRICT, 841 842 CONSTRAINT performed_lab_tests_patient_FK 843 FOREIGN KEY (patient_id) 844 REFERENCES patients(patient_id) 845 ON DELETE RESTRICT, 846 847 CONSTRAINT performed_lab_tests_doctor_FK 848 FOREIGN KEY (doctor_id) 849 REFERENCES doctors(doctor_id) 850 ON DELETE RESTRICT, 851 852 CONSTRAINT performed_lab_tests_technician_FK 853 FOREIGN KEY (technician_id) 854 REFERENCES lab_technician(technician_id) 855 ON DELETE RESTRICT 856 ); 857 858 859 -- BILLING ------------------------------------------------------------------- 497 860 498 861 CREATE TABLE billing ( 499 bill_id BIGINT PRIMARY KEY, 500 501 total_cost DECIMAL NOT NULL, 502 503 payment_status TEXT NOT NULL, 504 payment_date DATE, 505 506 record_id BIGINT NOT NULL, 507 admin_id BIGINT NOT NULL, 508 509 CONSTRAINT billing_cost_chk CHECK (total_cost >= 0), 510 CONSTRAINT billing_status_chk 511 CHECK (payment_status IN ('PENDING', 'PAID', 'CANCELLED')), 512 513 FOREIGN KEY (record_id) 514 REFERENCES medical_records(record_id) 515 ON DELETE RESTRICT, 516 517 FOREIGN KEY (admin_id) 518 REFERENCES admin(admin_id) 519 ON DELETE RESTRICT 520 ); 521 522 523 524 525 CREATE TABLE patient_allergies ( 526 patient_id BIGINT NOT NULL, 527 allergy_id BIGINT NOT NULL, 528 529 CONSTRAINT patient_allergies_PK 530 PRIMARY KEY (patient_id, allergy_id), 531 532 CONSTRAINT patient_allergies_patient_FK 533 FOREIGN KEY (patient_id) 534 REFERENCES patients(patient_id) 535 ON DELETE RESTRICT, 536 537 CONSTRAINT patient_allergies_allergy_FK 538 FOREIGN KEY (allergy_id) 539 REFERENCES allergies(allergy_id) 540 ON DELETE RESTRICT 541 ); 542 543 544 545 CREATE TABLE allergy_prescription_restrictions ( 546 allergy_id BIGINT NOT NULL, 547 restriction_id BIGINT NOT NULL, 548 549 CONSTRAINT allergy_prescription_restrictions_PK 550 PRIMARY KEY (allergy_id, restriction_id), 551 552 CONSTRAINT allergy_prescription_restrictions_allergy_FK 553 FOREIGN KEY (allergy_id) 554 REFERENCES allergies(allergy_id) 555 ON DELETE RESTRICT, 556 557 CONSTRAINT allergy_prescription_restrictions_restriction_FK 558 FOREIGN KEY (restriction_id) 559 REFERENCES prescription_restriction(restriction_id) 560 ON DELETE RESTRICT 561 ); 562 563 564 565 CREATE TABLE patient_symptoms ( 566 patient_id BIGINT NOT NULL, 567 symptom_id BIGINT NOT NULL, 568 569 CONSTRAINT patient_symptoms_PK 570 PRIMARY KEY (patient_id, symptom_id), 571 572 CONSTRAINT patient_symptoms_patient_FK 573 FOREIGN KEY (patient_id) 574 REFERENCES patients(patient_id) 575 ON DELETE RESTRICT, 576 577 CONSTRAINT patient_symptoms_symptom_FK 578 FOREIGN KEY (symptom_id) 579 REFERENCES symptoms(symptom_id) 580 ON DELETE RESTRICT 581 ); 582 583 584 585 586 CREATE TABLE diagnosis_symptoms ( 587 diagnosis_id BIGINT NOT NULL, 588 symptom_id BIGINT NOT NULL, 589 590 CONSTRAINT diagnosis_symptoms_PK 591 PRIMARY KEY (diagnosis_id, symptom_id), 592 593 CONSTRAINT diagnosis_symptoms_diagnosis_FK 594 FOREIGN KEY (diagnosis_id) 595 REFERENCES diagnosis(diagnosis_id) 596 ON DELETE RESTRICT, 597 598 CONSTRAINT diagnosis_symptoms_symptom_FK 599 FOREIGN KEY (symptom_id) 600 REFERENCES symptoms(symptom_id) 601 ON DELETE RESTRICT 602 ); 603 604 CREATE TABLE specialization_procedures ( 605 specialization_id BIGINT NOT NULL, 606 procedure_id BIGINT NOT NULL, 607 608 CONSTRAINT specialization_procedures_PK 609 PRIMARY KEY (specialization_id, procedure_id), 610 611 CONSTRAINT specialization_procedures_specialization_FK 612 FOREIGN KEY (specialization_id) 613 REFERENCES doctor_specialization(specialization_id) 614 ON DELETE RESTRICT, 615 616 CONSTRAINT specialization_procedures_procedure_FK 617 FOREIGN KEY (procedure_id) 618 REFERENCES procedures(procedure_id) 619 ON DELETE RESTRICT 620 ); 621 622 623 624 CREATE TABLE diagnosis_procedures ( 625 diagnosis_id BIGINT NOT NULL, 626 procedure_id BIGINT NOT NULL, 627 628 CONSTRAINT diagnosis_procedures_PK 629 PRIMARY KEY (diagnosis_id, procedure_id), 630 631 CONSTRAINT diagnosis_procedures_diagnosis_FK 632 FOREIGN KEY (diagnosis_id) 633 REFERENCES diagnosis(diagnosis_id) 634 ON DELETE RESTRICT, 635 636 CONSTRAINT diagnosis_procedures_procedure_FK 637 FOREIGN KEY (procedure_id) 638 REFERENCES procedures(procedure_id) 639 ON DELETE RESTRICT 640 ); 641 642 CREATE TABLE department_procedures ( 643 department_id BIGINT NOT NULL , 644 procedure_id BIGINT NOT NULL, 645 646 CONSTRAINT department_procedures_PK 647 PRIMARY KEY (department_id, procedure_id), 648 649 CONSTRAINT department_procedures_department_FK 650 FOREIGN KEY (department_id) 651 REFERENCES departments(department_id) 652 ON DELETE RESTRICT, 653 654 CONSTRAINT department_procedures_procedure_FK 655 FOREIGN KEY (procedure_id) 656 REFERENCES procedures(procedure_id) 657 ON DELETE RESTRICT 658 ); 659 862 bill_id BIGINT PRIMARY KEY, 863 864 total_cost DECIMAL NOT NULL, 865 866 payment_status TEXT NOT NULL, 867 payment_date DATE, 868 869 created_at TIMESTAMP DEFAULT now(), 870 871 record_id BIGINT NOT NULL, 872 admin_id BIGINT NOT NULL, 873 874 CONSTRAINT billing_cost_chk CHECK (total_cost >= 0), 875 CONSTRAINT billing_status_chk 876 CHECK (payment_status IN ('PENDING', 'PAID', 'CANCELLED')), 877 878 FOREIGN KEY (record_id) 879 REFERENCES medical_records(record_id) 880 ON DELETE RESTRICT, 881 882 FOREIGN KEY (admin_id) 883 REFERENCES admin(admin_id) 884 ON DELETE RESTRICT 885 ); 660 886 661 887 CREATE TABLE billing_procedures ( 662 bill_id BIGINT NOT NULL, 663 procedure_id BIGINT NOT NULL, 664 665 CONSTRAINT billing_procedures_PK 666 PRIMARY KEY (bill_id, procedure_id), 667 668 CONSTRAINT billing_procedures_bill_FK 669 FOREIGN KEY (bill_id) 670 REFERENCES billing(bill_id) 671 ON DELETE RESTRICT, 672 673 CONSTRAINT billing_procedures_procedure_FK 674 FOREIGN KEY (procedure_id) 675 REFERENCES procedures(procedure_id) 676 ON DELETE RESTRICT 677 ); 678 679 680 888 bill_id BIGINT NOT NULL, 889 procedure_id BIGINT NOT NULL, 890 891 CONSTRAINT billing_procedures_PK 892 PRIMARY KEY (bill_id, procedure_id), 893 894 CONSTRAINT billing_procedures_bill_FK 895 FOREIGN KEY (bill_id) 896 REFERENCES billing(bill_id) 897 ON DELETE RESTRICT, 898 899 CONSTRAINT billing_procedures_procedure_FK 900 FOREIGN KEY (procedure_id) 901 REFERENCES procedures(procedure_id) 902 ON DELETE RESTRICT 903 ); 681 904 682 905 CREATE TABLE billing_lab_tests ( 683 bill_id BIGINT NOT NULL, 684 test_id BIGINT NOT NULL, 685 686 CONSTRAINT billing_lab_tests_PK 687 PRIMARY KEY (bill_id, test_id), 688 689 CONSTRAINT billing_lab_tests_bill_FK 690 FOREIGN KEY (bill_id) 691 REFERENCES billing(bill_id) 692 ON DELETE RESTRICT, 693 694 CONSTRAINT billing_lab_tests_test_FK 695 FOREIGN KEY (test_id) 696 REFERENCES lab_tests(test_id) 697 ON DELETE RESTRICT 698 ); 699 700 701 702 CREATE TABLE doctor_medical_records ( 703 doctor_id BIGINT NOT NULL, 704 record_id BIGINT NOT NULL, 705 706 CONSTRAINT doctor_medical_records_PK 707 PRIMARY KEY (doctor_id, record_id), 708 709 CONSTRAINT doctor_medical_records_doctor_FK 710 FOREIGN KEY (doctor_id) 711 REFERENCES doctors(doctor_id) 712 ON DELETE RESTRICT, 713 714 CONSTRAINT doctor_medical_records_record_FK 715 FOREIGN KEY (record_id) 716 REFERENCES medical_records(record_id) 717 ON DELETE RESTRICT 718 ); 719 720 721 722 CREATE TABLE diagnosis_medical_records ( 723 diagnosis_id BIGINT NOT NULL, 724 record_id BIGINT NOT NULL, 725 726 CONSTRAINT diagnosis_medical_records_PK 727 PRIMARY KEY (diagnosis_id, record_id), 728 729 CONSTRAINT diagnosis_medical_records_diagnosis_FK 730 FOREIGN KEY (diagnosis_id) 731 REFERENCES diagnosis(diagnosis_id) 732 ON DELETE RESTRICT, 733 734 CONSTRAINT diagnosis_medical_records_record_FK 735 FOREIGN KEY (record_id) 736 REFERENCES medical_records(record_id) 737 ON DELETE RESTRICT 738 ); 739 740 741 CREATE TABLE prescription_medical_records ( 742 prescription_id BIGINT NOT NULL, 743 record_id BIGINT NOT NULL, 744 745 dosage TEXT NOT NULL, 746 frequency TEXT NOT NULL, 747 duration TEXT NOT NULL, 748 749 notes TEXT, 750 751 CONSTRAINT prescription_medical_records_PK 752 PRIMARY KEY (prescription_id, record_id), 753 754 CONSTRAINT prescription_medical_records_prescription_FK 755 FOREIGN KEY (prescription_id) 756 REFERENCES prescriptions(prescription_id) 757 ON DELETE RESTRICT, 758 759 CONSTRAINT prescription_medical_records_record_FK 760 FOREIGN KEY (record_id) 761 REFERENCES medical_records(record_id) 762 ON DELETE RESTRICT 763 ); 764 765 766 767 CREATE TABLE medical_report_lab_results ( 768 report_id BIGINT NOT NULL, 769 result_id BIGINT NOT NULL, 770 771 CONSTRAINT medical_report_lab_results_PK 772 PRIMARY KEY (report_id, result_id), 773 774 CONSTRAINT medical_report_lab_results_report_FK 775 FOREIGN KEY (report_id) 776 REFERENCES medical_report(report_id) 777 ON DELETE RESTRICT, 778 779 CONSTRAINT medical_report_lab_results_result_FK 780 FOREIGN KEY (result_id) 781 REFERENCES lab_results(result_id) 782 ON DELETE RESTRICT 783 ); 784 785 786 787 CREATE TABLE performed_procedures ( 788 performed_id BIGINT, 789 790 procedure_id BIGINT NOT NULL, 791 doctor_id BIGINT NOT NULL, 792 patient_id BIGINT NOT NULL, 793 diagnosis_id BIGINT, 794 795 procedure_date DATE NOT NULL, 796 notes TEXT, 797 798 CONSTRAINT performed_procedures_PK 799 PRIMARY KEY (performed_id), 800 801 CONSTRAINT performed_procedures_procedure_FK 802 FOREIGN KEY (procedure_id) 803 REFERENCES procedures(procedure_id) 804 ON DELETE RESTRICT, 805 806 CONSTRAINT performed_procedures_doctor_FK 807 FOREIGN KEY (doctor_id) 808 REFERENCES doctors(doctor_id) 809 ON DELETE RESTRICT, 810 811 CONSTRAINT performed_procedures_patient_FK 812 FOREIGN KEY (patient_id) 813 REFERENCES patients(patient_id) 814 ON DELETE RESTRICT, 815 816 CONSTRAINT performed_procedures_diagnosis_FK 817 FOREIGN KEY (diagnosis_id) 818 REFERENCES diagnosis(diagnosis_id) 819 ON DELETE RESTRICT 820 ); 821 822 CREATE TABLE performed_lab_tests ( 823 performed_test_id BIGINT, 824 825 test_id BIGINT NOT NULL, 826 patient_id BIGINT NOT NULL, 827 doctor_id BIGINT NOT NULL, 828 technician_id BIGINT NOT NULL, 829 830 test_date DATE NOT NULL, 831 notes TEXT, 832 833 CONSTRAINT performed_lab_tests_PK 834 PRIMARY KEY (performed_test_id), 835 836 CONSTRAINT performed_lab_tests_test_FK 837 FOREIGN KEY (test_id) 838 REFERENCES lab_tests(test_id) 839 ON DELETE RESTRICT, 840 841 CONSTRAINT performed_lab_tests_patient_FK 842 FOREIGN KEY (patient_id) 843 REFERENCES patients(patient_id) 844 ON DELETE RESTRICT, 845 846 CONSTRAINT performed_lab_tests_doctor_FK 847 FOREIGN KEY (doctor_id) 848 REFERENCES doctors(doctor_id) 849 ON DELETE RESTRICT, 850 851 CONSTRAINT performed_lab_tests_technician_FK 852 FOREIGN KEY (technician_id) 853 REFERENCES lab_technician(technician_id) 854 ON DELETE RESTRICT 855 ); 856 857 CREATE TABLE medical_record_lab_results ( 858 record_id BIGINT NOT NULL, 859 result_id BIGINT NOT NULL, 860 861 PRIMARY KEY (record_id, result_id), 862 863 FOREIGN KEY (record_id) 864 REFERENCES medical_records(record_id) 865 ON DELETE RESTRICT, 866 867 FOREIGN KEY (result_id) 868 REFERENCES lab_results(result_id) 869 ON DELETE RESTRICT 870 ); 871 872 873 874 875 CREATE TABLE medical_record_procedures ( 876 record_id BIGINT NOT NULL, 877 procedure_id BIGINT NOT NULL, 878 879 PRIMARY KEY (record_id, procedure_id), 880 881 FOREIGN KEY (record_id) 882 REFERENCES medical_records(record_id) 883 ON DELETE RESTRICT, 884 885 FOREIGN KEY (procedure_id) 886 REFERENCES procedures(procedure_id) 887 ON DELETE RESTRICT 888 ); 889 890 891 892 CREATE TABLE medical_record_symptoms ( 893 record_id BIGINT NOT NULL, 894 symptom_id BIGINT NOT NULL, 895 severity TEXT, 896 897 PRIMARY KEY (record_id, symptom_id), 898 899 FOREIGN KEY (record_id) 900 REFERENCES medical_records(record_id) 901 ON DELETE RESTRICT, 902 903 FOREIGN KEY (symptom_id) 904 REFERENCES symptoms(symptom_id) 905 ON DELETE RESTRICT 906 ); 907 908 CREATE TABLE medical_record_allergies ( 909 record_id BIGINT NOT NULL, 910 allergy_id BIGINT NOT NULL, 911 reaction TEXT, 912 severity TEXT, 913 914 PRIMARY KEY (record_id, allergy_id), 915 916 FOREIGN KEY (record_id) 917 REFERENCES medical_records(record_id) 918 ON DELETE RESTRICT, 919 920 FOREIGN KEY (allergy_id) 921 REFERENCES allergies(allergy_id) 922 ON DELETE RESTRICT 923 ); 924 906 bill_id BIGINT NOT NULL, 907 test_id BIGINT NOT NULL, 908 909 CONSTRAINT billing_lab_tests_PK 910 PRIMARY KEY (bill_id, test_id), 911 912 CONSTRAINT billing_lab_tests_bill_FK 913 FOREIGN KEY (bill_id) 914 REFERENCES billing(bill_id) 915 ON DELETE RESTRICT, 916 917 CONSTRAINT billing_lab_tests_test_FK 918 FOREIGN KEY (test_id) 919 REFERENCES lab_tests(test_id) 920 ON DELETE RESTRICT 921 ); 925 922 926 923 COMMIT; 927 -
sql/dml.sql
rae6cd79 r48d2bed 351 351 (126, 'WRIST_PAIN', 'Pain in wrist'); 352 352 353 INSERT INTO doctors (doctor_id, first_name, last_name, email_address, level_id, specialization_id, department_id) VALUES 354 (1, 'Ivan', 'Stojanov', 'ivan.stojanov@medora.com', 1, 1, 1), 355 (2, 'Elena', 'Kirova', 'elena.kirova@medora.com', 2, 1, 1), 356 (3, 'Nikola', 'Trajkov', 'nikola.trajkov@medora.com', 3, 1, 1), 357 (4, 'Sara', 'Dimova', 'sara.dimova@medora.com', 4, 1, 1), 358 (5, 'Marija', 'Bajramovska', 'marija.bajramovska@medora.com', 5, 1, 1), 359 (6, 'Ana', 'Petrova', 'ana.petrova@medora.com', 1, 2, 2), 360 (7, 'Petar', 'Iliev', 'petar.iliev@medora.com', 2, 2, 2), 361 (8, 'Mila', 'Stojanova', 'mila.stojanova@medora.com', 3, 2, 2), 362 (9, 'Dejan', 'Markovski', 'dejan.markovski@medora.com', 4, 2, 2), 363 (10, 'Kristina', 'Todorova', 'kristina.todorova@medora.com', 5, 2, 2), 364 (11, 'Goran', 'Spasov', 'goran.spasov@medora.com', 1, 3, 3), 365 (12, 'Ivana', 'Hristova', 'ivana.hristova@medora.com', 2, 3, 3), 366 (13, 'Bojan', 'Nikolovski', 'bojan.nikolovski@medora.com', 3, 3, 3), 367 (14, 'Tea', 'Angelova', 'tea.angelova@medora.com', 4, 3, 3), 368 (15, 'Filip', 'Jovanov', 'filip.jovanov@medora.com', 5, 3, 3), 369 (16, 'Natasha', 'Petkovska', 'natasha.petkovska@medora.com', 1, 4, 4), 370 (17, 'Viktor', 'Andreev', 'viktor.andreev@medora.com', 2, 4, 4), 371 (18, 'Sofija', 'Marinova', 'sofija.marinova@medora.com', 3, 4, 4), 372 (19, 'Luka', 'Nikolov', 'luka.nikolov@medora.com', 4, 4, 4), 373 (20, 'Marija', 'Damjanova', 'marija.damjanova@medora.com', 5, 4, 4), 374 (21, 'Katerina', 'Ilieva', 'katerina.ilieva@medora.com', 1, 5, 5), 375 (22, 'Dimitar', 'Petrov', 'dimitar.petrov@medora.com', 2, 5, 5), 376 (23, 'Jana', 'Kostova', 'jana.kostova@medora.com', 3, 5, 5), 377 (24, 'Stefan', 'Todorov', 'stefan.todorov@medora.com', 4, 5, 5), 378 (25, 'Elena', 'Markova', 'elena.markova@medora.com', 5, 5, 5), 379 (26, 'Aleksandar', 'Ristovski', 'aleksandar.ristovski@medora.com', 1, 6, 6), 380 (27, 'Ivana', 'Trajkovska', 'ivana.trajkovska@medora.com', 2, 6, 6), 381 (28, 'Goran', 'Nikolov', 'goran.nikolov@medora.com', 3, 6, 6), 382 (29, 'Mila', 'Stojkova', 'mila.stojkova@medora.com', 4, 6, 6), 383 (30, 'Bojan', 'Petrov', 'bojan.petrov@medora.com', 5, 6, 6), 384 (31, 'Petar', 'Angelov', 'petar.angelov@medora.com', 1, 7, 7), 385 (32, 'Ana', 'Dimovska', 'ana.dimovska@medora.com', 2, 7, 7), 386 (33, 'Nikola', 'Kostadinov', 'nikola.kostadinov@medora.com', 3, 7, 7), 387 (34, 'Sara', 'Petrova', 'sara.petrova@medora.com', 4, 7, 7), 388 (35, 'Marko', 'Stojanovski', 'marko.stojanovski@medora.com', 5, 7, 7), 389 (36, 'Elena', 'Markovic', 'elena.markovic@medora.com', 1, 8, 8), 390 (37, 'Ivan', 'Petrovic', 'ivan.petrovic@medora.com', 2, 8, 8), 391 (38, 'Dejan', 'Ilievski', 'dejan.ilievski@medora.com', 3, 8, 8), 392 (39, 'Kristina', 'Ristova', 'kristina.ristova@medora.com', 4, 8, 8), 393 (40, 'Filip', 'Sokolov', 'filip.sokolov@medora.com', 5, 8, 8), 394 (41, 'Goran', 'Spasovski', 'goran.spasovski@medora.com', 1, 9, 9), 395 (42, 'Ivana', 'Hristovska', 'ivana.hristovska@medora.com', 2, 9, 9), 396 (43, 'Bojan', 'Nikolovska', 'bojan.nikolovska@medora.com', 3, 9, 9), 397 (44, 'Tea', 'Angelkovska', 'tea.angelkovska@medora.com', 4, 9, 9), 398 (45, 'Luka', 'Petrovski', 'luka.petrovski@medora.com', 5, 9, 9), 399 (46, 'Marija', 'Ristova', 'marija.ristova@medora.com', 1, 10, 10), 400 (47, 'Viktor', 'Stojanovski', 'viktor.stojanovski@medora.com', 2, 10, 10), 401 (48, 'Sofija', 'Markovska', 'sofija.markovska@medora.com', 3, 10, 10), 402 (49, 'Dimitar', 'Ilievski', 'dimitar.ilievski@medora.com', 4, 10, 10), 403 (50, 'Jana', 'Petrovska', 'jana.petrovska2@medora.com', 5, 10, 10), 404 (51, 'Stefan', 'Nikolov', 'stefan.nikolov@medora.com', 1, 11, 11), 405 (52, 'Elena', 'Trajkovska', 'elena.trajkovska@medora.com', 2, 11, 11), 406 (53, 'Nikola', 'Angelov', 'nikola.angelov@medora.com', 3, 11, 11), 407 (54, 'Sara', 'Dimovska', 'sara.dimovska@medora.com', 4, 11, 11), 408 (55, 'Ivan', 'Kostov', 'ivan.kostov@medora.com', 5, 11, 11), 409 (56, 'Petar', 'Hristov', 'petar.hristov@medora.com', 1, 12, 12), 410 (57, 'Ana', 'Petrovska', 'ana.petrovska3@medora.com', 2, 12, 12), 411 (58, 'Dejan', 'Stojkov', 'dejan.stojkov@medora.com', 3, 12, 12), 412 (59, 'Kristina', 'Ristovska', 'kristina.ristovska@medora.com', 4, 12, 12), 413 (60, 'Goran', 'Nikolovski', 'goran.nikolovski@medora.com', 5, 12, 12), 414 (61, 'Ivana', 'Markov', 'ivana.markov@medora.com', 1, 13, 13), 415 (62, 'Bojan', 'Petrovski', 'bojan.petrovski1@medora.com', 2, 13, 13), 416 (63, 'Tea', 'Ilieva', 'tea.ilieva@medora.com', 3, 13, 13), 417 (64, 'Filip', 'Spasov', 'filip.spasov@medora.com', 4, 13, 13), 418 (65, 'Marija', 'Angelova', 'marija.angelova@medora.com', 5, 13, 13), 419 (66, 'Viktor', 'Kirov', 'viktor.kirov@medora.com', 1, 14, 14), 420 (67, 'Sofija', 'Petrovska', 'sofija.petrovska@medora.com', 2, 14, 14), 421 (68, 'Luka', 'Ristovski', 'luka.ristovski@medora.com', 3, 14, 14), 422 (69, 'Dimitar', 'Markov', 'dimitar.markov@medora.com', 4, 14, 14), 423 (70, 'Jana', 'Nikolova', 'jana.nikolova@medora.com', 5, 14, 14), 424 (71, 'Marko', 'Stojanov', 'marko.stojanov@medora.com', 1, 15, 15), 425 (72, 'Elena', 'Ilievska', 'elena.ilievska@medora.com', 2, 15, 15), 426 (73, 'Nikola', 'Petrov', 'nikola.petrov@medora.com', 3, 15, 15), 427 (74, 'Sara', 'Trajkovska', 'sara.trajkovska@medora.com', 4, 15, 15), 428 (75, 'Ivan', 'Dimov', 'ivan.dimov@medora.com', 5, 15, 15), 429 (76, 'Goran', 'Ristov', 'goran.ristov@medora.com', 1, 16, 16), 430 (77, 'Ivana', 'Kostadinova', 'ivana.kostadinova@medora.com', 2, 16, 16), 431 (78, 'Bojan', 'Petkov', 'bojan.petkov@medora.com', 3, 16, 16), 432 (79, 'Tea', 'Markovska', 'tea.markovska@medora.com', 4, 16, 16), 433 (80, 'Filip', 'Stojanov', 'filip.stojanov@medora.com', 5, 16, 16), 434 (81, 'Marija', 'Hristovska', 'marija.hristovska@medora.com', 1, 17, 17), 435 (82, 'Viktor', 'Iliev', 'viktor.iliev@medora.com', 2, 17, 17), 436 (83, 'Sofija', 'Petrovski', 'sofija.petrovski@medora.com', 3, 17, 17), 437 (84, 'Luka', 'Angelovska', 'luka.angelovska@medora.com', 4, 17, 17), 438 (85, 'Dimitar', 'Kirovski', 'dimitar.kirovski@medora.com', 5, 17, 17), 439 (86, 'Jana', 'Ristova', 'jana.ristova@medora.com', 1, 18, 18), 440 (87, 'Marko', 'Petrovic', 'marko.petrovic@medora.com', 2, 18, 18), 441 (88, 'Elena', 'Stojkovska', 'elena.stojkovska@medora.com', 3, 18, 18), 442 (89, 'Nikola', 'Trajkovic', 'nikola.trajkovic@medora.com', 4, 18, 18), 443 (90, 'Sara', 'Dimkovska', 'sara.dimkovska@medora.com', 5, 18, 18), 444 (91, 'Ivan', 'Spasov', 'ivan.spasov@medora.com', 1, 19, 19), 445 (92, 'Petar', 'Nikolov', 'petar.nikolov@medora.com', 2, 19, 19), 446 (93, 'Ana', 'Markovska', 'ana.markovska@medora.com', 3, 19, 19), 447 (94, 'Dejan', 'Iliev', 'dejan.iliev@medora.com', 4, 19, 19), 448 (95, 'Kristina', 'Petrova', 'kristina.petrova@medora.com', 5, 19, 19), 449 (96, 'Goran', 'Stojanovski', 'goran.stojanovski@medora.com', 1, 20, 20), 450 (97, 'Ivana', 'Hristova', 'ivana.hristova1@medora.com', 2, 20, 20), 451 (98, 'Bojan', 'Kostov', 'bojan.kostov@medora.com', 3, 20, 20), 452 (99, 'Tea', 'Petrovska', 'tea.petrovska@medora.com', 4, 20, 20), 453 (100, 'Filip', 'Ristovski', 'filip.ristovski@medora.com', 5, 20, 20), 454 (101, 'Marija', 'Angelovska', 'marija.angelovska@medora.com', 1, 21, 21), 455 (102, 'Viktor', 'Markovski', 'viktor.markovski@medora.com', 2, 21, 21), 456 (103, 'Sofija', 'Petrova', 'sofija.petrova@medora.com', 3, 21, 21), 457 (104, 'Luka', 'Ilievski', 'luka.ilievski@medora.com', 4, 21, 21), 458 (105, 'Dimitar', 'Stojanov', 'dimitar.stojanov@medora.com', 5, 21, 21), 459 (106, 'Jana', 'Kirovska', 'jana.kirovska@medora.com', 1, 22, 22), 460 (107, 'Marko', 'Petkov', 'marko.petkov@medora.com', 2, 22, 22), 461 (108, 'Elena', 'Ristova', 'elena.ristova@medora.com', 3, 22, 22), 462 (109, 'Nikola', 'Dimov', 'nikola.dimov@medora.com', 4, 22, 22), 463 (110, 'Sara', 'Nikolova', 'sara.nikolova@medora.com', 5, 22, 22), 464 (111, 'Ivan', 'Trajkov', 'ivan.trajkov@medora.com', 1, 23, 23), 465 (112, 'Petar', 'Stojkov', 'petar.stojkov@medora.com', 2, 23, 23), 466 (113, 'Ana', 'Petrovska', 'ana.petrovska1@medora.com', 3, 23, 23), 467 (114, 'Dejan', 'Markov', 'dejan.markov@medora.com', 4, 23, 23), 468 (115, 'Kristina', 'Ilieva', 'kristina.ilieva@medora.com', 5, 23, 23), 469 (116, 'Filip', 'Kostadinov', 'filip.kostadinov@medora.com', 1, 24, 24), 470 (117, 'Ivana', 'Spasova', 'ivana.spasova@medora.com', 2, 24, 24), 471 (118, 'Bojan', 'Petrovski', 'bojan.petrovski2@medora.com', 3, 24, 24), 472 (119, 'Teodora', 'Angelova', 'teodora.angelova@medora.com', 4, 24, 24), 473 (120, 'Mila', 'Lukanovska', 'mila.lukanovska@medora.com', 5, 24, 24); 353 INSERT 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 526 SELECT setval('users_user_id_seq', (SELECT MAX(user_id) FROM users)); 527 528 INSERT 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); 474 649 475 650 476 651 INSERT INTO patients ( 477 652 patient_id, first_name, last_name, email_address, date_of_birth, 478 blood_type, gender, phone_number, embg 653 blood_type, gender, phone_number, embg, user_id 479 654 ) VALUES 480 (1, 'Maja', 'Veljanova', 'maja.veljanova@gmail.com', '1994-02-14', 'A+', 'FEMALE', '070111222', '1402994123456'), 481 (2, 'Kristijan', 'Bojkov', 'kristijan.bojkov@gmail.com', '1991-06-21', 'O-', 'MALE', '071222333', '2106991123457'), 482 (3, 'Tamara', 'Gorgieva', 'tamara.gorgieva@gmail.com', '2000-11-03', 'B+', 'FEMALE', '072333444', '0311000123458'), 483 (4, 'Aleks', 'Nikolovski', 'aleks.nikolovski@gmail.com', '1988-09-10', 'AB+', 'MALE', '073444555', '1009988123459'), 484 (5, 'Sara', 'Milevska', 'sara.milevska@gmail.com', '1997-12-25', 'A-', 'FEMALE', '074555666', '2512997123460'), 485 (6, 'Stefan', 'Arsovski', 'stefan.arsovski@gmail.com', '1993-04-18', 'O+', 'MALE', '075666777', '1804993123461'), 486 (7, 'Elena', 'Petreska', 'elena.petreska@gmail.com', '1999-07-09', 'B-', 'FEMALE', '076777888', '0907999123462'), 487 (8, 'Viktor', 'Stankov', 'viktor.stankov@gmail.com', '1990-01-30', 'A+', 'MALE', '077888999', '3001990123463'), 488 (9, 'Ivana', 'Dimitrova', 'ivana.dimitrova@gmail.com', '1995-05-12', 'O-', 'FEMALE', '078999111', '1205995123464'), 489 (10, 'Marko', 'Lazarevski', 'marko.lazarevski@gmail.com', '1987-08-22', 'AB-', 'MALE', '070123456', '2208987123465'), 490 (11, 'Jana', 'Trajkovska', 'jana.trajkovska@gmail.com', '2001-03-17', 'A+', 'FEMALE', '071234567', '1703001123466'), 491 (12, 'Petar', 'Kostov', 'petar.kostov@gmail.com', '1992-10-05', 'B+', 'MALE', '072345678', '0510992123467'), 492 (13, 'Ana', 'Ristova', 'ana.ristova@gmail.com', '1996-06-28', 'O+', 'FEMALE', '073456789', '2806996123468'), 493 (14, 'Nikola', 'Sokolov', 'nikola.sokolov@gmail.com', '1989-02-11', 'A-', 'MALE', '074567890', '1102989123469'), 494 (15, 'Mila', 'Petrova', 'mila.petrova@gmail.com', '2002-09-19', 'AB+', 'FEMALE', '075678901', '1909022123470'), 495 (16, 'Dejan', 'Ilievski', 'dejan.ilievski@gmail.com', '1994-11-11', 'O+', 'MALE', '076789012', '1111994123471'), 496 (17, 'Kristina', 'Markovska', 'kristina.markovska@gmail.com', '1998-01-14', 'B+', 'FEMALE', '077890123', '1401988123472'), 497 (18, 'Goran', 'Petrov', 'goran.petrov@gmail.com', '1986-07-07', 'A+', 'MALE', '078901234', '0707986123473'), 498 (19, 'Sofija', 'Nikolova', 'sofija.nikolova@gmail.com', '2000-12-02', 'O-', 'FEMALE', '070112233', '0212000123474'), 499 (20, 'Dimitar', 'Angelov', 'dimitar.angelov@gmail.com', '1991-03-03', 'B-', 'MALE', '071223344', '0303991123475'), 500 (21, 'Teodora', 'Hristova', 'teodora.hristova@gmail.com', '1997-08-08', 'A+', 'FEMALE', '072334455', '0808997123476'), 501 (22, 'Filip', 'Stojanov', 'filip.stojanov@gmail.com', '1993-05-15', 'AB+', 'MALE', '073445566', '1505993123477'), 502 (23, 'Marija', 'Kirovska', 'marija.kirovska@gmail.com', '1999-10-10', 'O+', 'FEMALE', '074556677', '1010999123478'), 503 (24, 'Ivan', 'Bojkov', 'ivan.bojkov@gmail.com', '1988-12-12', 'A-', 'MALE', '075667788', '1212988123479'), 504 (25, 'Lina', 'Petrovska', 'lina.petrovska@gmail.com', '2001-04-04', 'B+', 'FEMALE', '076778899', '0404001123480'), 505 (26, 'Bojan', 'Spasov', 'bojan.spasov@gmail.com', '1992-02-20', 'O+', 'MALE', '077889900', '2002992123481'), 506 (27, 'Ana', 'Dimovska', 'ana.dimovska@gmail.com', '1995-09-09', 'A+', 'FEMALE', '078990011', '0909995123482'), 507 (28, 'Vladimir', 'Ristovski', 'vladimir.ristovski@gmail.com', '1987-06-16', 'AB-', 'MALE', '070998877', '1606987123483'), 508 (29, 'Katerina', 'Todorova', 'katerina.todorova@gmail.com', '2003-01-01', 'O-', 'FEMALE', '071887766', '0101033123484'), 509 (30, 'Martin', 'Iliev', 'martin.iliev@gmail.com', '1990-11-23', 'B+', 'MALE', '072776655', '2311990123485'), 510 (31, 'Elena', 'Trajkov', 'elena.trajkov@gmail.com', '1996-03-13', 'A-', 'FEMALE', '073665544', '1303996123486'), 511 (32, 'Aleksandar', 'Petrovski', 'aleksandar.petrovski@gmail.com', '1994-07-27', 'O+', 'MALE', '074554433', '2707994123487'), 512 (33, 'Maja', 'Stojanovska', 'maja.stojanovska@gmail.com', '1998-09-18', 'B-', 'FEMALE', '075443322', '1809998123488'), 513 (34, 'Nikola', 'Gligorov', 'nikola.gligorov@gmail.com', '1989-05-05', 'A+', 'MALE', '076332211', '0505989123489'), 514 (35, 'Sara', 'Ilieva', 'sara.ilieva@gmail.com', '2002-12-12', 'AB+', 'FEMALE', '077221100', '1212022123490'), 515 (36, 'Petar', 'Markovski', 'petar.markovski@gmail.com', '1993-03-03', 'O+', 'MALE', '078110099', '0303993123491'), 516 (37, 'Ivana', 'Petrovska', 'ivana.petrovska@gmail.com', '1997-07-07', 'A-', 'FEMALE', '070223344', '0707997123492'), 517 (38, 'Goran', 'Nikolovski', 'goran.nikolovski@gmail.com', '1986-10-10', 'B+', 'MALE', '071334455', '1010986123493'), 518 (39, 'Jana', 'Ristova', 'jana.ristova@gmail.com', '2000-01-20', 'O-', 'FEMALE', '072445566', '2001000123494'); 519 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); 520 694 521 695 … … 525 699 name, 526 700 lastname, 527 email 701 email, 702 user_id 528 703 ) VALUES 529 ( 1, 'admin_ilija', 'Ilija', 'Stojanov', 'ilija.stojanov@adminmedora.com'),530 ( 2, 'admin_elena', 'Elena', 'Kirova', 'elena.kirova@adminmedora.com'),531 ( 3, 'admin_marjan', 'Marjan', 'Petrov', 'marjan.petrov@adminmedora.com'),532 ( 4, 'admin_vesna', 'Vesna', 'Dimova', 'vesna.dimova@adminmedora.com'),533 ( 5, 'admin_dushanka', 'Dushanka', 'Trajkovska', 'drushanka.trajkovska@adminmedora.com');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); 534 709 535 710 … … 539 714 name, 540 715 lastname, 541 email 716 email, 717 user_id 542 718 ) VALUES 543 (1, 'lab_darko', 'Darko', 'Milosev', 'darko.milosev@labmedora.com'), 544 (2, 'lab_biljana', 'Biljana', 'Trajkovska', 'biljana.trajkovska@labmedora.com'), 545 (3, 'lab_stefan', 'Stefan', 'Nikolovski', 'stefan.nikolovski@labmedora.com'), 546 (4, 'lab_marina', 'Marina', 'Petreska', 'marina.petreska@labmedora.com'), 547 (5, 'lab_aleksandar', 'Aleksandar', 'Ristovski', 'aleksandar.ristovski@labmedora.com'); 548 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); 549 724 550 725 … … 772 947 773 948 774 775 INSERT INTO procedures (procedure_id, procedure_type, procedure_date, description, cost, doctor_id, diagnosis_id) VALUES 776 (1, 'Spirometry', '2026-01-10', 'Lung function test measuring airflow', 50, 1, 4), 777 (2, 'Bronchoscopy', '2026-01-10', 'Endoscopic examination of airways', 200, 1, 4), 778 (3, 'Body plethysmography', '2026-01-11', 'Measurement of lung volumes', 180, 1, 5), 779 (4, 'Diffusion capacity test (DLCO)', '2026-01-11', 'Gas exchange efficiency test', 120, 1, 106), 780 (5, 'Peak flow measurement', '2026-01-12', 'Maximum exhalation speed test', 30, 1, 4), 781 (6, 'Blood gas analysis', '2026-01-12', 'Oxygen and CO2 level test', 70, 1, 5), 782 (7, 'Allergy testing', '2026-01-13', 'Identification of respiratory allergens', 90, 2, 94), 783 (8, 'Bronchodilator test', '2026-01-13', 'Asthma response test after medication', 80, 1, 4), 784 (9, 'ECG', '2026-01-14', 'Electrical heart activity recording', 40, 2, 74), 785 (10, 'Echocardiography', '2026-01-14', 'Ultrasound of the heart', 120, 2, 75), 786 (11, 'Stress test', '2026-01-15', 'Heart performance under exercise', 100, 2, 74), 787 (12, 'Holter ECG', '2026-01-15', '24h heart rhythm monitoring', 150, 2, 76), 788 (13, 'Blood pressure Holter', '2026-01-16', '24h blood pressure monitoring', 140, 2, 1), 789 (14, 'Cardiac catheterization', '2026-01-16', 'Invasive heart vessel examination', 600, 2, 74), 790 (15, 'Coronary angiography', '2026-01-17', 'Imaging of coronary arteries', 700, 2, 74), 791 (16, 'Transesophageal echo', '2026-01-17', 'Internal heart ultrasound', 300, 2, 75), 792 (17, 'EEG', '2026-01-18', 'Brain electrical activity test', 100, 3, 7), 793 (18, 'EMG', '2026-01-18', 'Muscle electrical activity test', 120, 3, 113), 794 (19, 'Evoked potentials', '2026-01-19', 'Nerve response measurement', 130, 3, 113), 795 (20, 'Lumbar puncture', '2026-01-19', 'CSF fluid collection from spine', 250, 3, 82), 796 (21, 'Nerve conduction study', '2026-01-20', 'Nerve signal speed test', 110, 3, 113), 797 (22, 'Carotid Doppler', '2026-01-20', 'Blood flow in neck arteries', 140, 3, 84), 798 (23, 'Arthroscopy', '2026-01-21', 'Joint inspection using camera', 500, 4, 11), 799 (24, 'Hip replacement', '2026-01-21', 'Surgical hip joint replacement', 5000, 4, 11), 800 (25, 'Knee replacement', '2026-01-22', 'Surgical knee joint replacement', 4800, 4, 11), 801 (26, 'Fracture fixation', '2026-01-22', 'Bone stabilization surgery', 1200, 4, 13), 802 (27, 'Ligament reconstruction', '2026-01-23', 'Repair of torn ligaments', 2500, 4, 11), 803 (28, 'Spine surgery', '2026-01-23', 'Surgical spinal intervention', 6000, 4, 14), 804 (29, 'Gynecological ultrasound', '2026-01-24', 'Ultrasound of female reproductive system', 80, 5, 139), 805 (30, 'Pap smear', '2026-01-24', 'Cervical cancer screening test', 60, 5, 31), 806 (31, 'Colposcopy', '2026-01-25', 'Detailed cervix examination', 120, 5, 31), 807 (32, 'Hysteroscopy', '2026-01-25', 'Uterine cavity inspection', 300, 5, 140), 808 (33, 'Laparoscopy', '2026-01-26', 'Minimally invasive abdominal surgery', 700, 5, 139), 809 (34, 'Cesarean section', '2026-01-26', 'Surgical delivery of baby', 1500, 5, 34), 810 (35, 'Delivery', '2026-01-27', 'Natural childbirth', 800, 5, 35), 811 (36, 'Cervical biopsy', '2026-01-27', 'Tissue sampling from cervix', 200, 5, 30), 812 (37, 'Audiometry', '2026-01-28', 'Hearing test', 50, 6, 60), 813 (38, 'Tympanometry', '2026-01-28', 'Middle ear function test', 60, 6, 57), 814 (39, 'Nasal endoscopy', '2026-01-29', 'Nasal cavity examination', 120, 6, 59), 815 (40, 'Laryngoscopy', '2026-01-29', 'Throat and voice box examination', 130, 6, 58), 816 (41, 'Tonsillectomy', '2026-01-30', 'Removal of tonsils', 400, 6, 58), 817 (42, 'Sinus surgery', '2026-01-30', 'Surgical sinus treatment', 1200, 6, 59), 818 (43, 'Vision exam', '2026-02-01', 'Eye vision testing', 40, 7, 60), 819 (44, 'Optical coherence tomography', '2026-02-01', 'Retina imaging', 150, 7, 63), 820 (45, 'Perimetry', '2026-02-02', 'Visual field test', 70, 7, 62), 821 (46, 'Cataract surgery', '2026-02-02', 'Lens replacement surgery', 2000, 7, 61), 822 (47, 'Laser eye surgery', '2026-02-03', 'Vision correction procedure', 2500, 7, 61), 823 (48, 'Complete blood count', '2026-02-03', 'Basic blood analysis', 30, 8, 41), 824 (49, 'Biochemistry panel', '2026-02-04', 'Blood chemical analysis', 50, 8, 2), 825 (50, 'Coagulation tests', '2026-02-04', 'Blood clotting tests', 60, 8, 43), 826 (51, 'Hormone tests', '2026-02-05', 'Hormonal level analysis', 80, 8, 47), 827 (52, 'Microbiology tests', '2026-02-05', 'Infection detection tests', 90, 8, 40), 828 (53, 'PCR test', '2026-02-06', 'DNA/RNA detection test', 100, 8, 36), 829 (54, 'X-ray', '2026-02-06', 'Basic imaging scan', 50, 9, 13), 830 (55, 'CT scan', '2026-02-07', 'Cross-sectional imaging', 200, 9, 13), 831 (56, 'MRI', '2026-02-07', 'Magnetic resonance imaging', 350, 9, 7), 832 (57, 'Ultrasound', '2026-02-08', 'Sound wave imaging', 70, 9, 139), 833 (58, 'Mammography', '2026-02-08', 'Breast imaging', 120, 9, 26), 834 (59, 'Interventional radiology', '2026-02-09', 'Image-guided procedures', 800, 9, 74), 835 (60, 'Gastroscopy', '2026-02-09', 'Stomach camera examination', 200, 10, 16), 836 (61, 'Colonoscopy', '2026-02-10', 'Colon examination', 300, 10, 121), 837 (62, 'Biopsy', '2026-02-10', 'Tissue sampling', 250, 10, 26), 838 (63, 'ERCP', '2026-02-11', 'Bile duct procedure', 600, 10, 20), 839 (64, 'Abdominal ultrasound', '2026-02-11', 'Abdominal organ imaging', 90, 9, 19), 840 (65, 'Urinary tract ultrasound', '2026-02-12', 'Kidney and bladder imaging', 90, 9, 23), 841 (66, 'Cystoscopy', '2026-02-12', 'Bladder examination', 200, 11, 23), 842 (67, 'Urodynamic testing', '2026-02-13', 'Urine flow analysis', 150, 11, 134), 843 (68, 'Lithotripsy', '2026-02-13', 'Kidney stone breaking', 500, 11, 25), 844 (69, 'TURP', '2026-02-14', 'Prostate surgery', 1200, 11, 131), 845 (70, 'Prostate biopsy', '2026-02-14', 'Prostate tissue sampling', 250, 11, 131), 846 (71, 'Hemodialysis', '2026-02-15', 'Blood cleaning procedure', 200, 12, 22), 847 (72, 'Peritoneal dialysis', '2026-02-15', 'Abdominal dialysis', 180, 12, 22), 848 (73, 'Kidney biopsy', '2026-02-16', 'Kidney tissue sampling', 300, 12, 21), 849 (74, 'Renal clearance tests', '2026-02-16', 'Kidney function tests', 100, 12, 22), 850 (75, 'Electrolyte tests', '2026-02-17', 'Blood mineral analysis', 60, 12, 100), 851 (76, 'Chemotherapy', '2026-02-17', 'Cancer drug treatment', 2000, 13, 26), 852 (77, 'Radiotherapy', '2026-02-18', 'Radiation cancer treatment', 2500, 13, 27), 853 (78, 'Tumor biopsy', '2026-02-18', 'Cancer tissue sampling', 400, 13, 26), 854 (79, 'PET scan', '2026-02-19', 'Cancer imaging scan', 900, 9, 26), 855 (80, 'Immunotherapy', '2026-02-19', 'Immune cancer treatment', 3000, 13, 28), 856 (81, 'Dermatological exam', '2026-02-20', 'Skin examination', 50, 14, 31), 857 (82, 'Dermatoscopy', '2026-02-20', 'Skin lesion imaging', 80, 14, 30), 858 (83, 'Skin biopsy', '2026-02-21', 'Skin tissue sampling', 200, 14, 31), 859 (84, 'Cryotherapy', '2026-02-21', 'Freezing skin treatment', 150, 14, 34), 860 (85, 'Laser treatments', '2026-02-22', 'Skin laser therapy', 500, 14, 34), 861 (86, 'Pediatric exam', '2026-02-22', 'Child medical checkup', 60, 15, 1), 862 (87, 'Vaccination', '2026-02-23', 'Immunization procedure', 40, 15, 1), 863 (88, 'Neonatal screening', '2026-02-23', 'Newborn testing', 100, 15, 1), 864 (89, 'Growth assessment', '2026-02-24', 'Child development check', 50, 15, 1), 865 (90, 'Psychiatric evaluation', '2026-02-24', 'Mental health assessment', 120, 16, 51), 866 (91, 'Psychotherapy', '2026-02-25', 'Therapy sessions', 100, 16, 51), 867 (92, 'Cognitive testing', '2026-02-25', 'Brain function testing', 80, 16, 54), 868 (93, 'Pharmacotherapy', '2026-02-26', 'Psychiatric medication treatment', 150, 16, 51), 869 (94, 'Physiotherapy', '2026-02-26', 'Physical rehabilitation treatment', 80, 17, 11), 870 (95, 'Kinesiotherapy', '2026-02-27', 'Movement-based therapy', 90, 17, 11), 871 (96, 'Electrotherapy', '2026-02-27', 'Electrical stimulation therapy', 70, 17, 72), 872 (97, 'Hydrotherapy', '2026-02-28', 'Water-based rehabilitation therapy', 100, 17, 72), 873 (98, 'Blood count', '2026-03-01', 'Detailed blood cell analysis', 40, 8, 41), 874 (99, 'Bone marrow biopsy', '2026-03-01', 'Bone marrow sampling', 400, 8, 43), 875 (100, 'Coagulation studies', '2026-03-02', 'Blood clotting analysis', 80, 8, 43), 876 (101, 'Blood transfusion', '2026-03-02', 'Transfer of blood products', 300, 8, 45), 877 (102, 'Serology tests', '2026-03-03', 'Antibody detection tests', 90, 8, 36), 878 (103, 'PCR diagnostics', '2026-03-03', 'Molecular infection detection', 120, 8, 40), 879 (104, 'Microbial cultures', '2026-03-04', 'Bacteria growth testing', 100, 8, 40), 880 (105, 'Antibiotic therapy', '2026-03-04', 'Infection treatment with antibiotics', 200, 1, 40), 881 (106, 'Brain surgery', '2026-03-05', 'Surgical brain intervention', 8000, 3, 82), 882 (107, 'Spine surgery', '2026-03-05', 'Surgical spinal operation', 7000, 4, 117), 883 (108, 'Tumor removal', '2026-03-06', 'Removal of brain tumors', 9000, 3, 82), 884 (109, 'Shunt procedure', '2026-03-06', 'CSF drainage surgery', 6000, 3, 82), 885 (110, 'CABG', '2026-03-07', 'Heart bypass surgery', 10000, 2, 74), 886 (111, 'Valve replacement', '2026-03-07', 'Heart valve surgery', 9500, 2, 75), 887 (112, 'Pacemaker implantation', '2026-03-08', 'Heart rhythm device installation', 5000, 2, 76), 888 (113, 'Reconstructive surgery', '2026-03-08', 'Restoration of body structures', 4000, 4, 35), 889 (114, 'Cosmetic surgery', '2026-03-09', 'Aesthetic body improvement', 3500, 14, 33), 890 (115, 'Liposuction', '2026-03-09', 'Fat removal procedure', 3000, 14, 66), 891 (116, 'Rhinoplasty', '2026-03-10', 'Nose reshaping surgery', 3200, 6, 35), 892 (117, 'Appendectomy', '2026-03-10', 'Appendix removal surgery', 1500, 10, 19), 893 (118, 'Hernia repair', '2026-03-11', 'Hernia correction surgery', 1800, 10, 90), 894 (119, 'Gallbladder removal', '2026-03-11', 'Cholecystectomy procedure', 2000, 10, 20), 895 (120, 'Surgical biopsy', '2026-03-12', 'Tissue sampling surgery', 900, 13, 26), 896 (121, 'Tooth extraction', '2026-03-12', 'Removal of tooth', 100, 18, 35), 897 (122, 'Dental filling', '2026-03-13', 'Cavity repair', 120, 18, 35), 898 (123, 'Dental implants', '2026-03-13', 'Artificial tooth implantation', 1500, 18, 35), 899 (124, 'Teeth cleaning', '2026-03-14', 'Dental plaque removal', 80, 18, 35); 949 INSERT 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); 900 1074 901 1075 … … 1128 1302 1129 1303 INSERT INTO billing (bill_id, total_cost, payment_status, payment_date, record_id, admin_id) VALUES 1130 (1, 230, 'PAID', '2026-05-11', 1, 1),1131 (2, 340, 'PENDING', NULL, 2, 1),1132 (3, 900, 'PAID', '2026-05-10', 3, 2),1133 (4, 5200, 'PAID', '2026-05-09', 4, 1),1134 (5, 180, 'PAID', '2026-05-08', 5, 3),1135 (6, 420, 'PENDING', NULL, 6, 2),1136 (7, 160, 'PAID', '2026-05-07', 7, 3),1137 (8, 780, 'PENDING', NULL, 8, 1),1138 (9, 250, 'PAID', '2026-05-06', 9, 2),1139 (10, 610, 'PENDING', NULL, 10, 3);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); 1140 1314 1141 1315 1142 1316 INSERT INTO patient_allergies (patient_id, allergy_id) VALUES 1143 -- Patient 1 allergies 1144 (1, 1), -- Penicillin 1145 (1, 3), -- Dust 1146 -- Patient 2 allergies 1147 (2, 2), -- Peanuts 1148 (2, 5), -- Pollen 1149 -- Patient 3 allergies 1150 (3, 4), -- Lactose 1151 -- Patient 4 allergies 1152 (4, 1), -- Penicillin 1153 (4, 6), -- Bee sting 1154 -- Patient 5 allergies 1155 (5, 3), -- Dust 1156 (5, 2), -- Peanuts 1157 -- Patient 6 allergies 1158 (6, 7), -- Shellfish 1159 -- Patient 7 allergies 1160 (7, 5), -- Pollen 1161 (7, 8), -- Latex 1162 -- Patient 8 allergies 1163 (8, 4), -- Lactose 1164 (8, 1), -- Penicillin 1165 -- Patient 9 allergies 1166 (9, 6), -- Bee sting 1167 -- Patient 10 allergies 1168 (10, 2); -- Peanuts 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); 1169 1333 1170 1334 1171 1335 INSERT INTO allergy_prescription_restrictions (allergy_id, restriction_id) VALUES 1172 -- Penicillin allergy restrictions 1173 (1, 1), -- avoid Amoxicillin-based drugs 1174 (1, 2), -- avoid Ampicillin-based drugs 1175 -- Peanuts allergy restrictions 1176 (2, 3), -- avoid capsule-based allergens 1177 (2, 4), -- avoid certain oral suspensions with traces 1178 -- Dust allergy restrictions 1179 (3, 5), -- avoid inhaled powder medications 1180 -- Lactose allergy restrictions 1181 (4, 6), -- avoid lactose-containing tablets 1182 -- Pollen allergy restrictions 1183 (5, 5), -- avoid inhalation-based medications 1184 -- Bee sting allergy restrictions 1185 (6, 7), -- avoid adrenaline-triggering compounds unless emergency 1186 (6, 8), -- caution with immunotherapy drugs 1187 -- Shellfish allergy restrictions 1188 (7, 3), -- capsule-based restrictions (gelatin overlap) 1189 (7, 9), -- contrast media precaution 1190 -- Latex allergy restrictions 1191 (8, 10), -- avoid latex-containing medical devices 1192 -- Mixed severe allergies 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), 1193 1348 (1, 6), 1194 1349 (2, 6), … … 1197 1352 1198 1353 INSERT INTO patient_symptoms (patient_id, symptom_id) VALUES 1199 -- Patient 1 1200 (1, 1), -- Fever 1201 (1, 2), -- Cough 1202 (1, 5), -- Fatigue 1203 -- Patient 2 1204 (2, 3), -- Headache 1205 (2, 4), -- Sore throat 1206 -- Patient 3 1207 (3, 6), -- Shortness of breath 1208 (3, 2), -- Cough 1209 -- Patient 4 1210 (4, 7), -- Chest pain 1211 (4, 5), -- Fatigue 1212 -- Patient 5 1213 (5, 8), -- Nausea 1214 (5, 9), -- Dizziness 1215 -- Patient 6 1216 (6, 1), -- Fever 1217 (6, 6), -- Shortness of breath 1218 -- Patient 7 1219 (7, 10), -- Joint pain 1220 (7, 5), -- Fatigue 1221 -- Patient 8 1222 (8, 3), -- Headache 1223 (8, 9), -- Dizziness 1224 -- Patient 9 1225 (9, 4), -- Sore throat 1226 (9, 2), -- Cough 1227 -- Patient 10 1228 (10, 11), -- Skin rash 1229 (10, 5); -- Fatigue 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); 1230 1375 1231 1376 INSERT INTO diagnosis_symptoms (diagnosis_id, symptom_id) VALUES … … 1274 1419 (7,20); 1275 1420 1276 INSERT INTO diagnosis_procedures (diagnosis_id, procedure_id) VALUES1277 (1,1),1278 (1,2),1279 (2,3),1280 (2,4),1281 (3,5),1282 (3,6),1283 (4,7),1284 (4,8),1285 (5,9),1286 (5,10),1287 (6,11),1288 (6,12),1289 (7,13),1290 (7,14),1291 (8,15),1292 (8,16),1293 (9,17),1294 (9,18),1295 (10,19),1296 (10,20);1297 1298 1421 INSERT INTO department_procedures (department_id, procedure_id) VALUES 1299 1422 (1,1), … … 1360 1483 (9,1), 1361 1484 (10,2); 1362 1363 INSERT INTO doctor_medical_records (doctor_id, record_id) VALUES1364 (1,1),1365 (1,2),1366 (1,3),1367 (2,4),1368 (2,5),1369 (2,6),1370 (3,7),1371 (3,8),1372 (3,9),1373 (4,10),1374 (4,11),1375 (5,12),1376 (5,13),1377 (6,14),1378 (6,15);1379 1485 1380 1486 INSERT INTO diagnosis_medical_records (diagnosis_id, record_id) VALUES … … 1522 1628 1523 1629 INSERT INTO medical_record_symptoms (record_id, symptom_id, severity) VALUES 1524 1525 1526 1527 1528 1529 1530 1531 1532 1533 1534 1535 1536 1537 1538 1539 1540 1541 1542 1543 1544 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'); 1545 1651 1546 1652 INSERT INTO medical_record_allergies (record_id, allergy_id, reaction, severity) VALUES … … 1567 1673 1568 1674 COMMIT; 1569
Note:
See TracChangeset
for help on using the changeset viewer.
