Robert Cornacchia
06/21/2022, 1:26 AMmodel Debate {
id Int @id @default(autoincrement())
topic String
status DebateStatus @default(UPCOMING)
createdAt DateTime @default(now())
isDaily Boolean @default(false)
start DateTime?
end DateTime?
author User @relation("UserAuthorsDebate", fields: [authorId], references: [id])
authorId Int
posts Post[]
upvotedBy User[] @relation("UserUpvotesDebate", references: [id])
poll Poll?
revisedPoll Poll? <------------------------------- Want to add this!
}
model Poll {
id Int @id @default(autoincrement())
debate Debate @relation(fields: [debateId], references: [id])
debateId Int @unique
options PollOption[]
}
Austin
06/21/2022, 9:06 PMauthor
and upvotedBy
fields. You need to disambiguate the relations by using the @relation
attribute and passing a unique name.
Let me know if you run into any trouble!Robert Cornacchia
06/22/2022, 12:49 AMmodel Debate {
id Int @id @default(autoincrement())
topic String
status DebateStatus @default(UPCOMING)
createdAt DateTime @default(now())
isDaily Boolean @default(false)
start DateTime?
end DateTime?
author User @relation("UserAuthorsDebate", fields: [authorId], references: [id])
authorId Int
upvotedBy User[] @relation("UserUpvotesDebate", references: [id])
poll Poll? @relation("pollForDebate", fields: [pollId], references: [id])
revisedPoll Poll? @relation("revisedPollForDebate", fields: [pollId], references: [id])
posts Post[]
Poll Poll[]
pollId Int?
pollId Int?
}
model Poll {
id Int @id @default(autoincrement())
debate Debate @relation(fields: [debateId], references: [id])
debateId Int @unique
options PollOption[]
Debate Debate[]
Debate Debate[]
}
Robert Cornacchia
06/22/2022, 12:49 AMRobert Cornacchia
06/22/2022, 12:49 AMmodel Debate {
id Int @id @default(autoincrement())
topic String
status DebateStatus @default(UPCOMING)
createdAt DateTime @default(now())
isDaily Boolean @default(false)
start DateTime?
end DateTime?
author User @relation("UserAuthorsDebate", fields: [authorId], references: [id])
authorId Int
upvotedBy User[] @relation("UserUpvotesDebate", references: [id])
posts Post[]
poll Poll? @relation("pollForDebate")
revisedPoll Poll? @relation("revisedPollForDebate")
}
Robert Cornacchia
06/22/2022, 12:54 AMRevisedPoll
Robert Cornacchia
06/22/2022, 12:54 AMAustin
06/22/2022, 8:23 PMmodel Debate {
id Int @id @default(autoincrement())
topic String
createdAt DateTime @default(now())
isDaily Boolean @default(false)
start DateTime?
end DateTime?
authorId Int
poll Poll? @relation(name: "poll", fields: [pollId], references: [id])
pollId Int? @unique
revisedPoll Poll? @relation(name: "revised_poll", fields: [revisedPollId], references: [id])
revisedPollId Int? @unique
}
model Poll {
id Int @id @default(autoincrement())
debateId Int? @unique
debate Debate? @relation(name: "poll")
revisedDebateId Int? @unique
revisedDebate Debate? @relation(name: "revised_poll")
Robert Cornacchia
06/26/2022, 3:07 AM