Node.js Drizzle PostgreSQL bigserial 类型

bigserial()

bigserial("record_page_view_id_seq", {mode: "bigint"})，第一个参数指定序列的名称，第二个参数传入mode属性，指定bigint或number。

import { bigint, pgTable, timestamp } from "drizzle-orm/pg-core";

const pageViewRecord = pgTable("record_page_view", {
    id: bigserial("record_page_view_id_seq", {mode: "bigint"}).primaryKey(),
    createTs: timestamp({withTimezone: true}),
    updateTs: timestamp({withTimezone: true}),
});

官方文档

https://orm.drizzle.team/docs/column-types/pg#bigserial