ㅇㅇ
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