Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | null |
|
|
{“what”:“UUID that uniquely identifies this gallery row.”,“why”:“Without it, cannot reference or join to this row.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:38.666236195+00:00”} |
|||||
| project_id | uuid | 2147483647 | null |
|
|
{“what”:“UUID of the project this gallery entry belongs to.”,“why”:“Without it, cannot associate gallery content with a project.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:38.689570161+00:00”} |
|||||
| slug | varchar | 255 | null |
|
|
{“what”:“URL-safe string for this gallery entry, e.g., ‘my-project’.”,“why”:“Without it, cannot have human-readable URLs or lookup by slug.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:38.708467199+00:00”} |
|||||
| icon | varchar | 255 | null |
|
|
{“what”:“Path or URL to the icon image for this gallery entry.”,“why”:“Without it, the gallery cannot display an icon.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:38.719939224+00:00”} |
|||||
| color | varchar | 255 | null |
|
|
{“what”:“Hex color code (e.g., ‘#FF5733’) used for theming or accent.”,“why”:“Without it, the gallery entry lacks a brand color for UI.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:38.808616233+00:00”} |
|||||
| website | varchar | 255 | null |
|
|
{“what”:“URL to the project’s website or external link.”,“why”:“Without it, users cannot navigate to the project’s site.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:38.860913229+00:00”} |
|||||
| varchar | 255 | null |
|
|
{“what”:“Path or URL to the banner image for the gallery entry.”,“why”:“Without it, the gallery cannot display a banner.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:38.905977383+00:00”} |
||||||
| tips | text | 2147483647 | null |
|
|
{“what”:“Free-form text with usage tips or notes for the project.”,“why”:“Without it, users miss guidance on how to use the project.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:38.997316741+00:00”} |
|||||
| description | text | 2147483647 | null |
|
|
{“what”:“Free-form text describing the project or gallery entry.”,“why”:“Without it, the gallery lacks context for what the project is.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:39.011518204+00:00”} |
|||||
| analysis | text | 2147483647 | null |
|
|
{“what”:“Free-form text containing analysis or evaluation of the project.”,“why”:“Without it, the gallery lacks performance or quality insights.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:39.027249781+00:00”} |
|||||
| created_at | timestamp | 29,6 | null |
|
|
{“what”:“Timestamp when the gallery entry was created.”,“why”:“Without it, cannot sort or filter by creation time.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:39.061562755+00:00”} |
|||||
| updated_at | timestamp | 29,6 | null |
|
|
{“what”:“Timestamp of the last update to this gallery entry.”,“why”:“Without it, cannot know if content is stale.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:39.088530530+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| gallery_pkey | Primary key | Asc | id |
| gallery_project_id_index | Must be unique | Asc | project_id |
| gallery_slug_index | Must be unique | Asc | slug |