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