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 |