Β© 2026 Hedgehog Software, LLC

TwitterGitHubDiscord
More
CommunitiesDocsAboutTermsPrivacy
Search
Star
Setup for Free
Drizzle TeamDT
Drizzle Teamβ€’2y agoβ€’
8 replies
Julian

Drizzle Studio Showing NaN for primary key

I'm seeing
NaN
NaN
for primary key (
id
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
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(),
});
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",
    "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:
# 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
Drizzle TeamJoin
The official Discord for all Drizzle related projects, such as Drizzle ORM, Drizzle Kit, Drizzle Studio and more!
11,879Members
Resources

Similar Threads

Was this page helpful?
Recent Announcements

Similar Threads

drizzle push and primary key order
Drizzle TeamDTDrizzle Team / help
3y ago
drizzle-studio showing duplicate relations
Drizzle TeamDTDrizzle Team / help
2y ago
Drizzle-kit Multiple primary key defined issue
Drizzle TeamDTDrizzle Team / help
2y ago
Why is drizzle generating composite key instead of primary key?
Drizzle TeamDTDrizzle Team / help
2y ago