Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | null |
|
|
{“what”:“UUID primary key, unique identifier for each resource.”,“why”:“Without it, resources cannot be referenced or joined uniquely.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:16.180940922+00:00”} |
|||||
| name | varchar | 255 | null |
|
|
{“what”:“Human-readable resource name, e.g., ‘my-app-postgres’.”,“why”:“Without it, users cannot identify the resource in UI or logs.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:16.201958798+00:00”} |
|||||
| app | varchar | 255 | √ | null |
|
|
{“what”:“Heroku app name the resource is attached to, if any.”,“why”:“Without it, the owning app is unknown, breaking per-app resource listings.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:16.218820811+00:00”} |
||||
| plan | varchar | 255 | null |
|
|
{“what”:“Heroku plan identifier, e.g., ‘hobby-dev’.”,“why”:“Without it, billing and capacity limits cannot be determined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:16.233152944+00:00”} |
|||||
| region | varchar | 255 | null |
|
|
{“what”:“Heroku region code, e.g., ‘us’ or ‘eu’.”,“why”:“Without it, latency and data residency compliance cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:16.246705033+00:00”} |
|||||
| options | jsonb | 2147483647 | √ | null |
|
|
{“what”:“Free-form JSON configuration options for the resource.”,“why”:“Without it, custom settings are lost, breaking resource behavior.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:16.264937825+00:00”} |
||||
| callback | varchar | 255 | null |
|
|
{“what”:“URL to call for provisioning or deprovisioning events.”,“why”:“Without it, Heroku cannot notify the provider of lifecycle changes.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:16.281464553+00:00”} |
|||||
| oauth_code | uuid | 2147483647 | null |
|
|
{“what”:“OAuth authorization code used to obtain access tokens.”,“why”:“Without it, token exchange cannot be performed, blocking API access.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:16.301946890+00:00”} |
|||||
| oauth_type | varchar | 255 | null |
|
|
{“what”:“OAuth grant type, e.g., ‘authorization_code’.”,“why”:“Without it, the token request flow is ambiguous and may fail.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:16.315035833+00:00”} |
|||||
| oauth_expire | timestamp | 29,6 | null |
|
|
{“what”:“UTC timestamp when the OAuth token expires.”,“why”:“Without it, expired tokens are used, causing authentication failures.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:16.326989233+00:00”} |
|||||
| organization_id | uuid | 2147483647 | √ | null |
|
|
{“what”:“UUID of the owning organization, if any.”,“why”:“Without it, resources cannot be scoped to an organization for access control.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:16.341172864+00:00”} |
||||
| created_at | timestamp | 29,6 | null |
|
|
{“what”:“UTC timestamp when the resource record was created.”,“why”:“Without it, audit trails and ordering are impossible.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:16.357177065+00:00”} |
|||||
| updated_at | timestamp | 29,6 | null |
|
|
{“what”:“UTC timestamp of the last update to this record.”,“why”:“Without it, stale data cannot be detected or reconciled.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:16.374774832+00:00”} |
|||||
| deleted_at | timestamp | 29,6 | √ | null |
|
|
{“what”:“UTC timestamp when the resource was soft-deleted, null if active.”,“why”:“Without it, deleted resources would disappear, breaking historical references.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:16.389206084+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| heroku_resources_pkey | Primary key | Asc | id |