betterAuth + drizzle + pg throws error on `db push`

PostgresError: foreign key constraint "account_user_id_user_id_fk" cannot be implemented
    at ErrorResponse (file:///Users/jackbisceglia/p/planar/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/src/connection.js:794:26)
    at handle (file:///Users/jackbisceglia/p/planar/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/src/connection.js:480:6)
    at Socket.data (file:///Users/jackbisceglia/p/planar/node_modules/.pnpm/postgres@3.4.7/node_modules/postgres/src/connection.js:315:9)
    at Socket.emit (node:events:519:28)
    at addChunk (node:internal/streams/readable:561:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:512:3)
    at Readable.push (node:internal/streams/readable:392:5)
    at TCP.onStreamRead (node:internal/stream_base_commons:189:23) {
  severity_local: 'ERROR',
  severity: 'ERROR',
  code: '42804',
  detail: 'Key columns "user_id" and "id" are of incompatible types: text and uuid.',
  file: 'tablecmds.c',
  line: '9896',
  routine: 'ATAddForeignKeyConstraint'
}