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