Keep getting relation constraint error when migrating

export const userToEvent = pgTable(
  'user_to_event',
  {
    id: varchar('id')
      .notNull()
      .primaryKey()
      .$defaultFn(() => generateId('user_to_event')),
    userId: varchar('user_id')
      .notNull()
      .references(() => user.id),
    eventId: varchar('event_id')
      .notNull()
      .references(() => event.id),
    paymentId: varchar('payment_id')
      .notNull()
      .references(() => payment.id),
    registeredAt: timestamp('registered_at', { mode: 'date' }),
    eventConfirmation: varchar('event_confirmation'),
  },
  (table) => {
    return {
      eventConfirmationIdx: index('event_confirmation_idx').on(
        table.eventConfirmation,
      ),
      userIdEventIdUniq: unique().on(table.userId, table.eventId),
    }
  },
)

// src/lib
--db
  -- schema
    -- some-schemas.schema.ts
    -- ...more schemas

    -- index.ts  <- where I export all schema files as "export * from './some-schema.schema'"

import { defineConfig } from 'drizzle-kit'
import { env } from '@/lib/env'

export default defineConfig({
  schema: './src/lib/db/schema/index.ts',
  dialect: 'postgresql',
  migrations: {
    table: 'migrations',
    schema: 'public',
  },
  dbCredentials: {
    url: env.DATABASE_URL,
  },
  out: './drizzle',
})