model User {
id String @id @default(cuid())
name String?
email String? @unique
emailVerified DateTime?
image String?
accounts Account[]
sessions Session[]
deposits Deposit[]
labels Label[]
expenses Expense[]
revenues Revenue[]
transfers Transfer[]
}
model Deposit {
id String @id @default(cuid())
uerId String
deposit_type depositTypes
name String
description String?
balance Float
created_at DateTime @default(now())
updated_at DateTime @default(now()) @updatedAt
user User @relation(fields: [uerId], references: [id], onDelete: Cascade)
expenses Expense[]
revenues Revenue[]
Transfer Transfer[] // from ???
Transfer Transfer[] // to ???
}
model Transfer {
id String @id @default(cuid())
uerId String
from_Deposit_id String
to_Deposit_id String
label_ids Label[]
name String
description String?
amount Float
fee Float
date DateTime
created_at DateTime @default(now())
updated_at DateTime @default(now()) @updatedAt
user User @relation(fields: [uerId], references: [id], onDelete: Cascade)
from_Deposit Deposit @relation(fields: [from_Deposit_id], references: [id])
to_Deposit Deposit @relation(fields: [to_Deposit_id], references: [id])
}
model User {
id String @id @default(cuid())
name String?
email String? @unique
emailVerified DateTime?
image String?
accounts Account[]
sessions Session[]
deposits Deposit[]
labels Label[]
expenses Expense[]
revenues Revenue[]
transfers Transfer[]
}
model Deposit {
id String @id @default(cuid())
uerId String
deposit_type depositTypes
name String
description String?
balance Float
created_at DateTime @default(now())
updated_at DateTime @default(now()) @updatedAt
user User @relation(fields: [uerId], references: [id], onDelete: Cascade)
expenses Expense[]
revenues Revenue[]
Transfer Transfer[] // from ???
Transfer Transfer[] // to ???
}
model Transfer {
id String @id @default(cuid())
uerId String
from_Deposit_id String
to_Deposit_id String
label_ids Label[]
name String
description String?
amount Float
fee Float
date DateTime
created_at DateTime @default(now())
updated_at DateTime @default(now()) @updatedAt
user User @relation(fields: [uerId], references: [id], onDelete: Cascade)
from_Deposit Deposit @relation(fields: [from_Deposit_id], references: [id])
to_Deposit Deposit @relation(fields: [to_Deposit_id], references: [id])
}