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