repo_descriptions


Description

{“what”:“Per-device repository metadata: description, category, model, and generation time.”,“why”:“Without it, no record of what each device knows about a repo.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:34.489870394+00:00”}

Columns

Column Type Size Nulls Auto Default Children Parents Comments
device text 2147483647 null

{“what”:“Device identifier that fetched the repo description; part of composite key.”,“why”:“Separates entries from different devices for the same repo.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:34.503381466+00:00”}

repo text 2147483647 null

{“what”:“Repository identifier (e.g., owner/name) that the description refers to.”,“why”:“Identifies which repo the row describes; with device forms unique key.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:34.540176864+00:00”}

description text 2147483647 √ null

{“what”:“Free-text summary of the repository’s purpose or content.”,“why”:“Provides human-readable context not available from code.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:34.551585884+00:00”}

category text 2147483647 √ null

{“what”:“Optional classification label such as ‘library’ or ‘tool’.”,“why”:“Enables grouping or filtering repos by type.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:34.650826287+00:00”}

model text 2147483647 √ null

{“what”:“Name or version of the model that generated the description.”,“why”:“Tracks which model produced the text for reproducibility.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:34.673810963+00:00”}

generated_at timestamptz 35,6 √ now()

{“what”:“Timestamp (with time zone) when the description was generated; defaults to now.”,“why”:“Shows data freshness and allows ordering by generation time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:13:34.708446400+00:00”}

Indexes

Constraint Name Type Sort Column(s)
repo_descriptions_pkey Primary key Asc/Asc device + repo

Relationships