ㅇㅇ

Tables (8)

Coaching_Reports

  • coaching_report_id — INT — Primary key — NOT NULL
  • practice_id — INT — Foreign key → Practices.practice_id — NOT NULL
  • coaching_practice_cnt — INT — NOT NULL
  • pause_count — INT
  • pronunciation_score — INT
  • record_url — VARCHAR(255)
  • speech_speed — ENUM('FAST', 'MIDDLE', 'SLOW')
  • speech_volume — ENUM('LOUD', 'MIDDLE', 'QUIET')

Final_Reports

  • final_report_id — INT — Primary key — NOT NULL
  • practice_id — INT — Foreign key → Practices.practice_id — NOT NULL
  • pause_score — INT
  • pronunciation_score — INT
  • speed_score — INT
  • speech_speed — ENUM('FAST', 'MIDDLE', 'SLOW')
  • volume_score — INT
  • speech_volume — ENUM('LOUD', 'MIDDLE', 'QUIET')
  • script_match_rate — INT
  • pause_count — INT
  • total_score — INT
  • video_url — VARCHAR(255)
  • script — TEXT
  • final_practice_cnt — INT — NOT NULL

Practices

  • practice_id — INT — Primary key — NOT NULL
  • project_id — INT — Foreign key → Projects.project_id — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • status — ENUM('COMPLETED', 'IN_PROGRESS') — NOT NULL
  • type — ENUM('COACHING', 'FINAL') — NOT NULL

Projects

  • project_id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → Users.id — NOT NULL
  • title — VARCHAR(20) — NOT NULL — 프로젝트 제목
  • date — DATE — NOT NULL — 발표 날짜
  • limit_time — INT — NOT NULL — 제한시간 (분 단위)
  • script — TEXT — 대본 (문단 구분자 포함)
  • created_at — DATETIME(6) — NOT NULL — 프로젝트 생성 시간
  • last_coaching_cnt — INT — NOT NULL — 코칭 연습 회차수
  • last_final_cnt — INT — NOT NULL — 파이널 연습 회차수

Question_Answer

  • question_answer_id — INT — Primary key — NOT NULL
  • final_report_id — INT — Foreign key → Final_Reports.final_report_id — NOT NULL
  • answer — TEXT
  • question — TEXT

Random_Speeches

  • random_speech_id — INT — Primary key — NOT NULL — 랜덤 스피치 pk
  • user_id (int) — INT — Foreign key → Users.id — NOT NULL
  • topic — ENUM('BUSINESS', 'ENTERTAINMENT', 'ENVIRONMENT', 'POLITICS', 'SCIENCE', 'SPORTS', 'TECHNOLOGY', 'WORLD') — NOT NULL — 선택한 주제
  • speech_time — INT — NOT NULL — 사용자가 설정한 답변 시간
  • preparation_time — INT — NOT NULL — 사용자가 설정한 준비 시간
  • created_at — DATETIME(6) — NOT NULL — 랜덤 스피치를 한 날짜
  • news_title — TEXT
  • news_url — TEXT
  • news_summary — TEXT — NOT NULL
  • question — VARCHAR(255)
  • script — TEXT
  • ai_feedback — TEXT
  • ai_title — VARCHAR(255)

Users

  • id — INT — Primary key — NOT NULL
  • answer_time_limit — INT
  • has_audience — BIT(1) — NOT NULL
  • has_qna — BIT(1) — NOT NULL
  • kakao_id — BIGINT(20)
  • nickname — VARCHAR(255)
  • question_count — INT

Video_Feedback_Points

  • video_feedback_point_id — INT — Primary key — NOT NULL
  • final_report_id — INT — Foreign key → Final_Reports.final_report_id — NOT NULL
  • end_time — DATETIME(6) — NOT NULL
  • feedback_detail — ENUM('FAST', 'LOUD', 'MIDDLE', 'QUIET', 'SLOW')
  • start_time — DATETIME(6) — NOT NULL
  • type — ENUM('PAUSE', 'SPEED', 'VOLUME') — NOT NULL