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