CHANG3
Tables (8)
pitch_scores
- ID — VARCHAR(255) — Primary key — NOT NULL
- SCRIPT_ID — VARCHAR(255) — Primary key — NOT NULL
- USER_ID — BIGINT — Primary key — NOT NULL
- SESSION_ID — INTEGER — Primary key — NOT NULL
- line_id — INTEGER — NOT NULL
- pitch_accuracy — INTEGER — NOT NULL
- intonation_score — INTEGER — NOT NULL
- pitch_diff_avg — FLOAT
- feedback_text — TEXT
- created_at — DATETIME — NOT NULL
practice_sessions
- SESSION_ID — INTEGER — Primary key — NOT NULL
- USER_ID — BIGINT — Foreign key → users.id — NOT NULL
- SCRIPT_ID — VARCHAR(255) — Foreign key → scripts.ID — NOT NULL
- dialect — VARCHAR(20) — NOT NULL
- started_at — DATETIME — NOT NULL
- ended_at — DATETIME
- total_items — INTEGER
- completed_items — INTEGER
- created_at — DATETIME — NOT NULL
recordings
- ID — VARCHAR(255) — Primary key — NOT NULL
- SCRIPT_ID — VARCHAR(255) — Primary key — NOT NULL
- USER_ID — BIGINT — Primary key — NOT NULL
- SESSION_ID — INTEGER — Primary key — NOT NULL
- line_id — INTEGER — NOT NULL
- file_url — VARCHAR(255) — NOT NULL
- mime_type — VARCHAR(50) — NOT NULL
- duration_ms — INTEGER
- created_at — DATETIME — NOT NULL
score_criteria
- ID — VARCHAR(255) — Primary key — NOT NULL
- criteria_code — VARCHAR(50) — NOT NULL
- criteria_name — VARCHAR(100) — NOT NULL
- weight — FLOAT
- created_at — DATETIME — NOT NULL
score_details
- ID — VARCHAR(255) — Primary key — NOT NULL
- SCORE_ID — VARCHAR(255) — Primary key — NOT NULL
- line_id — INTEGER
- criteria_id — VARCHAR(255) — Foreign key → score_criteria.ID — NOT NULL
- score_value — INTEGER — NOT NULL
- feedback_text — TEXT
- created_at — DATETIME — NOT NULL
script_lines
- ID — VARCHAR(255) — Primary key — NOT NULL
- script_id — VARCHAR(255) — Foreign key → scripts.ID — NOT NULL
- seq — INTEGER — NOT NULL
- text_standard — TEXT — NOT NULL
- text_dialect — TEXT
- audio_standard_url — VARCHAR(255)
- audio_dialect_url — VARCHAR(255)
- created_at — DATETIME — NOT NULL
scripts
- ID — VARCHAR(255) — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- dialect — VARCHAR(20) — NOT NULL
- category — VARCHAR(20) — NOT NULL
- order_no — INTEGER — NOT NULL
- created_at — DATETIME — NOT NULL
users
- id — BIGINT — Primary key — NOT NULL
- user_id — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255)
- name — VARCHAR(100)
- nickname — VARCHAR(100)
- profile_image_url — VARCHAR(255)
- is_active — TINYINT(1)
- created_at — DATETIME
- last_login_at — DATETIME