From 45ee9cdba4e6e7c9ac918859b89d2b2ed38d4571 Mon Sep 17 00:00:00 2001 From: Chris Johnston Date: Thu, 11 Jan 2024 21:38:30 +0000 Subject: Assign categories to expenses (#28) * add expense categories * set category to Payment for reimbursements * Insert categories as part of the migration * Display category groups --------- Co-authored-by: Sebastien Castiel --- prisma/schema.prisma | 11 ++++++++++- 1 file changed, 10 insertions(+), 1 deletion(-) (limited to 'prisma/schema.prisma') diff --git a/prisma/schema.prisma b/prisma/schema.prisma index 42d4cfc..1fbfc65 100644 --- a/prisma/schema.prisma +++ b/prisma/schema.prisma @@ -29,11 +29,20 @@ model Participant { expensesPaidFor ExpensePaidFor[] } +model Category { + id Int @id @default(autoincrement()) + grouping String + name String + Expense Expense[] +} + model Expense { id String @id group Group @relation(fields: [groupId], references: [id], onDelete: Cascade) - expenseDate DateTime @db.Date @default(dbgenerated("CURRENT_DATE")) + expenseDate DateTime @default(dbgenerated("CURRENT_DATE")) @db.Date title String + category Category? @relation(fields: [categoryId], references: [id]) + categoryId Int @default(0) amount Int paidBy Participant @relation(fields: [paidById], references: [id], onDelete: Cascade) paidById String -- cgit v1.3