Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||
|---|---|---|---|---|---|---|---|---|---|---|---|
| id | uuid | 2147483647 | null |
|
|
{“what”:“UUID primary key, unique identifier for the resource.”,“why”:“Without it, rows cannot be uniquely referenced or updated.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:36.679078808+00:00”} |
|||||
| addon_id | varchar | 255 | null |
|
|
{“what”:“External identifier of the addon product (e.g., from Clever Cloud catalog).”,“why”:“Without it, the resource cannot be linked to its addon definition or pricing.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:36.695232027+00:00”} |
|||||
| owner_id | varchar | 255 | null |
|
|
{“what”:“Identifier of the owning entity (e.g., app or team) in the platform.”,“why”:“Without it, ownership and billing attribution for the resource is unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:36.762327662+00:00”} |
|||||
| owner_name | varchar | 255 | null |
|
|
{“what”:“Human-readable name of the owner, denormalized for display.”,“why”:“Without it, owner names require a join to the owner table, slowing lookups.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:36.773503062+00:00”} |
|||||
| user_id | varchar | 255 | null |
|
|
{“what”:“Identifier of the user who created or manages this resource.”,“why”:“Without it, the responsible user for the resource cannot be determined.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:36.840562709+00:00”} |
|||||
| plan | varchar | 255 | null |
|
|
{“what”:“Service plan name (e.g., ‘free’, ‘standard’) for this resource.”,“why”:“Without it, pricing, limits, and features of the resource are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:36.979548403+00:00”} |
|||||
| region | varchar | 255 | null |
|
|
{“what”:“Geographic region where the resource is deployed (e.g., ‘eu-west-1’).”,“why”:“Without it, latency, compliance, and failover behavior cannot be assessed.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:37.027619521+00:00”} |
|||||
| callback_url | varchar | 255 | null |
|
|
{“what”:“URL that Clever Cloud calls to notify the owner of resource events.”,“why”:“Without it, the platform cannot send provisioning or deprovisioning notifications.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:37.048913648+00:00”} |
|||||
| logplex_token | varchar | 255 | null |
|
|
{“what”:“Token used to authenticate log drains to Logplex.”,“why”:“Without it, logs cannot be securely streamed to the owner’s log system.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:37.268668143+00:00”} |
|||||
| options | jsonb | 2147483647 | √ | null |
|
|
{“what”:“JSON object with addon-specific configuration options (e.g., size, features).”,“why”:“Without it, addon-specific settings are lost, making the resource non-functional.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:37.288867948+00:00”} |
||||
| organization_id | uuid | 2147483647 | √ | null |
|
|
{“what”:“UUID of the organization that owns this resource, if any.”,“why”:“Without it, resources cannot be grouped or billed at the organization level.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:37.301183994+00:00”} |
||||
| created_at | timestamp | 29,6 | null |
|
|
{“what”:“Timestamp when the resource was created, in UTC.”,“why”:“Without it, resource age and audit history are unknown.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:37.321936432+00:00”} |
|||||
| updated_at | timestamp | 29,6 | null |
|
|
{“what”:“Timestamp of the last update to this resource, in UTC.”,“why”:“Without it, stale or concurrent modifications cannot be detected.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:37.356157861+00:00”} |
|||||
| deleted_at | timestamp | 29,6 | √ | null |
|
|
{“what”:“Timestamp when the resource was soft-deleted, null if active.”,“why”:“Without it, deleted resources would disappear, breaking audit and billing history.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:37.383443133+00:00”} |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| clever_cloud_resources_pkey | Primary key | Asc | id |