model Coin {
  id              String          @id @default(cuid())
  favouritedCoins FavouriteCoin[]
}

model FavouriteCoin {
  user   User   @relation(fields: [userId], references: [id], onDelete: Cascade)
  userId String
  coin   Coin   @relation(fields: [coinId], references: [id], onDelete: Cascade)
  coinId String

  @@unique([userId, coinId])
}

model User {
  id             String          @id @default(cuid())
  favouriteCoins FavouriteCoin[]
}

model Coin {
  id              String          @id @default(cuid())
  favouritedCoins FavouriteCoin[]
}

model FavouriteCoin {
  user   User   @relation(fields: [userId], references: [id], onDelete: Cascade)
  userId String
  coin   Coin   @relation(fields: [coinId], references: [id], onDelete: Cascade)
  coinId String

  @@unique([userId, coinId])
}

model User {
  id             String          @id @default(cuid())
  favouriteCoins FavouriteCoin[]
}