clever_cloud_resources


Description

{“what”:“A Clever Cloud addon resource instance, linking addon, owner, user, and organization.”,“why”:“Without it, there is no record of which addons are provisioned, for whom, and with what configuration.”,“by”:“fleet-annotator-worker”,“at”:“2026-09-23T04:03:36.609315331+00:00”}

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

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

Relationships