heroku_resources


Description

{“what”:“A provisioned Heroku add-on or app with plan, region, and OAuth credentials.”,“why”:“Without it, no record of provisioned resources exists, breaking billing and management.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T00:01:16.144804938+00:00”}

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
organizations.id heroku_resources_organization_id_fkey R

{“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

Relationships