📦 ronitrajfr / TravelShare

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
101
102
103
104
105generator client {
    provider = "prisma-client-js"
}

datasource db {
    provider = "postgresql"
    url      = env("DATABASE_URL")
}

model Post {
    id          Int       @id @default(autoincrement())
    imageUrls   String[]
    state       String
    city        String
    country     String
    address     String
    name        String
    createdAt   DateTime  @default(now())
    updatedAt   DateTime  @updatedAt
    createdBy   User      @relation("UserPosts", fields: [createdById], references: [username])
    createdById String
    votes       Vote[]    
    reports     Report[]

    @@index([name])
}

model Vote {
    id        Int      @id @default(autoincrement())
    type      String   // "upvote" or "downvote"
    post      Post     @relation(fields: [postId], references: [id], onDelete: Cascade)
    postId    Int
    user      User     @relation("UserVotes", fields: [userId], references: [username])
    userId    String
    createdAt DateTime @default(now())

    @@unique([postId, userId])
}

model Report {
    id        Int      @id @default(autoincrement())
    reason    String
    post      Post     @relation(fields: [postId], references: [id], onDelete: Cascade)
    postId    Int
    user      User     @relation("UserReports", fields: [userId], references: [username])
    userId    String
    createdAt DateTime @default(now())

    @@unique([postId, userId])
}

model Account {
    id                       String  @id @default(cuid())
    userId                   String
    type                     String
    provider                 String
    providerAccountId        String
    refresh_token            String? // @db.Text
    access_token            String? // @db.Text
    expires_at              Int?
    token_type              String?
    scope                   String?
    id_token               String? // @db.Text
    session_state          String?
    user                    User    @relation(fields: [userId], references: [id], onDelete: Cascade)
    refresh_token_expires_in Int?

    @@unique([provider, providerAccountId])
}

model Session {
    id           String   @id @default(cuid())
    sessionToken String   @unique
    userId       String
    expires      DateTime
    user         User     @relation(fields: [userId], references: [id], onDelete: Cascade)
}

model User {
    id            String    @id @default(cuid())
    name          String?
    username      String?   @unique @default(cuid())
    email         String?   @unique
    emailVerified DateTime?
    image         String?
    spotify       String?
    instagram     String?
    twitter       String?
    bio           String?
    createdAt     DateTime  @default(now())
    updatedAt     DateTime  @updatedAt
    accounts      Account[]
    sessions      Session[]
    posts         Post[]    @relation("UserPosts")
    votes         Vote[]    @relation("UserVotes")
    reports       Report[]  @relation("UserReports")
}

model VerificationToken {
    identifier String
    token      String   @unique
    expires    DateTime

    @@unique([identifier, token])
}