ray-template/apps/server/prisma/schema.prisma
XiaoDaiGua-Ray 59c1090ea4
feat(fullstack): add optional backend and source distributions
Add the NestJS backend with PostgreSQL and Redis, local setup, and
independent frontend and fullstack source archives.

Enforce permissions across redirects, let users dismiss the 403 page,
and restore missing translation warnings in development.
2026-11-06 19:53:49 +08:00

102 lines
2.6 KiB
Plaintext

generator client {
provider = "prisma-client"
output = "../src/generated/prisma"
}
datasource db {
provider = "postgresql"
}
model Department {
id String @id
parentId String?
name String
labelKey String?
parent Department? @relation("DepartmentTree", fields: [parentId], references: [id], onDelete: Restrict)
children Department[] @relation("DepartmentTree")
users User[]
@@index([parentId])
}
model Role {
value String @id
label String
labelKey String?
permissions RolePermission[]
users User[]
}
model Permission {
code String @id
roles RolePermission[]
}
model RolePermission {
roleValue String
permissionCode String
role Role @relation(fields: [roleValue], references: [value], onDelete: Cascade)
permission Permission @relation(fields: [permissionCode], references: [code], onDelete: Cascade)
@@id([roleValue, permissionCode])
}
model User {
id String @id @default(uuid())
username String
usernameKey String @unique
name String
email String
emailKey String @unique
phone String @default("")
departmentId String
role String
status String @default("enabled")
remark String @default("")
createdAt DateTime @default(now()) @db.Timestamptz(3)
updatedAt DateTime @updatedAt @db.Timestamptz(3)
department Department @relation(fields: [departmentId], references: [id], onDelete: Restrict)
roleRecord Role @relation(fields: [role], references: [value], onDelete: Restrict)
credential Credential?
sessions Session[]
@@index([departmentId])
@@index([role, status])
}
model Credential {
userId String @id
passwordHash String
updatedAt DateTime @updatedAt @db.Timestamptz(3)
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
}
model Session {
tokenHash String @id
userId String
expiresAt DateTime @db.Timestamptz(3)
createdAt DateTime @default(now()) @db.Timestamptz(3)
user User @relation(fields: [userId], references: [id], onDelete: Cascade)
@@index([userId])
@@index([expiresAt])
}
model RouteConfig {
id String @id
config Json
updatedAt DateTime @updatedAt @db.Timestamptz(3)
}
model AuditLog {
id String @id @default(uuid())
actorId String?
action String
resourceId String?
requestId String?
createdAt DateTime @default(now()) @db.Timestamptz(3)
@@index([createdAt])
@@index([actorId, createdAt])
}