When using createInsertSchema from drizzle-zod, primaryKey is defined as number | undefined

[oleksii-lukin]

I have this table

export const authors = sqliteTable('authors', {
  id: integer('id').primaryKey({ autoIncrement: true }),
});
export const insertAuthorsSchema = createInsertSchema(authors);

and produced type looks like this

const insertAuthorsSchema: ZodObject<{
    id: ZodOptional<ZodNumber>;
}, UnknownKeysParam, ZodTypeAny, {
    id?: number | undefined;
}, {
    id?: number | undefined;
}>

But why it's optional, shouldn't it be mandatory since it's primary key?

I tried to look into createInsertSchema code which uses BuildInsertSchema and I see that there's TNoOptional param, but I have no idea what is going there? Should I pass it through refine param?

Just now I noticed UnknownKeysParam in produced type, but after changing table definition to

export const authors = sqliteTable(
  'authors',
  {
    id: integer('id').primaryKey({ autoIncrement: true }),
  },
  (t) => ({
    pk: primaryKey({ columns: [t.id] }),
  }),
);

I still see no difference.

Inserting .notNull() on id also changes nothing

[jerricko]

It's not required for insert schema because the database is handling the primary key generation.

[oleksii-lukin]

oh yes, it's auto-generated, now it makes sense