diff options
| author | Sebastien Castiel <sebastien@castiel.me> | 2023-12-08 14:56:51 -0500 |
|---|---|---|
| committer | Sebastien Castiel <sebastien@castiel.me> | 2023-12-08 14:56:51 -0500 |
| commit | 92a21ff4c5df6e9f771cfbd140835dce3b6d7b0d (patch) | |
| tree | 33f09b0069550f58e287a4e12a70f20ff1f50cea /prisma/schema.prisma | |
| parent | 9cc819b0c900d82efb55b6bc8c9faa38d21c0197 (diff) | |
Migration script, improvements in expenses list
Diffstat (limited to 'prisma/schema.prisma')
| -rw-r--r-- | prisma/schema.prisma | 8 |
1 files changed, 5 insertions, 3 deletions
diff --git a/prisma/schema.prisma b/prisma/schema.prisma index cc88c4e..edf68f2 100644 --- a/prisma/schema.prisma +++ b/prisma/schema.prisma @@ -17,6 +17,7 @@ model Group { currency String @default("$") participants Participant[] expenses Expense[] + createdAt DateTime @default(now()) } model Participant { @@ -30,19 +31,20 @@ model Participant { model Expense { id String @id - group Group @relation(fields: [groupId], references: [id]) + group Group @relation(fields: [groupId], references: [id], onDelete: Cascade) title String amount Int - paidBy Participant @relation(fields: [paidById], references: [id]) + paidBy Participant @relation(fields: [paidById], references: [id], onDelete: Cascade) paidById String paidFor ExpensePaidFor[] groupId String isReimbursement Boolean @default(false) + createdAt DateTime @default(now()) } model ExpensePaidFor { expense Expense @relation(fields: [expenseId], references: [id], onDelete: Cascade) - participant Participant @relation(fields: [participantId], references: [id]) + participant Participant @relation(fields: [participantId], references: [id], onDelete: Cascade) expenseId String participantId String |