availability_history


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('availability_history_id_seq'::regclass)

{“what”:“Unique numeric identifier for each availability check row.”,“why”:“Without it, rows cannot be uniquely referenced for updates or joins.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:12.360956947+00:00”}

offering_type text 2147483647 null

{“what”:“Text label for the kind of offering the check applies to.”,“why”:“Without it, offering_id alone is ambiguous across different offering types.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:12.417213802+00:00”}

offering_id int4 10 null

{“what”:“Numeric identifier of the offering within its type.”,“why”:“Without it, the check cannot be tied to a specific offering.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:12.427556073+00:00”}

available bool 1 null

{“what”:“Boolean flag: true if the offering was available at check time.”,“why”:“Without it, the outcome of the check is unknown, making the history meaningless.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:12.467521011+00:00”}

checked_at timestamptz 35,6 now()

{“what”:“Timestamp with time zone when the check was performed.”,“why”:“Without it, the timing and order of checks are unknown, preventing time-based analysis.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:12.493335318+00:00”}

check_source text 2147483647 √ null

{“what”:“Optional text identifying the system or method that performed the check.”,“why”:“Without it, checks from different sources cannot be distinguished, complicating debugging.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:14:12.505421356+00:00”}

Indexes

Constraint Name Type Sort Column(s)
availability_history_pkey Primary key Asc id

Relationships