schema.prisma

// schema.prisma

generator client {
  provider = "prisma-client-js"
}

datasource db {
  provider = "sqlite" // Now using SQLite as the database provider
  url      = "file:./pantry.db" // The database file will be created in the current directory
}

model Ingredient {
  id            Int       @id @default(autoincrement())
  name          String    @unique
  quantity      Float     // Quantity in a specific unit
  unit          String    // e.g., 'grams', 'liters', 'pieces'
  pantryId      Int
  pantry        Pantry    @relation(fields: [pantryId], references: [id])
  recipes       Recipe[]  @relation("RecipeIngredients")
  expirationDate DateTime? // Optional field for perishable ingredients
  createdAt     DateTime  @default(now())
  updatedAt     DateTime  @updatedAt

  ShoppingListItem ShoppingListItem[]
}

model Pantry {
  id            Int         @id @default(autoincrement())
  name          String
  ingredients   Ingredient[]
  shoppingLists ShoppingList[]
  createdAt     DateTime    @default(now())
  updatedAt     DateTime    @updatedAt

  Recipe Recipe[]
}

model ShoppingList {
  id            Int          @id @default(autoincrement())
  name          String
  pantryId      Int
  pantry        Pantry       @relation(fields: [pantryId], references: [id])
  items         ShoppingListItem[]
  createdAt     DateTime     @default(now())
  updatedAt     DateTime     @updatedAt
}

model ShoppingListItem {
  id             Int        @id @default(autoincrement())
  shoppingListId Int
  ingredientId   Int
  quantity       Float
  shoppingList   ShoppingList @relation(fields: [shoppingListId], references: [id])
  ingredient     Ingredient    @relation(fields: [ingredientId], references: [id])
}

model Recipe {
  id            Int        @id @default(autoincrement())
  name          String
  instructions  String
  ingredients   Ingredient[] @relation("RecipeIngredients")
  pantryId      Int
  pantry        Pantry      @relation(fields: [pantryId], references: [id])
  createdAt     DateTime    @default(now())
  updatedAt     DateTime    @updatedAt
}