s

Tables (5)

app_user

  • user_id — INT — Primary key — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • user_type — ENUM('PATIENT', 'STAFF') — NOT NULL
  • created_at — DATETIME — NOT NULL

feedback

  • feedback_id — INT — Primary key — NOT NULL
  • utt_id — INT — Foreign key → utterance.utt_id — NOT NULL
  • final_text — VARCHAR(200) — NOT NULL
  • created_at — DATETIME — NOT NULL

phrase

  • phrase_id — INT — Primary key — NOT NULL
  • phrase_text — VARCHAR(100) — NOT NULL
  • category — ENUM('PAIN', 'REQUEST', 'REPLY', 'ETC') — NOT NULL
  • use_count — INT — NOT NULL

session

  • session_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → app_user.user_id — NOT NULL
  • mode — ENUM('CLOSED', 'OPEN') — NOT NULL
  • device_info — VARCHAR(100)
  • started_at — DATETIME — NOT NULL
  • ended_at — DATETIME

utterance

  • utt_id — INT — Primary key — NOT NULL
  • session_id — INT — Foreign key → session.session_id — NOT NULL
  • phrase_id — INT — Foreign key → phrase.phrase_id
  • raw_text — VARCHAR(200) — NOT NULL
  • corrected_text — VARCHAR(200)
  • confidence — DECIMAL(4,3) — NOT NULL
  • tts_played — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL