temp
Tables (12)
integration
- integration_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- provider — VARCHAR(50) — NOT NULL
- access_token — TEXT
- refresh_token — TEXT
- token_expires_at — DATETIME
- is_active — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
issue
- issue_id — BIGINT — Primary key — NOT NULL
- project_id — BIGINT — Foreign key → project.project_id — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- provider — VARCHAR(50) — NOT NULL
- issue_type — VARCHAR(50)
- content — TEXT
- created_at — DATETIME — NOT NULL
notification
- notification_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- push_token — VARCHAR(512)
- on_off — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
project
- project_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- creation_type — VARCHAR(50) — NOT NULL
- project_name — VARCHAR(200) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
reference
- reference_id — BIGINT — Primary key — NOT NULL
- document — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
scenario
- scenario_id — BIGINT — Primary key — NOT NULL
- subject_id — BIGINT — Foreign key → subject.subject_id — NOT NULL
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- issue_id — BIGINT — Foreign key → issue.issue_id
- project_id — BIGINT — Foreign key → project.project_id
- title — VARCHAR(200) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
scenario_feedback
- feedback_id — BIGINT — Primary key — NOT NULL
- scenario_id — BIGINT — Foreign key → scenario.scenario_id — NOT NULL
- total_pronunciation — DECIMAL(5,2)
- total_grammar — DECIMAL(5,2)
- total_diversity — DECIMAL(5,2)
- total_score — DECIMAL(5,2)
- comment — TEXT
- created_at — DATETIME — NOT NULL
scenario_message
- message_id — BIGINT — Primary key — NOT NULL
- scenario_id — BIGINT — Foreign key → scenario.scenario_id — NOT NULL
- speaker — VARCHAR(30) — NOT NULL
- message_text — TEXT — NOT NULL
- audio_url — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
scenario_message_feedback
- feedback_id — BIGINT — Primary key — NOT NULL
- message_id — BIGINT — Foreign key → scenario_message.message_id — NOT NULL
- scenario_id — BIGINT — Foreign key → scenario.scenario_id — NOT NULL
- original_expression — TEXT
- suggested_expression — TEXT
- pronunciation — DECIMAL(5,2)
- grammar — DECIMAL(5,2)
- diversity — DECIMAL(5,2)
- score — DECIMAL(5,2)
- criterion — VARCHAR(50)
- created_at — DATETIME — NOT NULL
scenario_reference
- scenario_id — BIGINT — Foreign key → scenario.scenario_id — NOT NULL
- reference_id — BIGINT — Foreign key → reference.reference_id — NOT NULL
- created_at — DATETIME — NOT NULL
subject
- subject_id — BIGINT — Primary key — NOT NULL
- issue_id — BIGINT — Foreign key → issue.issue_id
- user_id — BIGINT — Foreign key → user.user_id — NOT NULL
- project_id — BIGINT — Foreign key → project.project_id
- creation_type — VARCHAR(50) — NOT NULL
- creation_type_detail — VARCHAR(100)
- my_role — TEXT
- ai_role — TEXT
- situation — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
user
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- profile_image_url — VARCHAR(512)
- auth_provider — VARCHAR(50) — NOT NULL
- provider_user_id — VARCHAR(255)
- english_level — VARCHAR(50)
- job_role — VARCHAR(100)
- team_name — VARCHAR(100)
- meeting_period — VARCHAR(50)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL