/
datamodel.prisma
100 lines (93 loc) · 2.25 KB
/
datamodel.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
93
94
95
96
97
98
99
100
enum Roles {
ADMIN
MODERATOR
USER
POSTCREATE
POSTUPDATE
POSTDELETE
SUBCREATE
SUBUPDATE
SUBDELETE
ROLEUPDATE
}
enum SubredditTypes {
PUBLIC
PRIVATE
RESTRICTED
}
type User {
id: ID! @unique @id
username: String! @unique
email: String! @unique
password: String!
image: String
followers: [User]!
resetToken: String
resetTokenExpiry: Float
roles: [Roles] @scalarList(strategy: RELATION)
posts: [Post!]! @relation(name: "PostsByUser" onDelete: CASCADE)
createdAt: DateTime! @createdAt
updatedAt: DateTime! @updatedAt
}
type Subreddit {
id: ID! @unique @id
name: String!
description: String
topics: [String]! @scalarList(strategy: RELATION)
isNSFW: Boolean! @default(value: false)
type: [SubredditTypes] @scalarList(strategy: RELATION)
path: String! @unique
image: String
headerBgImage: String
createdBy: User! @relation(name: "SubredditsByUser")
moderators: [User!]! @relation(name: "ModsOfSubreddit" onDelete: CASCADE)
followers: [User]! @relation(name: "FollowersOfSubreddit" onDelete: CASCADE)
posts: [Post!]! @relation(name: "PostsInSubreddit" onDelete: CASCADE)
createdAt: DateTime! @createdAt
updatedAt: DateTime! @updatedAt
}
type Post {
id: ID! @unique @id
title: String!
description: String
image: String
link: String
postedBy: User! @relation(name: "PostsByUser")
subreddit: Subreddit! @relation(name: "PostsInSubreddit")
isOC: Boolean! @default(value: false)
isNSFW: Boolean! @default(value: false)
isNSFL: Boolean! @default(value: false)
isSerious: Boolean! @default(value: false)
hasSpoiler: Boolean! @default(value: false)
upvotes: [Upvote!]!
downvotes: [Downvote!]!
comments: [Comment!]!
createdAt: DateTime! @createdAt
updatedAt: DateTime! @updatedAt
}
type Comment {
id: ID! @unique @id
body: String!
commentedBy: User!
upvotes: [Upvote!]!
downvotes: [Downvote!]!
post: Post!
createdAt: DateTime! @createdAt
updatedAt: DateTime! @updatedAt
}
type Upvote {
id: ID! @unique @id
upvotedBy: User!
post: Post
comment: Comment
createdAt: DateTime! @createdAt
updatedAt: DateTime! @updatedAt
}
type Downvote {
id: ID! @unique @id
downvotedBy: User!
post: Post
comment: Comment
createdAt: DateTime! @createdAt
updatedAt: DateTime! @updatedAt
}