Prisma•12mo ago

Dependency-dependents relations

I am having difficulty understanding whether my schema is correct, even if it reports no errors. It's basically that I'm trying to express a package registry as part of a package manager, and am having difficulty specifying

dependencies

dependencies

and

dependents

dependents

relations as part of the

PackageVersion

PackageVersion

model.

model PackageVersion {
  id                  BigInt                   @id @default(autoincrement())
  versionNumber       String
  publishedAt         DateTime                 @default(now())
  zip                 Bytes
  package             Package                  @relation(fields: [packageId], references: [id])
  packageId           BigInt
  dependencies        PackageVersion[]         @relation("Dependency")
  dependents          PackageVersion[]         @relation("Dependency")
  yanked              Boolean                  @default(false)
}

model PackageVersion {
  id                  BigInt                   @id @default(autoincrement())
  versionNumber       String
  publishedAt         DateTime                 @default(now())
  zip                 Bytes
  package             Package                  @relation(fields: [packageId], references: [id])
  packageId           BigInt
  dependencies        PackageVersion[]         @relation("Dependency")
  dependents          PackageVersion[]         @relation("Dependency")
  yanked              Boolean                  @default(false)
}

HydroperOP•1/5/25, 1:47 PM

I give up on Prisma -_-

RaphaelEtim•1/6/25, 8:35 AM

I think the confusion stems from having the same relation name for both dependencies and dependents fields. Also, from your code, you are trying to create a self-referencing many-to-many relationship for package dependencies. To properly express this relationship, you need to use distinct names for each side of the relation and add the necessary fields to make it an explicit many-to-many relationship. For example:

RaphaelEtim•1/6/25, 8:35 AM

Looking at the example i shared, I've introduced a new model to represent the many-to-many relationship explicitly. The

dependencies

dependencies

field in

PackageVersion

PackageVersion

now uses the relation name , representing the versions that this package depends on. The

dependents

dependents

field in

PackageVersion

PackageVersion

uses the relation name , representing the versions that depend on this package. The model has two fields referencing

PackageVersion

PackageVersion

, one for the dependency and one for the dependent.

You may also want to share your full schema in order for us to help you further.