model FeaturedClip {
gameId String @unique
acceptedClipId String @unique
game Game @relation(fields: [gameId], references: [id])
acceptedClip AcceptedClip @relation(fields: [acceptedClipId], references: [id])
}
model AcceptedClip {
id String @id @default(cuid())
youtubeId String @unique
submittedClipId String @unique
gameId String
acceptedAt DateTime @default(now())
game Game @relation(fields: [gameId], references: [id])
submittedClip SubmittedClip @relation(fields: [submittedClipId], references: [id])
featuredClip FeaturedClip?
@@index([submittedClipId])
@@index([gameId])
}
model SubmittedClip {
id String @id @default(cuid())
videoFilePath String
gameId String
rankId String
userId String
submittedAt DateTime @default(now())
rank Rank @relation(fields: [rankId], references: [id])
game Game @relation(fields: [gameId], references: [id])
user User @relation(fields: [userId], references: [id])
acceptedClip AcceptedClip?
@@index([userId])
@@index([gameId])
@@index([rankId])
}
model FeaturedClip {
gameId String @unique
acceptedClipId String @unique
game Game @relation(fields: [gameId], references: [id])
acceptedClip AcceptedClip @relation(fields: [acceptedClipId], references: [id])
}
model AcceptedClip {
id String @id @default(cuid())
youtubeId String @unique
submittedClipId String @unique
gameId String
acceptedAt DateTime @default(now())
game Game @relation(fields: [gameId], references: [id])
submittedClip SubmittedClip @relation(fields: [submittedClipId], references: [id])
featuredClip FeaturedClip?
@@index([submittedClipId])
@@index([gameId])
}
model SubmittedClip {
id String @id @default(cuid())
videoFilePath String
gameId String
rankId String
userId String
submittedAt DateTime @default(now())
rank Rank @relation(fields: [rankId], references: [id])
game Game @relation(fields: [gameId], references: [id])
user User @relation(fields: [userId], references: [id])
acceptedClip AcceptedClip?
@@index([userId])
@@index([gameId])
@@index([rankId])
}