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 |