db_2

Tables (11)

admin_users

  • admin_id — INT
  • admin_login_id — VARCHAR(50)
  • admin_password_hash — VARCHAR(255)
  • admin_name — VARCHAR(100)

ambulances

  • ambulance_id — INT
  • ambulance_plate_number — VARCHAR(20)
  • ambulance_status — VARCHAR(20)
  • current_lat — DECIMAL(10, 8)
  • current_lon — DECIMAL(11, 8)

emergency_cases

  • case_id — INT
  • ambulance_id — INT
  • p_name — VARCHAR(100)
  • p_age — INT
  • p_gender — CHAR(1)
  • p_ssn — VARCHAR(20)
  • p_phone — VARCHAR(20)
  • case_symptoms — TEXT
  • case_ktas_level — INT
  • case_consciousness_level — INT
  • case_lat — DECIMAL(10, 8)
  • case_lon — DECIMAL(11, 8)
  • case_status — VARCHAR(20)
  • case_created_at — TIMESTAMP

hospital_beds

  • bed_id — INT
  • hospital_id — INT
  • bed_category — VARCHAR(20)
  • bed_total_count — INT
  • bed_available_count — INT
  • bed_updated_at — TIMESTAMP

hospital_rejection_logs

  • log_id — INT
  • transfer_id — INT
  • rejection_reason — VARCHAR(255)
  • rejected_at — TIMESTAMP

hospital_specialties

  • specialty_id — INT
  • hospital_id — INT
  • specialty_name — VARCHAR(50)

hospitals

  • hospital_id — INT
  • hospital_name — VARCHAR(100)
  • hospital_address — VARCHAR(255)
  • hospital_latitude — DECIMAL(10, 8)
  • hospital_longitude — DECIMAL(11, 8)
  • hospital_phone — VARCHAR(20)
  • hospital_has_ct — BOOLEAN
  • hospital_is_active — BOOLEAN

medicals

  • medical_id — INT
  • medical_login_id — VARCHAR(50)
  • medical_password_hash — VARCHAR(255)
  • medical_name — VARCHAR(100)
  • hospital_id — INT

paramedics

  • paramedic_id — INT
  • paramedic_login_id — VARCHAR(50)
  • paramedic_password_hash — VARCHAR(255)
  • paramedic_name — VARCHAR(100)
  • ambulance_id — INT

patients

  • patient_id — INT
  • hospital_id — INT
  • patient_name — VARCHAR(100)
  • patient_age — INT
  • patient_gender — CHAR(1)
  • patient_ssn — VARCHAR(20)
  • patient_phone — VARCHAR(20)
  • assigned_bed_category — VARCHAR(20)
  • admission_time — TIMESTAMP

transfer_requests

  • transfer_id — INT
  • case_id — INT
  • hospital_id — INT
  • transfer_status — VARCHAR(20)
  • transfer_eta_seconds — INT
  • created_at — TIMESTAMP