Data structure
Generated from src/server/db/schema.ts and the app/admin auth schemas. The diagram shows 26 tables, 256 columns and 23 foreign keys. Each table lists every column with its SQL type, nullability and keys. NN means NOT NULL.
Drag a node heading, or focus it and use arrow keys. Select a table to inspect its foreign keys.
Select a table to inspect its columns and relationships.
All tables (26)
- · 6
- · 10
- · 12
- · 7
- · 11
- · 10
- · 9
- · 13
- · 17
- · 16
- · 17
- · 7
- · 13
- · 8
- · 15
- · 5
- · 8
- · 9
- · 11
- · 13
- · 9
- · 8
- · 6
- · 6
- · 8
- · 2
Schema changes
Edit the Drizzle source, generate the migration and review its SQL. Apply it only after explicit approval; it targets the connected database. Prices, SKU stock/reservations, order items, payments and shipment records already have dedicated tables. Auth tables separate customer and admin accounts.
The diagram includes declared foreign keys only; a similar column name does not imply a relationship. Data goes through repositories and the shared layers.