GlossaryTypes

timestamp

Date and time value without timezone by default.

Timestamp columns store when an event happened, such as createdAt or publishedAt. Some dialects also offer timestamptz for timezone-aware values.

Example

Prisma

createdAt: timestamp("created_at").defaultNow()

integer

Whole number column, often used for foreign keys.

Uuid

Universally unique identifier stored as UUID.