model Recipe {
id String @id @default(cuid())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
name String
description String @db.VarChar(255)
instructions String @db.VarChar(255)
authorId String
ingredients IngredientInRecipe[]
@@index([authorId])
}
model Ingredient {
id String @id @default(cuid())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
name String @unique
recipes IngredientInRecipe[]
}
model IngredientInRecipe {
ingredientId String @default(cuid())
recipeId String @default(cuid())
name String
quantity Int
unit String
ingredient Ingredient @relation(fields: [ingredientId], references: [id])
recipe Recipe @relation(fields: [recipeId], references: [id])
@@id([ingredientId, recipeId])
}
model Recipe {
id String @id @default(cuid())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
name String
description String @db.VarChar(255)
instructions String @db.VarChar(255)
authorId String
ingredients IngredientInRecipe[]
@@index([authorId])
}
model Ingredient {
id String @id @default(cuid())
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
name String @unique
recipes IngredientInRecipe[]
}
model IngredientInRecipe {
ingredientId String @default(cuid())
recipeId String @default(cuid())
name String
quantity Int
unit String
ingredient Ingredient @relation(fields: [ingredientId], references: [id])
recipe Recipe @relation(fields: [recipeId], references: [id])
@@id([ingredientId, recipeId])
}