final

Tables (10)

ADMIN

  • user_id — BIGINT
  • department — VARCHAR(100)

AI_PRE_DIAGNOSIS

  • pre_diagnosis_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • input_symptoms — TEXT — NOT NULL
  • priority_diseases — TEXT
  • reasoning — TEXT
  • recommended_hospital_type — VARCHAR(100)
  • created_at — TIMESTAMP

APPOINTMENT

  • appointment_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • hospital_id — BIGINT
  • appointment_time — TIMESTAMP — NOT NULL
  • appointment_type — VARCHAR(50)
  • status — VARCHAR(50)
  • notes — TEXT

DOCTOR

  • user_id — BIGINT
  • hospital_id — BIGINT
  • specialty — VARCHAR(100)
  • license_number — VARCHAR(100)

HOSPITAL

  • hospital_id — BIGINT
  • name — VARCHAR(255) — NOT NULL
  • type — VARCHAR(100)
  • address — VARCHAR(255) — NOT NULL
  • latitude — VARCHAR(50)
  • longitude — VARCHAR(50)
  • phone — VARCHAR(50)
  • specialties — TEXT

IOT_DATA

  • data_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • device_type — VARCHAR(100) — NOT NULL
  • value — VARCHAR(255) — NOT NULL
  • measured_at — TIMESTAMP — NOT NULL
  • encrypted_data — TEXT

PATIENT

  • user_id — BIGINT
  • dob — DATE
  • gender — VARCHAR(10)
  • address — VARCHAR(255)
  • medical_history — TEXT
  • lifestyle_habits — TEXT

PATIENT_SCHEDULE

  • schedule_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • event_time — TIMESTAMP — NOT NULL
  • event_type — VARCHAR(50) — NOT NULL
  • related_id — BIGINT

USERS

  • user_id — BIGINT
  • login_id — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(50) — NOT NULL
  • email — VARCHAR(150)
  • user_type — VARCHAR(20) — NOT NULL
  • use_voice_interface — BOOLEAN
  • language_preference — VARCHAR(10)
  • created_at — TIMESTAMP

VOICE_CHAT_LOG

  • log_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • transcribed_text — TEXT
  • intent — VARCHAR(255)
  • response_text — TEXT
  • created_at — TIMESTAMP