datasource db {
  provider = "postgresql"
  url      = env("DATABASE_URL")
}

generator client {
  provider = "prisma-client-js"
}

model Company {
  id       String    @default(cuid()) @id
  payments Payment[]
}

model Visit {
  id      String   @default(cuid()) @id
  payment Payment?
}

model Payment {
  id        String  @default(cuid()) @id
  company   Company @relation(fields: [companyId], references: [id])
  companyId String
  visit     Visit?  @relation(fields: [visitId], references: [id])
  visitId   String?
}

const { PrismaClient } = require('@prisma/client')

const prisma = new PrismaClient()

const main = async () => {
  const newVisit = await prisma.visit.create({ data: {} })

  await prisma.visit.update({
    data: {
      payment: {
        create: {
          company: { connect: { id: '{{ company id here }}' }}
        }
      }
    },
    where: { id: newVisit.id }
  })
}

main()
  .then(() => console.log('Done 🎉'))
  .catch(err => console.log(err))
  .finally(() => prisma.disconnect())