/
CheateRYT
/
Order_database
Обзор
Документация
Войти
/
CheateRYT
/
Order_database
Код
Запросы
0
Пакеты
0
Релизы
0
Аналитика
Безопасность
master
server/prisma/schema.prisma
50 строк
1 KB
Lev Rednikov
Add: Get info about all orders and func getMyOrder by id
08 июн 2024, 12:40
08 июн 2024, 12:40
3c07a47
Код
Авторство
О чём код?
generator client { provider = "prisma-client-js" } datasource db { provider = "sqlite" url = env("DATABASE_URL") } model User { id Int @id @default(autoincrement()) login String password String name String role String // User, executor createdOrders Order[] @relation("ClientOrders") assignedOrders Order[] @relation("ExecutorOrders") } model Order { id Int @id @default(autoincrement()) client User @relation("ClientOrders", fields: [clientId], references: [id]) clientId Int executor User? @relation("ExecutorOrders", fields: [executorId], references: [id]) executorId Int? dateAdded DateTime dateAccepted DateTime? dateCompleted DateTime? equipment String faultType String problemDescription String executorComment String? status String notification Notification[] @@index([clientId], name: "client_index") @@index([executorId], name: "executor_index") } model Notification { id Int @id @default(autoincrement()) orderId Int type String message String createdAt DateTime order Order @relation(fields: [orderId], references: [id]) @@index([orderId], name: "order_index") }