model Todo {
id String @id @default(cuid())
customer String
title String
address String?
location Json?
description String?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
camera String[]
nakkilista Boolean @default(false)
status Status @default(OPEN)
creatorId String
organizationId String
contactNumber String?
setDate DateTime?
creator User @relation("CreatedTodos", fields: [creatorId], references: [uid])
organization Organization @relation("OrganizationTodos", fields: [organizationId], references: [id]) // EDITED this
assignedUsers User[] @relation("TodoAssignments")
}
model Organization {
id String @id @default(cuid())
name String
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
ownerId String
Invite Invite[]
owner User @relation("OwnerOrganizations", fields: [ownerId], references: [uid])
todos Todo[] @relation("OrganizationTodos") // EDITED this
users User[] @relation("UserMemberships")
}
model Todo {
id String @id @default(cuid())
customer String
title String
address String?
location Json?
description String?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
camera String[]
nakkilista Boolean @default(false)
status Status @default(OPEN)
creatorId String
organizationId String
contactNumber String?
setDate DateTime?
creator User @relation("CreatedTodos", fields: [creatorId], references: [uid])
organization Organization @relation("OrganizationTodos", fields: [organizationId], references: [id]) // EDITED this
assignedUsers User[] @relation("TodoAssignments")
}
model Organization {
id String @id @default(cuid())
name String
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
ownerId String
Invite Invite[]
owner User @relation("OwnerOrganizations", fields: [ownerId], references: [uid])
todos Todo[] @relation("OrganizationTodos") // EDITED this
users User[] @relation("UserMemberships")
}