Skip to main content

Data dictionary

Use this list to find the table containing the data you need. For complete column types, defaults, and constraints, see modern.ts and better-auth.ts.

Users and authentication​

TableStores
usersUsers, quotas, billing relationships, and encrypted external API keys
sessionBetter Auth login sessions and expiration
accountPassword credentials and identity-provider connections such as Google
verificationVerification data for email confirmation, password resets, and related flows
apikeyMCP API keys and access scopes
jwksKeys used to sign OAuth tokens
account_deletion_requestsAccount deletion requests
device_codeBetter Auth device authorization (RFC 8628) requests

Videos, courses, and tags​

TableStores
videosVideo title, owner, file reference, spoken language (transcription_language; null means automatic detection), transcript, and processing state
video_coursesCourses, owners, and sharing settings
video_course_membersVideos included in a course and their display order
video_course_membershipsMembership information for people using a course
video_course_invitationsCourse invitations and their state
tags / video_tagsUser tags / their associations with videos
video_transcription_runs / video_transcription_chunksEach video's resumable transcription plan / saved segments, retries, and errors for each interval
video_visual_runs / video_visual_chunksEach video's visual-cache build plan and status / state of each chunk

Questions, answers, and evaluations​

TableStores
chat_logsQuestions, structured answers in response JSONB (segments and sources), retrieved contexts, and user feedback
chat_log_evaluationsHistorical evaluation results (retired; no new writes)
course_evaluation_snapshotsHistorical evaluation aggregates (retired)
ai_answer_attemptsAnonymous per-answer cost ledger, without a user ID, prompt, response, or provider credential

chat_logs.response is the canonical answer. The old separate answer and citations columns were removed. History returns this same structure; CSV exports derive plain text by concatenating segment texts. See the answer contract and historical data conversion.

TableStores and caveats
scene_embeddingsSubtitle segments and search embeddings; currently 1536 dimensions

Delivery, duplicate protection, and billing​

TableStores
external_tasksWork to dispatch externally and its delivery state
job_executionsExecution state of jobs received by the worker
mcp_idempotency_recordsRecords preventing duplicate effects from repeated MCP operations
stripe_eventsRecords preventing duplicate processing of received Stripe events
runtime_rate_limitsShared rate-limit windows for the on-prem Node.js runtime; Cloudflare Workers use the RATE_LIMITER Durable Object

OAuth​

TableStores
oauth_clientRegistered external clients
oauth_resource / oauth_client_resourceTarget APIs and permitted client associations
oauth_access_token / oauth_refresh_tokenIssued tokens and refresh information
oauth_consentScopes authorized by users for clients
oauth_client_assertionInformation preventing reuse of client authentication assertions

Common conventions​

User IDs are UUIDs stored as text; videos, courses, and similar entities use numeric IDs. Timestamps are mostly stored with time zones and exposed by the API as UTC ISO-8601 values. Check each table's foreign keys and unique constraints for related-row deletion and duplicate prevention.

Related: ER diagrams, Change the database.