bench_card


Description

{“what”:“A benchmark card with metadata and content.”,“why”:“Without it, benchmark cases cannot be stored or retrieved.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:04:48.041962044+00:00”}

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

Relationships