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