sequences


Description

A table for generating atomic sequence numbers

Columns

Column Type Size Nulls Auto Default Children Parents Comments
name varchar 50 null

{“what”:“Unique sequence name, e.g., ‘order_id_seq’; the lookup key.”,“why”:“Without it, sequences cannot be referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:50.496873254+00:00”}

next_val int8 19 null

{“what”:“Next bigint value to be returned; incremented on each allocation.”,“why”:“Without it, the sequence cannot provide the next number, breaking ID generation.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:06:50.509555958+00:00”}

Indexes

Constraint Name Type Sort Column(s)
sequences_pkey Primary key Asc name

Relationships