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