Drizzle TeamDT
Drizzle Team•2y ago
Julian

Drizzle Studio Showing NaN for primary key

I'm seeing NaN for primary key (
id
) in Drizzle studio although it's uuid and when I actually call SQL, I see the correct uuid ID. Is this a bug? foreignKey (hirespaceId) seems just fine.

Schema:
export const evaluationTable = pgTable("evaluation", {
  id: uuid("id").primaryKey().defaultRandom(),
  userId: text("user_id").references(() => userTable.id),
  hirespaceId: uuid("hirespace_id")
    .references(() => hirespaceTable.id)
    .notNull(),
  description: varchar("description", { length: 256 }).notNull(),
});


Dependencies:

    "drizzle-orm": "^0.30.8",
    "drizzle-kit": "^0.20.16",


Postgres Docker Image:

# Use postgres/example user/password credentials
version: "3.1"

services:
  db:
    image: postgres
    volumes:
      - pgdata:/var/lib/postgresql/data
    environment:
      POSTGRES_USER: postgres
      POSTGRES_PASSWORD: testtest
      POSTGRES_DB: dbdb
    ports:
      - 4321:4321
    command: -p 4321
volumes:
  pgdata:


Image:
image.png
Was this page helpful?