Issue with cyclic dependency defining foreign keys

[outofthisworld]

Having an issue when defining foreign keys on relations which are required to reference each other. Because userTable needs to import agencyTable to reference agencyTable.id and agencyTable needs to import userTable to reference userTable.id i'm experiencing issues.

Having them in the same file, or even splitting the the table constraints into seperate files doesn't fix the issue. How can I do this and fix the issue? removing one side of the FK works.. but its not ideal because I want to enforce referential integrity on both sides.

//user.ts
const userTable = pgTable(
  "user",
  {
    id: uuid().notNull().defaultRandom(),
    email: varchar({ length: 255 }),
    username: varchar({ length: 255 }),
    emailVerified: boolean().default(false).notNull(),
    agency: uuid(),
    lastLogin: timestamp({ withTimezone: true, mode: "string" }),
    createdAt: timestamp({ withTimezone: true, mode: "string" })
      .notNull()
      .default(new Date().toISOString()),
    updatedAt: timestamp({ withTimezone: true, mode: "string" })
      .notNull()
      .default(new Date().toISOString()),
    deletedAt: timestamp({ withTimezone: true, mode: "string" }),
  },
  (table) => [
    primaryKey({ columns: [table.id] }),
    foreignKey({
      columns: [table.agency],
      foreignColumns: [agencyTable.id],
    }),
  ]
);

// agency.ts
const agencyTable = pgTable(
  "agency",
  {
    id: uuid().notNull().defaultRandom(),
    name: varchar({ length: 255 }),
    logo: uuid(),
    owner: uuid(),
    createdAt: timestamp({ withTimezone: true, mode: "string" })
      .notNull()
      .default(new Date().toISOString()),
    updatedAt: timestamp({ withTimezone: true, mode: "string" })
      .notNull()
      .default(new Date().toISOString()),
    deletedAt: timestamp({ withTimezone: true, mode: "string" }),
  },
  (table) => [
    primaryKey({ columns: [table.id] }),
    foreignKey({ columns: [table.owner], foreignColumns: [userTable.id] }),
  ]
);