🗄️ Database Schema
SQLite tables that power the CDN.
{`id TEXT PRIMARY KEY project_id TEXT NOT NULL user_id TEXT NOT NULL version_number INTEGER NOT NULL version_name TEXT description TEXT files_json TEXT (full file tree as JSON) project_name TEXT created_at TEXT updated_at TEXT is_active INTEGER (0/1) is_public INTEGER (0/1)`} posts post_files 🔗 Relationships Posts link to versions via project_id . When you post a project, it stores the same projectId that was used when saving versions. This allows the post detail page to look up public versions for that project.