import { sqliteTable, text, integer, real } from 'drizzle-orm/sqlite-core';

export const categories = sqliteTable('categories', {
	id: integer('id').primaryKey({ autoIncrement: true }),
	name: text('name').notNull().unique(),
});

export const groceries = sqliteTable('groceries', {
	id: integer('id').primaryKey({ autoIncrement: true }),
	name: text('name').notNull().unique(),
	checked: integer('checked', { mode: 'boolean' }).notNull().default(false),
	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' }),
	reference: text('reference').notNull(),
	price: real('price'),
	unit: text('unit'),
	qualityScore: integer('quality_score'),
});