pitchcoach
Tables (17)
CriteriaScore
- id — VARCHAR(36)
- deck_score_id — VARCHAR(36) — Foreign key → DeckScore.id — NOT NULL
- criteria_id — VARCHAR(36) — Foreign key → NoticeEvaluationCriteria.id
- criteria_name — VARCHAR(255) — NOT NULL
- score — INTEGER — NOT NULL
- max_score — INTEGER — NOT NULL
- is_covered — BOOLEAN — NOT NULL
- feedback — TEXT
- related_slides — TEXT — 관련
DeckScore
- id — VARCHAR(36)
- ir_deck_id — VARCHAR(36) — Foreign key → IRDeck.id — NOT NULL
- total_score — INTEGER — NOT NULL
- strengths — TEXT
- improvements — TEXT — 개선점
- top_actions — TEXT — 우선
- created_at — TIMESTAMP — NOT NULL
IRDeck
- id — VARCHAR(36)
- pitch_id — VARCHAR(36) — Foreign key → Pitch.id — NOT NULL
- pdf_url — TEXT — NOT NULL
- structure_summary — TEXT
- total_score — INTEGER
- presentation_guide — TEXT — 발표
- time_allocation — TEXT — 시간
- emphasized_slides — TEXT — 강조
- analyzed_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
IRRequirement
- id — VARCHAR(36)
- criteria_id — VARCHAR(36) — Foreign key → NoticeEvaluationCriteria.id — NOT NULL
- requirement_name — VARCHAR(255) — NOT NULL
- is_mandatory — BOOLEAN — NOT NULL
- description — TEXT
Notice
- id — VARCHAR(36)
- pitch_id — VARCHAR(36) — Foreign key → Pitch.id — NOT NULL
- pdf_url — TEXT
- notice_name — VARCHAR(255) — NOT NULL
- host_organization — VARCHAR(255)
- target_audience — VARCHAR(255)
- application_period — VARCHAR(255)
- summary — TEXT — 공고
- core_requirements — TEXT — 핵심
- source_reference — TEXT — XAI
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
NoticeEvaluationCriteria
- id — VARCHAR(36)
- notice_id — VARCHAR(36) — Foreign key → Notice.id — NOT NULL
- criteria_name — VARCHAR(255) — NOT NULL
- points — INTEGER
- importance — VARCHAR(50) — 중요도
- display_order — INTEGER — NOT NULL
- parent_id — VARCHAR(36) — Foreign key → NoticeEvaluationCriteria.id — 상위
Pitch
- id — VARCHAR(36)
- user_id — VARCHAR(36) — Foreign key → User.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- pitch_type — VARCHAR(50) — NOT NULL
- duration_minutes — INTEGER — NOT NULL
- has_notice — BOOLEAN — NOT NULL
- notice_type — VARCHAR(20) — 공고
- status — VARCHAR(50) — NOT NULL — 진행
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
QAAnswer
- id — VARCHAR(36)
- question_id — VARCHAR(36) — Foreign key → QAQuestion.id — NOT NULL
- audio_file_url — TEXT
- transcription — TEXT — 답변
- briefness_score — INTEGER — 간결성
- evidence_score — INTEGER — 근거
- structure_score — INTEGER — 구조
- strengths — TEXT
- weaknesses — TEXT
- answered_at — TIMESTAMP
QAQuestion
- id — VARCHAR(36)
- qa_training_id — VARCHAR(36) — Foreign key → QATraining.id — NOT NULL
- category — VARCHAR(50) — NOT NULL
- question — TEXT — NOT NULL
- answer_guide — TEXT — NOT NULL — 답변
- display_order — INTEGER — NOT NULL — 질문
QATraining
- id — VARCHAR(36)
- pitch_id — VARCHAR(36) — Foreign key → Pitch.id — NOT NULL
- mode — VARCHAR(20) — NOT NULL
- total_questions — INTEGER — NOT NULL — 생성된
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
Report
- id — VARCHAR(36)
- pitch_id — VARCHAR(36) — Foreign key → Pitch.id — NOT NULL
- notice_summary — TEXT
- notice_score — INTEGER — 공고
- ir_deck_summary — TEXT — IR
- ir_deck_score — INTEGER — IR
- voice_summary — TEXT — 음성
- voice_score — INTEGER — 음성
- qa_summary — TEXT — Q&A
- qa_score — INTEGER — Q&A
- final_score — INTEGER — NOT NULL — 최종
- chart_data — JSONB — 점수
- generated_at — TIMESTAMP — NOT NULL
Slide
- id — VARCHAR(36)
- ir_deck_id — VARCHAR(36) — Foreign key → IRDeck.id — NOT NULL
- slide_number — INTEGER — NOT NULL
- category — VARCHAR(50)
- thumbnail_url — TEXT
- content — TEXT
- category_verified — BOOLEAN — NOT NULL — 사용자가
- display_order — INTEGER — NOT NULL
SlideFeedback
- id — VARCHAR(36)
- slide_id — VARCHAR(36) — Foreign key → Slide.id — NOT NULL
- feedback — TEXT
- improvement — TEXT — 공고
- created_at — TIMESTAMP — NOT NULL
User
- id — VARCHAR(36)
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- password — VARCHAR(255)
- auth_type — VARCHAR(20) — NOT NULL
- gender — VARCHAR(10)
- age_group — VARCHAR(50) — 나이대:
- startup_field — VARCHAR(100)
- startup_stage — VARCHAR(50) — 창업
- startup_duration — VARCHAR(50)
- has_career — BOOLEAN — 경력
- has_presentation_exp — BOOLEAN — 발표
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
VoiceAnalysis
- id — VARCHAR(36)
- pitch_id — VARCHAR(36) — Foreign key → Pitch.id — NOT NULL
- audio_file_url — TEXT — NOT NULL
- transcription — TEXT
- total_score — INTEGER — NOT NULL — 총점
- overall_strengths — TEXT — 전체
- overall_improvements — TEXT — 전체
- top_actions — TEXT — Top
- analyzed_at — TIMESTAMP
- created_at — TIMESTAMP — NOT NULL
VoiceDetailScore
- id — VARCHAR(36)
- voice_analysis_id — VARCHAR(36) — Foreign key → VoiceAnalysis.id — NOT NULL
- category_name — VARCHAR(50) — NOT NULL
- category_display_name — VARCHAR(100) — NOT NULL — 카테고리
- score — INTEGER — NOT NULL
- max_score — INTEGER — NOT NULL
- feedback — TEXT
VoiceSubScore
- id — VARCHAR(36)
- voice_detail_score_id — VARCHAR(36) — Foreign key → VoiceDetailScore.id — NOT NULL
- sub_criteria_name — VARCHAR(100) — NOT NULL
- score — INTEGER — NOT NULL
- max_score — INTEGER — NOT NULL
- feedback — TEXT