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