Hello! I added a relation to the schema and it looks like

model Company {
  id        Int   @id
  name     String
  users User[]
}

model User {
  userId        Int       @default(autoincrement()) @id
  companyId     Int?
  worksAt   Company? @relation(fields: [companyId], references: [id])
  email         String?   @unique
  name          String
  password      String
  @@map(name: "users")

When I run $ prisma db push I get this error. Any assistance will be appreciated

@Charity Darko 👋 Did you already have relation data or the

companyId

field in the database before running

db push

?

Yes @Ryan Schema Before

model Company {
  companyId        Int     @default(autoincrement()) @id
  name     String
}

model User {
  userId        Int       @default(autoincrement()) @id
  companyId     Int
  email         String?   @unique
  name          String
  password      String
  @@map(name: "users")
}

Schema After

model Company {
  id        Int   @id
  name     String
  users User[]
}

model User {
  userId        Int       @default(autoincrement()) @id
  companyId     Int?
  worksAt   Company? @relation(fields: [companyId], references: [id])
  email         String?   @unique
  name          String
  password      String
  @@map(name: "users")
}

In that case, you can make this work with any one of the below options: 1. Deleting all data in the 

companyId

 field and then running 

db push

2. Manually checking what 

companyId

 rows do not match an existing 

Company

  and deleting/fixing these.

The first option worked perfectly. Thanks @Ryan 👍