Files
MultiTenantSaaS/prisma/models/organization-user-join.prisma
2026-02-22 17:27:37 +05:45

19 lines
447 B
Plaintext

model OrganizationUserJoinTable {
userId String
orgId String
role ORG_ROLE @default(member)
joinedDate DateTime @default(now())
organization Organization @relation(fields: [orgId], references: [id], onDelete: Restrict)
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
@@unique([userId, orgId])
@@map("organization_user_join")
}
enum ORG_ROLE {
owner
admin
member
}