Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| slug | text | 2147483647 | null |
|
|
{“what”:“Unique URL-safe identifier for the category, e.g., ‘bug’.”,“why”:“Serves as primary key and stable reference for foreign keys from cards.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:24.695139826+00:00”} |
|||||
| name | text | 2147483647 | null |
|
|
{“what”:“Display name for the category, e.g., ‘Bug’.”,“why”:“Provides a readable label for UI and reports; slug alone is not user-friendly.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:24.907438767+00:00”} |
|||||
| color | text | 2147483647 | null |
|
|
{“what”:“Hex color code (e.g., ‘#FF0000’) used for category badges.”,“why”:“Enables consistent visual styling without hardcoding colors in client code.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:25.590304436+00:00”} |
|||||
| description | text | 2147483647 | null |
|
|
{“what”:“Plain-text explanation of what the category means.”,“why”:“Clarifies category intent for users and maintainers, preventing misuse.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:25.715825512+00:00”} |
|||||
| action_posture | text | 2147483647 | null |
|
|
{“what”:“Expected action posture value, e.g., ‘active’ or ‘passive’.”,“why”:“Drives workflow logic that treats categories differently based on required action.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:25.781303498+00:00”} |
|||||
| sort_order | int4 | 10 | 0 |
|
|
{“what”:“Integer for ordering categories in lists; lower appears first.”,“why”:“Controls display order without relying on alphabetical or insertion order.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:15:26.059795610+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| card_categories_pkey | Primary key | Asc | slug |