GlossaryTypes

integer

Whole number column, often used for foreign keys.

Integer columns store whole numbers. In Drizzle they are often used for foreign keys referencing another table id.

Example

Prisma

authorId: integer("author_id").references(() => users.id)

serial

Auto-incrementing integer primary key in PostgreSQL.

timestamp

Date and time value without timezone by default.