-
Notifications
You must be signed in to change notification settings - Fork 1.5k
/
schema.prisma
92 lines (78 loc) · 2.29 KB
/
schema.prisma
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
generator client {
provider = "prisma-client-js"
previewFeatures = ["uncheckedScalarInputs"]
}
datasource db {
provider = "sqlite"
url = "file:dev.db"
}
model User {
id Int @id @default(autoincrement())
uuid String @default(uuid())
email String @unique
firstName String
lastName String
password String
status Boolean @default(true)
locked Boolean @default(false)
public Boolean @default(true)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
trips Trip[]
activities UsersToActivities[]
}
model Trip {
id Int @id @default(autoincrement())
uuid String @default(uuid())
userId Int
name String
description String?
public Boolean
dateFrom DateTime
dateTo DateTime
adults Int
children Int? @default(0)
infants Int? @default(0)
backgroundUrl String?
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
user User @relation(fields: [userId], references: [id])
activities Activity[]
@@unique([userId, id])
}
model Activity {
id Int @id @default(autoincrement())
uuid String @default(uuid())
tripId Int
activityTypeId Int
name String
description String?
location String
date DateTime
timezone String
public Boolean
maxPeople Int? @default(0)
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
trip Trip @relation(fields: [tripId], references: [id])
activityType ActivityType @relation(fields: [activityTypeId], references: [id])
users UsersToActivities[]
@@unique([tripId, id])
}
model ActivityType {
id Int @id @default(autoincrement())
uuid String @default(uuid())
name String
type String @unique
createdAt DateTime @default(now())
updatedAt DateTime @updatedAt
activities Activity[]
}
model UsersToActivities {
userId Int
activityId Int
createdAt DateTime @default(now())
user User @relation(fields: [userId], references: [id])
activity Activity @relation(fields: [activityId], references: [id])
@@id([userId, activityId])
}