diff options
Diffstat (limited to 'src/lib')
| -rw-r--r-- | src/lib/server/db/schema.ts | 13 |
1 files changed, 12 insertions, 1 deletions
diff --git a/src/lib/server/db/schema.ts b/src/lib/server/db/schema.ts index 1d5fd9e..9cd6af8 100644 --- a/src/lib/server/db/schema.ts +++ b/src/lib/server/db/schema.ts @@ -1,4 +1,4 @@ -import { sqliteTable, text, integer } from 'drizzle-orm/sqlite-core'; +import { sqliteTable, text, integer, real } from 'drizzle-orm/sqlite-core'; export const categories = sqliteTable('categories', { id: integer('id').primaryKey({ autoIncrement: true }), @@ -12,3 +12,14 @@ export const groceries = sqliteTable('groceries', { createdAt: text('created_at').notNull(), categoryId: integer('category_id').references(() => categories.id), }); + +export const references = sqliteTable('references', { + id: integer('id').primaryKey({ autoIncrement: true }), + groceryId: integer('grocery_id') + .notNull() + .references(() => groceries.id, { onDelete: 'cascade' }), + brand: text('brand').notNull(), + price: real('price'), + unit: text('unit'), + qualityScore: integer('quality_score'), +}); |