mini-project

Tables (11)

analyses

  • id — UUID — Primary key — NOT NULL
  • recording_id — UUID — Foreign key → recordings.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • failure_code — VARCHAR(100)
  • retryable — BOOLEAN — NOT NULL
  • automatic_retry_count — SMALLINT — NOT NULL
  • user_retry_count — INTEGER — NOT NULL
  • speech_seconds — NUMERIC(8,3)
  • silence_seconds — NUMERIC(8,3)
  • filler_count — INTEGER
  • long_silence_count — INTEGER
  • repetition_count — INTEGER
  • speech_rate_wpm — NUMERIC(8,2)
  • started_at — TIMESTAMPTZ — NOT NULL
  • completed_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ — NOT NULL

analysis_segments

  • id — UUID — Primary key — NOT NULL
  • analysis_id — UUID — Foreign key → analyses.id — NOT NULL
  • section — VARCHAR(20) — NOT NULL
  • start_seconds — NUMERIC(8,3) — NOT NULL
  • end_seconds — NUMERIC(8,3) — NOT NULL
  • filler_count — INTEGER — NOT NULL

coaching_actions

  • id — UUID — Primary key — NOT NULL
  • coaching_result_id — UUID — Foreign key → coaching_results.id — NOT NULL
  • sequence_no — INTEGER — NOT NULL
  • action_text — TEXT — NOT NULL

coaching_results

  • id — UUID — Primary key — NOT NULL
  • analysis_id — UUID — Foreign key → analyses.id — NOT NULL
  • summary — TEXT — NOT NULL
  • practice_direction — TEXT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

filler_occurrences

  • id — UUID — Primary key — NOT NULL
  • analysis_id — UUID — Foreign key → analyses.id — NOT NULL
  • sequence_no — INTEGER — NOT NULL
  • expression — VARCHAR(100) — NOT NULL
  • start_seconds — NUMERIC(8,3) — NOT NULL
  • end_seconds — NUMERIC(8,3) — NOT NULL

recordings

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • idempotency_key — UUID — NOT NULL
  • duration_seconds — NUMERIC(8,3) — NOT NULL
  • locale — VARCHAR(20) — NOT NULL
  • mime_type — VARCHAR(100) — NOT NULL
  • file_size_bytes — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

refresh_tokens

  • id — UUID — Primary key — NOT NULL
  • user_id — UUID — Foreign key → users.id — NOT NULL
  • family_id — UUID — NOT NULL
  • token_hash — VARCHAR(255) — NOT NULL
  • replaced_by_token_id — UUID — Foreign key → refresh_tokens.id
  • expires_at — TIMESTAMPTZ — NOT NULL
  • revoked_at — TIMESTAMPTZ
  • reuse_detected_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • last_used_at — TIMESTAMPTZ

repetition_patterns

  • id — UUID — Primary key — NOT NULL
  • analysis_id — UUID — Foreign key → analyses.id — NOT NULL
  • expression — VARCHAR(255) — NOT NULL
  • occurrence_count — INTEGER — NOT NULL

silence_intervals

  • id — UUID — Primary key — NOT NULL
  • analysis_id — UUID — Foreign key → analyses.id — NOT NULL
  • sequence_no — INTEGER — NOT NULL
  • start_seconds — NUMERIC(8,3) — NOT NULL
  • end_seconds — NUMERIC(8,3) — NOT NULL
  • is_long — BOOLEAN — NOT NULL

users

  • id — UUID — Primary key — NOT NULL
  • email — VARCHAR(254) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • profile_image_url — VARCHAR(2048)
  • plan — VARCHAR(10) — NOT NULL
  • time_zone — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

waveform_points

  • id — UUID — Primary key — NOT NULL
  • analysis_id — UUID — Foreign key → analyses.id — NOT NULL
  • sequence_no — INTEGER — NOT NULL
  • offset_ms — INTEGER — NOT NULL
  • amplitude — NUMERIC(7,6) — NOT NULL