Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments |
|---|---|---|---|---|---|---|---|---|
| device | text | 2147483647 | null |
|
|
{“what”:“Device name or ID; with path forms the unique key.”,“why”:“Without it, cards from different devices cannot be distinguished.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:48.070642189+00:00”} |
||
| path | text | 2147483647 | null |
|
|
{“what”:“File path on the device; with device forms the unique key.”,“why”:“Without it, multiple cards on the same device would collide.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:48.147926434+00:00”} |
||
| source | text | 2147483647 | null |
|
|
{“what”:“Origin of the card, e.g., file, URL, or manual entry.”,“why”:“Without it, the provenance of the card is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:48.342702142+00:00”} |
||
| card_id | text | 2147483647 | √ | null |
|
|
{“what”:“External identifier for the card, if any.”,“why”:“Without it, cards cannot be matched to external systems.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:48.433352846+00:00”} |
|
| provider | text | 2147483647 | √ | null |
|
|
{“what”:“Provider name, e.g., OpenAI, Anthropic.”,“why”:“Without it, the vendor behind the card is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:48.674488173+00:00”} |
|
| model | text | 2147483647 | √ | null |
|
|
{“what”:“Model name associated with the card.”,“why”:“Without it, the model version is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:48.735536802+00:00”} |
|
| mode | text | 2147483647 | √ | null |
|
|
{“what”:“Operational mode, e.g., training or inference.”,“why”:“Without it, the context of the card is ambiguous.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:48.810003473+00:00”} |
|
| run_id | uuid | 2147483647 | √ | null |
|
|
{“what”:“UUID of the run that produced or used this card.”,“why”:“Without it, the card cannot be linked to a specific run.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:48.832376061+00:00”} |
|
| source_host | text | 2147483647 | √ | null |
|
|
{“what”:“Hostname or IP of the machine that provided the card.”,“why”:“Without it, the origin machine is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:48.872672985+00:00”} |
|
| harness | text | 2147483647 | √ | null |
|
|
{“what”:“Name of the harness or framework used.”,“why”:“Without it, the tooling context is missing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:49.263625393+00:00”} |
|
| confidence | text | 2147483647 | √ | null |
|
|
{“what”:“Confidence level as text, e.g., high, medium, low.”,“why”:“Without it, the reliability of the card is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:49.445581942+00:00”} |
|
| context_window | int8 | 19 | √ | null |
|
|
{“what”:“Context window size in tokens.”,“why”:“Without it, the model’s capacity is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:49.506921118+00:00”} |
|
| measured | date | 13 | √ | null |
|
|
{“what”:“Date when the card’s metrics were measured.”,“why”:“Without it, the temporal validity of the data is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:49.532389584+00:00”} |
|
| content_sha256 | text | 2147483647 | null |
|
|
{“what”:“SHA256 hash of the card’s content, used for integrity.”,“why”:“Without it, content tampering cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:49.563902792+00:00”} |
||
| file_bytes | int8 | 19 | √ | null |
|
|
{“what”:“Size of the source file in bytes.”,“why”:“Without it, file size is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:49.608939309+00:00”} |
|
| file_mtime | timestamptz | 35,6 | √ | null |
|
|
{“what”:“Last modification time of the source file.”,“why”:“Without it, file freshness cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:49.716160736+00:00”} |
|
| frontmatter | jsonb | 2147483647 | '{}'::jsonb |
|
|
{“what”:“JSON object of frontmatter metadata from the source file.”,“why”:“Without it, structured metadata is lost.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:49.750257928+00:00”} |
||
| parsed | bool | 1 | null |
|
|
{“what”:“Flag indicating if the card was successfully parsed.”,“why”:“Without it, unparsed cards cannot be filtered.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:49.774890263+00:00”} |
||
| parse_note | text | 2147483647 | √ | null |
|
|
{“what”:“Error or warning message from parsing, if any.”,“why”:“Without it, parse failures are unexplained.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:49.869607021+00:00”} |
|
| linked_run | bool | 1 | false |
|
|
{“what”:“Flag indicating if the card is linked to a run.”,“why”:“Without it, run linkage status is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:49.931523006+00:00”} |
||
| first_seen | timestamptz | 35,6 | now() |
|
|
{“what”:“Timestamp when the card was first observed.”,“why”:“Without it, the card’s discovery time is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:49.973585440+00:00”} |
||
| last_scanned | timestamptz | 35,6 | null |
|
|
{“what”:“Timestamp of the most recent scan of this card.”,“why”:“Without it, staleness of the card cannot be determined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:50.000562470+00:00”} |
||
| body | text | 2147483647 | √ | null |
|
|
{“what”:“Full text content of the card.”,“why”:“Without it, the card’s actual content is unavailable.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:50.035148047+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| bench_card_pkey | Primary key | Asc/Asc | device + path |
| bench_card_card_id_idx | Performance | Asc | card_id |
| bench_card_provider_idx | Performance | Asc | provider |
| bench_card_run_idx | Performance | Asc | run_id |
| bench_card_sha_idx | Performance | Asc | content_sha256 |
| bench_card_source_idx | Performance | Asc | source |