Schema Explorer
Loading schema...
SQL Console
Preset Queries
Run a query to see results
Click a preset or write your own SQL above
What This Proves
Normalized Schema (3NF)
Tables are decomposed to eliminate redundancy: users, projects, and tasks each store atomic data with clear ownership relationships.
Foreign Key Constraints
projects.owner_id and tasks.project_id/assignee_id reference parent tables, ensuring referential integrity at the database level.
CHECK Constraints
Business rules enforced in-schema: status IN ('active','archived','draft') and priority BETWEEN 1 AND 5 prevent invalid data.
Strategic Indexing
Queries can be accelerated with indexes on frequently filtered columns like priority and status—created on-demand via SQL.
JOIN Operations
Relational power: combine data across tables with INNER JOIN, LEFT JOIN, and aggregate with GROUP BY for analytics.
Real SQLite + WASM
This isn't a mockup—sql.js compiles SQLite to WebAssembly, running the full engine client-side with zero server dependency.