Hi guys. I'm trying to use folowing prisma schema
...
# orm-helpr
Ruslan Baigunussov
08/19/2019, 7:10 AMHi guys. I'm trying to use folowing prisma schema
Copy code
enum Gender {
MALE
FEMALE
}
type User {
id: Int! @id
createdAt: DateTime! @createdAt
updatedAt: DateTime! @updatedAt
firstName: String!
lastName: String!
gender: Gender!
birthday: DateTime!
email: String! @unique
password: String!
phone: String @unique
avatar: Picture
usersToClubs: [UserToClub!]
}
type Club {
id: Int! @id
createdAt: DateTime! @createdAt
updatedAt: DateTime! @updatedAt
name: String! @unique
description: String
location: Location
avatar: Picture
usersToClubs: [UserToClub!]
}
enum ClubRole {
MEMBER
MANAGER
}
type UserToClub @relationTable {
user: User!
club: Club!
role: ClubRole!
}java.util.NoSuchElementException: None.get at scala.None$.get(Option.scala:349)prisma deploytype UserToClub Copy code
type UserToClub {
id: Int! @id
user: User!
club: Club!
role: ClubRole!
}idd
Deepak Pathak
08/19/2019, 7:14 AMLooks like Prisma is asking for an ID field to uniquely identify each row in
UserToClubDeepak Pathak
08/19/2019, 7:15 AMI am not sure if Prisma allows for Composite key where you can make (user , club) fields as a composite key, that way uniqueness could be guaranteed., This is how things work in SQL databases like SQL Server.
r
Ruslan Baigunussov
08/19/2019, 7:22 AMUnfortunately, multiple ID fields (compound indexes) are not supported
d
Deepak Pathak
08/19/2019, 7:22 AMyup, so ID with @id is the way to go for now 😞
r
Ruslan Baigunussov
08/19/2019, 7:24 AMBut I think the problem is
@realtionTable Copy code
type UserToClub @relationTable {
id: Int! @id
user: User!
club: Club!
role: ClubRole!
}