capstone

Tables (12)

emotion_analysis

  • emotion_analysis_id — UUID — Primary key — NOT NULL
  • presentation_id — UUID — Foreign key → presentation.presentation_id — NOT NULL
  • emotion — VARCHAR(50)
  • confidence_score — FLOAT

eye_tracking

  • eye_tracking_id — UUID — Primary key — NOT NULL
  • presentation_id — UUID — Foreign key → presentation.presentation_id — NOT NULL
  • eye_contact_score — FLOAT

hexagon_evaluation

  • hexagon_evaluation_id — UUID — Primary key — NOT NULL
  • presentation_id — UUID — Foreign key → presentation.presentation_id — NOT NULL
  • pronunciation_score — FLOAT
  • speed_score — FLOAT
  • volume_score — FLOAT
  • eye_contact_score — FLOAT
  • word_usage_score — FLOAT
  • pitch_variation_score — FLOAT

llm_feedback

  • llm_feedback_id — UUID — Primary key — NOT NULL
  • presentation_id — UUID — Foreign key → presentation.presentation_id — NOT NULL
  • frequently_used_words — TEXT
  • gesture_feedback — TEXT
  • overall_summary — TEXT

presentation

  • presentation_id — UUID — Primary key — NOT NULL
  • topic_id — UUID — Foreign key → tpic.topic_id — NOT NULL
  • title — VARCHAR(255)
  • script — TEXT
  • video_url — TEXT
  • created_at — DATETIME
  • goal_time — VARCHAR(255)

presentation_comparison

  • comparison_id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → user.user_id — NOT NULL
  • presentation_id_1 — UUID — Foreign key → presentation.presentation_id — NOT NULL
  • presentation_id_2 — UUID — Foreign key → presentation.presentation_id — NOT NULL
  • comparison_summary — TEXT

stt_result

  • stt_result_id — UUID — Primary key — NOT NULL
  • presentation_id — UUID — Foreign key → presentation.presentation_id — NOT NULL
  • text — TEXT
  • accuracy — FLOAT

team

  • team_id — UUID — Primary key — NOT NULL
  • name — VARCHAR(100)
  • created_at — DATETIME

team_member

  • team_member_id — UUID — Primary key — NOT NULL
  • team_id — UUID — Foreign key → team.team_id — NOT NULL
  • user_id — UUID — Foreign key → user.user_id — NOT NULL
  • role — VARCHAR(50)
  • joined_at — DATETIME

tpic (topic)

  • topic_id — UUID — Primary key — NOT NULL
  • team_id (team_id2) — UUID — Foreign key → team.team_id — NOT NULL
  • user_id — UUID — Foreign key → user.user_id — NOT NULL
  • tiltle (title) — VARCHAR(255)
  • presentation_id — UUID
  • presentation_id2 — UUID

user

  • user_id — UUID — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL

voice_analysis

  • voice_analysis_id — UUID — Primary key — NOT NULL
  • presentation_id — UUID — Foreign key → presentation.presentation_id — NOT NULL
  • pitch — FLOAT
  • speed — FLOAT
  • volume — FLOAT