test

Tables (9)

api_cache

  • cache_key — TEXT
  • value — JSONB — NOT NULL
  • ttl_at — TIMESTAMPTZ — NOT NULL

audit_sources

  • id — UUID
  • video_ref — UUID — NOT NULL
  • is_embed_allowed — BOOLEAN
  • caption_rights — VARCHAR(32)
  • policy_checked_at — TIMESTAMPTZ
  • checker — TEXT
  • notes — TEXT

clip_notes

  • id — UUID
  • clip_ref — UUID — NOT NULL
  • lang — VARCHAR(8)
  • transcript_snippet — TEXT
  • translation — TEXT
  • explanation_md — TEXT
  • version — INTEGER
  • updated_by — TEXT
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ

clips

  • id — UUID
  • video_ref — UUID — NOT NULL
  • start_sec — NUMERIC(9,3) — NOT NULL
  • end_sec — NUMERIC(9,3) — NOT NULL
  • title — TEXT
  • tags — JSONB
  • difficulty — SMALLINT
  • visibility — VARCHAR(16)
  • created_at — TIMESTAMPTZ

exercises

  • id — UUID
  • clip_ref — UUID — NOT NULL
  • type — VARCHAR(32) — NOT NULL
  • payload — JSONB — NOT NULL
  • answers — JSONB
  • created_at — TIMESTAMPTZ

user_favorites

  • id — UUID
  • user_ref — UUID — NOT NULL
  • clip_ref — UUID — NOT NULL
  • created_at — TIMESTAMPTZ

user_progress

  • id — UUID
  • user_ref — UUID — NOT NULL
  • clip_ref — UUID — NOT NULL
  • last_position — NUMERIC(9,3)
  • total_watch_sec — INTEGER
  • completed — BOOLEAN
  • accuracy — NUMERIC(5,2)
  • last_played_at — TIMESTAMPTZ
  • reviewed_at — TIMESTAMPTZ

users

  • id — UUID
  • email — TEXT — NOT NULL
  • locale — VARCHAR(10)
  • level — VARCHAR(20)
  • created_at — TIMESTAMPTZ

youtube_videos

  • id — UUID
  • video_id — VARCHAR(32) — NOT NULL
  • title — TEXT — NOT NULL
  • channel_id — VARCHAR(64)
  • channel_title — TEXT
  • duration_sec — INTEGER
  • thumbnail_url — TEXT
  • source_url — TEXT
  • is_official — BOOLEAN
  • status — VARCHAR(20)
  • license_note — TEXT
  • last_checked_at — TIMESTAMPTZ