{"startedAt":"2026-07-02T16:32:21.392Z","status":"complete","checks":[{"name":"current_database","ok":true,"rows":[{"database":"ipeasy"}]},{"name":"migration_status","ok":true,"rows":[{"migration_name":"20260702173000_repair_api_keys_legacy_schema","finished_at":null,"rolled_back_at":null},{"migration_name":"20260702101500_repair_signup_legacy_schema","finished_at":"2026-07-01T20:54:47.535Z","rolled_back_at":null},{"migration_name":"20260701080500_relax_legacy_fulfillment_delivery_columns","finished_at":"2026-07-01T08:05:03.287Z","rolled_back_at":null},{"migration_name":"20260701070500_repair_orders_status_enum","finished_at":"2026-07-01T08:00:40.350Z","rolled_back_at":null},{"migration_name":"20260630235900_repair_order_extra_legacy_not_null","finished_at":"2026-06-30T13:10:16.773Z","rolled_back_at":null},{"migration_name":"20260630234500_repair_order_purchase_legacy_schema","finished_at":"2026-06-30T11:34:26.373Z","rolled_back_at":null},{"migration_name":"20260630223000_resource_catalog_projection","finished_at":"2026-06-29T23:10:24.465Z","rolled_back_at":null},{"migration_name":"20260630211500_inventory_recent_cover_index","finished_at":"2026-06-29T23:09:35.727Z","rolled_back_at":null},{"migration_name":"20260630203000_inventory_latest_cover_index","finished_at":"2026-06-29T23:07:11.473Z","rolled_back_at":null},{"migration_name":"20260630192000_repair_tenant_admin_legacy_schema","finished_at":"2026-06-29T23:07:11.459Z","rolled_back_at":null},{"migration_name":"20260630183000_repair_ledger_entries_legacy_not_null","finished_at":"2026-06-29T19:32:51.530Z","rolled_back_at":null},{"migration_name":"20260629134000_repair_ledger_entries_current_columns","finished_at":"2026-06-29T00:05:53.058Z","rolled_back_at":null}]},{"name":"upstream_request_log_columns","ok":true,"rows":[{"column_name":"id","data_type":"text"},{"column_name":"site_id","data_type":"uuid"},{"column_name":"tenant_id","data_type":"uuid"},{"column_name":"provider_id","data_type":"uuid"},{"column_name":"upstream_account_id","data_type":"uuid"},{"column_name":"biz_type","data_type":"character varying"},{"column_name":"biz_id","data_type":"character varying"},{"column_name":"method","data_type":"character varying"},{"column_name":"url","data_type":"text"},{"column_name":"request_headers_masked","data_type":"jsonb"},{"column_name":"request_body_masked","data_type":"jsonb"},{"column_name":"response_status","data_type":"integer"},{"column_name":"response_body_masked","data_type":"jsonb"},{"column_name":"duration_ms","data_type":"integer"},{"column_name":"error_code","data_type":"character varying"},{"column_name":"error_message","data_type":"text"},{"column_name":"created_at","data_type":"timestamp with time zone"},{"column_name":"siteId","data_type":"text"},{"column_name":"providerCode","data_type":"text"},{"column_name":"upstreamAccountId","data_type":"text"},{"column_name":"operation","data_type":"text"},{"column_name":"requestId","data_type":"text"},{"column_name":"durationMs","data_type":"integer"},{"column_name":"status","data_type":"USER-DEFINED"},{"column_name":"errorCode","data_type":"text"},{"column_name":"requestSummary","data_type":"jsonb"},{"column_name":"responseSummary","data_type":"jsonb"},{"column_name":"createdAt","data_type":"timestamp without time zone"}]},{"name":"resource_indexes","ok":true,"rows":[{"tablename":"inventory_snapshots","indexname":"inventory_snapshots_latest_cover_idx","indexdef":"CREATE INDEX inventory_snapshots_latest_cover_idx ON public.inventory_snapshots USING btree (\"siteId\", \"resourceId\", \"upstreamAccountId\", \"capturedAt\" DESC) INCLUDE (stock, \"freshnessTtlSeconds\", \"isStale\", \"providerCode\")"},{"tablename":"inventory_snapshots","indexname":"inventory_snapshots_pkey","indexdef":"CREATE UNIQUE INDEX inventory_snapshots_pkey ON public.inventory_snapshots USING btree (id)"},{"tablename":"inventory_snapshots","indexname":"inventory_snapshots_recent_cover_idx","indexdef":"CREATE INDEX inventory_snapshots_recent_cover_idx ON public.inventory_snapshots USING btree (\"siteId\", \"capturedAt\" DESC, \"resourceId\", \"upstreamAccountId\") INCLUDE (stock, \"freshnessTtlSeconds\", \"isStale\", \"providerCode\")"},{"tablename":"inventory_snapshots","indexname":"inventory_snapshots_site_resource_account_captured_idx","indexdef":"CREATE INDEX inventory_snapshots_site_resource_account_captured_idx ON public.inventory_snapshots USING btree (\"siteId\", \"resourceId\", \"upstreamAccountId\", \"capturedAt\")"},{"tablename":"inventory_snapshots","indexname":"ix_inventory_latest","indexdef":"CREATE INDEX ix_inventory_latest ON public.inventory_snapshots USING btree (site_id, tenant_id, platform_resource_id, captured_at DESC)"},{"tablename":"platform_resources","indexname":"ix_platform_resources_filter","indexdef":"CREATE INDEX ix_platform_resources_filter ON public.platform_resources USING btree (site_id, tenant_id, country_code, region, city, ip_type, sellable)"},{"tablename":"platform_resources","indexname":"ix_platform_resources_tree","indexdef":"CREATE INDEX ix_platform_resources_tree ON public.platform_resources USING btree (site_id, tenant_id, parent_id, sort_order)"},{"tablename":"platform_resources","indexname":"platform_resources_pkey","indexdef":"CREATE UNIQUE INDEX platform_resources_pkey ON public.platform_resources USING btree (id)"},{"tablename":"platform_resources","indexname":"platform_resources_saleable_catalog_idx","indexdef":"CREATE INDEX platform_resources_saleable_catalog_idx ON public.platform_resources USING btree (\"siteId\", status, \"isVisible\", \"isSaleable\", \"providerCode\", \"upstreamAccountId\")"},{"tablename":"platform_resources","indexname":"platform_resources_site_provider_account_code_iptype_key","indexdef":"CREATE UNIQUE INDEX platform_resources_site_provider_account_code_iptype_key ON public.platform_resources USING btree (\"siteId\", \"providerCode\", \"upstreamAccountId\", code, \"ipType\")"},{"tablename":"platform_resources","indexname":"platform_resources_site_provider_account_status_idx","indexdef":"CREATE INDEX platform_resources_site_provider_account_status_idx ON public.platform_resources USING btree (\"siteId\", \"providerCode\", \"upstreamAccountId\", status)"},{"tablename":"platform_resources","indexname":"ux_platform_resources_public","indexdef":"CREATE UNIQUE INDEX ux_platform_resources_public ON public.platform_resources USING btree (site_id, tenant_id, public_id)"},{"tablename":"resource_mappings","indexname":"ix_resource_mappings_platform","indexdef":"CREATE INDEX ix_resource_mappings_platform ON public.resource_mappings USING btree (site_id, tenant_id, platform_resource_id, status, priority)"},{"tablename":"resource_mappings","indexname":"ix_resource_mappings_upstream","indexdef":"CREATE INDEX ix_resource_mappings_upstream ON public.resource_mappings USING btree (upstream_resource_id, upstream_account_id)"},{"tablename":"resource_mappings","indexname":"resource_mappings_pkey","indexdef":"CREATE UNIQUE INDEX resource_mappings_pkey ON public.resource_mappings USING btree (id)"},{"tablename":"resource_mappings","indexname":"resource_mappings_site_resource_provider_account_key","indexdef":"CREATE UNIQUE INDEX resource_mappings_site_resource_provider_account_key ON public.resource_mappings USING btree (\"siteId\", \"resourceId\", \"providerCode\", \"upstreamAccountId\")"},{"tablename":"upstream_request_logs","indexname":"ix_upstream_logs_biz","indexdef":"CREATE INDEX ix_upstream_logs_biz ON public.upstream_request_logs USING btree (site_id, tenant_id, biz_type, biz_id)"},{"tablename":"upstream_request_logs","indexname":"ix_upstream_logs_time","indexdef":"CREATE INDEX ix_upstream_logs_time ON public.upstream_request_logs USING btree (site_id, tenant_id, created_at DESC)"},{"tablename":"upstream_request_logs","indexname":"upstream_request_logs_pkey","indexdef":"CREATE UNIQUE INDEX upstream_request_logs_pkey ON public.upstream_request_logs USING btree (id)"},{"tablename":"upstream_request_logs","indexname":"upstream_request_logs_site_provider_created_idx","indexdef":"CREATE INDEX upstream_request_logs_site_provider_created_idx ON public.upstream_request_logs USING btree (\"siteId\", \"providerCode\", \"createdAt\")"},{"tablename":"upstream_request_logs","indexname":"upstream_request_logs_site_provider_status_created_idx","indexdef":"CREATE INDEX upstream_request_logs_site_provider_status_created_idx ON public.upstream_request_logs USING btree (\"siteId\", \"providerCode\", status, \"createdAt\")"}]},{"name":"upstream_request_log_count","ok":true,"rows":[{"count":"62301"}]},{"name":"pricing_table_columns","ok":true,"rows":[{"table_name":"price_overrides","column_name":"id","data_type":"text","is_nullable":"NO"},{"table_name":"price_overrides","column_name":"site_id","data_type":"uuid","is_nullable":"YES"},{"table_name":"price_overrides","column_name":"tenant_id","data_type":"uuid","is_nullable":"YES"},{"table_name":"price_overrides","column_name":"user_id","data_type":"uuid","is_nullable":"YES"},{"table_name":"price_overrides","column_name":"resource_id","data_type":"uuid","is_nullable":"YES"},{"table_name":"price_overrides","column_name":"duration_days","data_type":"integer","is_nullable":"YES"},{"table_name":"price_overrides","column_name":"unit_price","data_type":"numeric","is_nullable":"YES"},{"table_name":"price_overrides","column_name":"currency","data_type":"character varying","is_nullable":"NO"},{"table_name":"price_overrides","column_name":"status","data_type":"character varying","is_nullable":"NO"},{"table_name":"price_overrides","column_name":"created_at","data_type":"timestamp with time zone","is_nullable":"YES"},{"table_name":"price_overrides","column_name":"updated_at","data_type":"timestamp with time zone","is_nullable":"YES"},{"table_name":"price_overrides","column_name":"siteId","data_type":"text","is_nullable":"YES"},{"table_name":"price_overrides","column_name":"durationDays","data_type":"integer","is_nullable":"YES"},{"table_name":"price_overrides","column_name":"resourceId","data_type":"text","is_nullable":"YES"},{"table_name":"price_overrides","column_name":"unitPrice","data_type":"numeric","is_nullable":"YES"},{"table_name":"user_resource_price_overrides","column_name":"id","data_type":"text","is_nullable":"NO"},{"table_name":"user_resource_price_overrides","column_name":"siteId","data_type":"text","is_nullable":"NO"},{"table_name":"user_resource_price_overrides","column_name":"tenantId","data_type":"text","is_nullable":"NO"},{"table_name":"user_resource_price_overrides","column_name":"userId","data_type":"text","is_nullable":"NO"},{"table_name":"user_resource_price_overrides","column_name":"resourceId","data_type":"text","is_nullable":"NO"},{"table_name":"user_resource_price_overrides","column_name":"durationDays","data_type":"integer","is_nullable":"NO"},{"table_name":"user_resource_price_overrides","column_name":"unitPrice","data_type":"numeric","is_nullable":"NO"},{"table_name":"user_resource_price_overrides","column_name":"currency","data_type":"text","is_nullable":"NO"}]},{"name":"pricing_indexes","ok":true,"rows":[{"tablename":"price_overrides","indexname":"ix_price_overrides_user_resource","indexdef":"CREATE INDEX ix_price_overrides_user_resource ON public.price_overrides USING btree (site_id, tenant_id, user_id, resource_id, duration_days, status)"},{"tablename":"price_overrides","indexname":"price_overrides_pkey","indexdef":"CREATE UNIQUE INDEX price_overrides_pkey ON public.price_overrides USING btree (id)"},{"tablename":"price_overrides","indexname":"price_overrides_siteId_resourceId_durationDays_key","indexdef":"CREATE UNIQUE INDEX \"price_overrides_siteId_resourceId_durationDays_key\" ON public.price_overrides USING btree (\"siteId\", \"resourceId\", \"durationDays\")"},{"tablename":"price_overrides","indexname":"price_overrides_site_duration_currency_resource_idx","indexdef":"CREATE INDEX price_overrides_site_duration_currency_resource_idx ON public.price_overrides USING btree (\"siteId\", \"durationDays\", currency, \"resourceId\")"},{"tablename":"user_resource_price_overrides","indexname":"user_resource_price_overrides_pkey","indexdef":"CREATE UNIQUE INDEX user_resource_price_overrides_pkey ON public.user_resource_price_overrides USING btree (id)"},{"tablename":"user_resource_price_overrides","indexname":"user_resource_price_overrides_siteId_userId_resourceId_dura_key","indexdef":"CREATE UNIQUE INDEX \"user_resource_price_overrides_siteId_userId_resourceId_dura_key\" ON public.user_resource_price_overrides USING btree (\"siteId\", \"userId\", \"resourceId\", \"durationDays\")"},{"tablename":"user_resource_price_overrides","indexname":"user_resource_price_overrides_siteId_userId_resourceId_duration","indexdef":"CREATE UNIQUE INDEX \"user_resource_price_overrides_siteId_userId_resourceId_duration\" ON public.user_resource_price_overrides USING btree (\"siteId\", \"userId\", \"resourceId\", \"durationDays\")"}]},{"name":"purchase_chain_columns","ok":true,"rows":[{"table_name":"audit_logs","column_name":"id","data_type":"text","is_nullable":"NO"},{"table_name":"audit_logs","column_name":"site_id","data_type":"uuid","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"tenant_id","data_type":"uuid","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"actor_type","data_type":"character varying","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"actor_id","data_type":"uuid","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"action","data_type":"character varying","is_nullable":"NO"},{"table_name":"audit_logs","column_name":"target_type","data_type":"character varying","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"target_id","data_type":"character varying","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"target_user_id","data_type":"uuid","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"reason","data_type":"text","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"before_json","data_type":"jsonb","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"after_json","data_type":"jsonb","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"created_at","data_type":"timestamp with time zone","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"siteId","data_type":"text","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"tenantId","data_type":"text","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"actorType","data_type":"USER-DEFINED","is_nullable":"NO"},{"table_name":"audit_logs","column_name":"actorId","data_type":"text","is_nullable":"NO"},{"table_name":"audit_logs","column_name":"targetType","data_type":"text","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"targetId","data_type":"text","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"requestId","data_type":"text","is_nullable":"NO"},{"table_name":"audit_logs","column_name":"ipAddress","data_type":"text","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"meta","data_type":"jsonb","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"createdAt","data_type":"timestamp without time zone","is_nullable":"NO"},{"table_name":"fulfillment_jobs","column_name":"id","data_type":"text","is_nullable":"NO"},{"table_name":"fulfillment_jobs","column_name":"siteId","data_type":"text","is_nullable":"NO"},{"table_name":"fulfillment_jobs","column_name":"orderId","data_type":"text","is_nullable":"NO"},{"table_name":"fulfillment_jobs","column_name":"providerCode","data_type":"text","is_nullable":"NO"},{"table_name":"fulfillment_jobs","column_name":"upstreamAccountId","data_type":"text","is_nullable":"YES"},{"table_name":"fulfillment_jobs","column_name":"status","data_type":"USER-DEFINED","is_nullable":"NO"},{"table_name":"fulfillment_jobs","column_name":"attempts","data_type":"integer","is_nullable":"NO"},{"table_name":"fulfillment_jobs","column_name":"maxAttempts","data_type":"integer","is_nullable":"NO"},{"table_name":"fulfillment_jobs","column_name":"lastError","data_type":"text","is_nullable":"YES"},{"table_name":"fulfillment_jobs","column_name":"scheduledAt","data_type":"timestamp without time zone","is_nullable":"NO"},{"table_name":"fulfillment_jobs","column_name":"startedAt","data_type":"timestamp without time zone","is_nullable":"YES"},{"table_name":"fulfillment_jobs","column_name":"completedAt","data_type":"timestamp without time zone","is_nullable":"YES"},{"table_name":"fulfillment_jobs","column_name":"createdAt","data_type":"timestamp without time zone","is_nullable":"NO"},{"table_name":"fulfillment_jobs","column_name":"updatedAt","data_type":"timestamp without time zone","is_nullable":"NO"},{"table_name":"ledger_entries","column_name":"id","data_type":"text","is_nullable":"NO"},{"table_name":"ledger_entries","column_name":"site_id","data_type":"uuid","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"tenant_id","data_type":"uuid","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"wallet_id","data_type":"uuid","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"owner_type","data_type":"USER-DEFINED","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"owner_id","data_type":"uuid","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"type","data_type":"USER-DEFINED","is_nullable":"NO"},{"table_name":"ledger_entries","column_name":"direction","data_type":"USER-DEFINED","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"amount","data_type":"numeric","is_nullable":"NO"},{"table_name":"ledger_entries","column_name":"balance_before","data_type":"numeric","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"balance_after","data_type":"numeric","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"currency","data_type":"character varying","is_nullable":"NO"},{"table_name":"ledger_entries","column_name":"biz_type","data_type":"character varying","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"biz_id","data_type":"character varying","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"idempotency_key","data_type":"character varying","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"reason","data_type":"text","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"operator_id","data_type":"uuid","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"created_at","data_type":"timestamp with time zone","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"siteId","data_type":"text","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"tenantId","data_type":"text","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"walletId","data_type":"text","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"userId","data_type":"text","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"balanceAfter","data_type":"numeric","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"relatedId","data_type":"text","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"idempotencyKey","data_type":"text","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"createdAt","data_type":"timestamp without time zone","is_nullable":"YES"},{"table_name":"ledger_entries","column_name":"meta","data_type":"jsonb","is_nullable":"YES"},{"table_name":"orders","column_name":"id","data_type":"text","is_nullable":"NO"},{"table_name":"orders","column_name":"site_id","data_type":"uuid","is_nullable":"YES"},{"table_name":"orders","column_name":"tenant_id","data_type":"uuid","is_nullable":"YES"},{"table_name":"orders","column_name":"user_id","data_type":"uuid","is_nullable":"YES"},{"table_name":"orders","column_name":"order_no","data_type":"character varying","is_nullable":"YES"},{"table_name":"orders","column_name":"client_order_no","data_type":"character varying","is_nullable":"YES"},{"table_name":"orders","column_name":"type","data_type":"USER-DEFINED","is_nullable":"NO"},{"table_name":"orders","column_name":"status","data_type":"USER-DEFINED","is_nullable":"NO"},{"table_name":"orders","column_name":"total_amount","data_type":"numeric","is_nullable":"YES"},{"table_name":"orders","column_name":"currency","data_type":"character varying","is_nullable":"NO"},{"table_name":"orders","column_name":"payment_method","data_type":"character varying","is_nullable":"YES"},{"table_name":"orders","column_name":"pricing_snapshot","data_type":"jsonb","is_nullable":"YES"},{"table_name":"orders","column_name":"request_snapshot","data_type":"jsonb","is_nullable":"YES"},{"table_name":"orders","column_name":"idempotency_key","data_type":"character varying","is_nullable":"YES"},{"table_name":"orders","column_name":"failure_reason","data_type":"text","is_nullable":"YES"},{"table_name":"orders","column_name":"created_at","data_type":"timestamp with time zone","is_nullable":"YES"},{"table_name":"orders","column_name":"updated_at","data_type":"timestamp with time zone","is_nullable":"YES"},{"table_name":"orders","column_name":"siteId","data_type":"text","is_nullable":"NO"},{"table_name":"orders","column_name":"tenantId","data_type":"text","is_nullable":"NO"},{"table_name":"orders","column_name":"userId","data_type":"text","is_nullable":"YES"},{"table_name":"orders","column_name":"idempotencyKey","data_type":"text","is_nullable":"YES"},{"table_name":"orders","column_name":"resourceId","data_type":"text","is_nullable":"YES"},{"table_name":"orders","column_name":"paymentOrderId","data_type":"text","is_nullable":"YES"},{"table_name":"orders","column_name":"durationDays","data_type":"integer","is_nullable":"NO"},{"table_name":"orders","column_name":"unitPrice","data_type":"numeric","is_nullable":"NO"},{"table_name":"orders","column_name":"totalPrice","data_type":"numeric","is_nullable":"NO"},{"table_name":"orders","column_name":"quoteSnapshot","data_type":"jsonb","is_nullable":"NO"},{"table_name":"orders","column_name":"quantity","data_type":"integer","is_nullable":"NO"},{"table_name":"orders","column_name":"failReason","data_type":"text","is_nullable":"YES"},{"table_name":"orders","column_name":"createdAt","data_type":"timestamp without time zone","is_nullable":"NO"},{"table_name":"orders","column_name":"updatedAt","data_type":"timestamp without time zone","is_nullable":"NO"}]},{"name":"purchase_chain_indexes","ok":true,"rows":[{"tablename":"audit_logs","indexname":"audit_logs_pkey","indexdef":"CREATE UNIQUE INDEX audit_logs_pkey ON public.audit_logs USING btree (id)"},{"tablename":"audit_logs","indexname":"ix_audit_logs_actor_time","indexdef":"CREATE INDEX ix_audit_logs_actor_time ON public.audit_logs USING btree (site_id, tenant_id, actor_type, actor_id, created_at DESC)"},{"tablename":"audit_logs","indexname":"ix_audit_logs_target_time","indexdef":"CREATE INDEX ix_audit_logs_target_time ON public.audit_logs USING btree (site_id, tenant_id, target_type, target_id, created_at DESC)"},{"tablename":"fulfillment_jobs","indexname":"fulfillment_jobs_order_created_idx","indexdef":"CREATE INDEX fulfillment_jobs_order_created_idx ON public.fulfillment_jobs USING btree (\"orderId\", \"createdAt\")"},{"tablename":"fulfillment_jobs","indexname":"fulfillment_jobs_pkey","indexdef":"CREATE UNIQUE INDEX fulfillment_jobs_pkey ON public.fulfillment_jobs USING btree (id)"},{"tablename":"fulfillment_jobs","indexname":"fulfillment_jobs_status_scheduled_idx","indexdef":"CREATE INDEX fulfillment_jobs_status_scheduled_idx ON public.fulfillment_jobs USING btree (status, \"scheduledAt\")"},{"tablename":"ledger_entries","indexname":"ix_ledger_biz","indexdef":"CREATE INDEX ix_ledger_biz ON public.ledger_entries USING btree (site_id, tenant_id, biz_type, biz_id)"},{"tablename":"ledger_entries","indexname":"ix_ledger_idempotency_scope","indexdef":"CREATE INDEX ix_ledger_idempotency_scope ON public.ledger_entries USING btree (site_id, tenant_id, wallet_id, idempotency_key)"},{"tablename":"ledger_entries","indexname":"ix_ledger_owner_time","indexdef":"CREATE INDEX ix_ledger_owner_time ON public.ledger_entries USING btree (site_id, tenant_id, owner_type, owner_id, created_at DESC)"},{"tablename":"ledger_entries","indexname":"ledger_entries_idempotencyKey_key","indexdef":"CREATE UNIQUE INDEX \"ledger_entries_idempotencyKey_key\" ON public.ledger_entries USING btree (\"idempotencyKey\") WHERE (\"idempotencyKey\" IS NOT NULL)"},{"tablename":"ledger_entries","indexname":"ledger_entries_pkey","indexdef":"CREATE UNIQUE INDEX ledger_entries_pkey ON public.ledger_entries USING btree (id)"},{"tablename":"ledger_entries","indexname":"ledger_entries_wallet_tenant_created_idx","indexdef":"CREATE INDEX ledger_entries_wallet_tenant_created_idx ON public.ledger_entries USING btree (\"walletId\", \"tenantId\", \"createdAt\")"},{"tablename":"ledger_entries","indexname":"ux_ledger_wallet_idempotency","indexdef":"CREATE UNIQUE INDEX ux_ledger_wallet_idempotency ON public.ledger_entries USING btree (wallet_id, idempotency_key)"},{"tablename":"orders","indexname":"ix_orders_idempotency_scope","indexdef":"CREATE INDEX ix_orders_idempotency_scope ON public.orders USING btree (site_id, tenant_id, user_id, type, idempotency_key)"},{"tablename":"orders","indexname":"ix_orders_status_time","indexdef":"CREATE INDEX ix_orders_status_time ON public.orders USING btree (site_id, tenant_id, status, created_at DESC)"},{"tablename":"orders","indexname":"ix_orders_user_time","indexdef":"CREATE INDEX ix_orders_user_time ON public.orders USING btree (site_id, tenant_id, user_id, created_at DESC)"},{"tablename":"orders","indexname":"orders_pkey","indexdef":"CREATE UNIQUE INDEX orders_pkey ON public.orders USING btree (id)"},{"tablename":"orders","indexname":"orders_siteId_tenantId_userId_idempotencyKey_key","indexdef":"CREATE UNIQUE INDEX \"orders_siteId_tenantId_userId_idempotencyKey_key\" ON public.orders USING btree (\"siteId\", \"tenantId\", \"userId\", \"idempotencyKey\")"},{"tablename":"orders","indexname":"ux_orders_order_no","indexdef":"CREATE UNIQUE INDEX ux_orders_order_no ON public.orders USING btree (site_id, order_no)"},{"tablename":"orders","indexname":"ux_orders_user_type_idempotency","indexdef":"CREATE UNIQUE INDEX ux_orders_user_type_idempotency ON public.orders USING btree (user_id, type, idempotency_key)"}]},{"name":"api_key_columns","ok":true,"rows":[{"table_name":"api_keys","column_name":"id","udt_name":"text","data_type":"text","is_nullable":"NO"},{"table_name":"api_keys","column_name":"site_id","udt_name":"uuid","data_type":"uuid","is_nullable":"NO"},{"table_name":"api_keys","column_name":"tenant_id","udt_name":"uuid","data_type":"uuid","is_nullable":"YES"},{"table_name":"api_keys","column_name":"owner_type","udt_name":"ApiKeyOwnerType","data_type":"USER-DEFINED","is_nullable":"NO"},{"table_name":"api_keys","column_name":"owner_id","udt_name":"uuid","data_type":"uuid","is_nullable":"NO"},{"table_name":"api_keys","column_name":"name","udt_name":"varchar","data_type":"character varying","is_nullable":"NO"},{"table_name":"api_keys","column_name":"key_hash","udt_name":"text","data_type":"text","is_nullable":"NO"},{"table_name":"api_keys","column_name":"key_prefix","udt_name":"varchar","data_type":"character varying","is_nullable":"NO"},{"table_name":"api_keys","column_name":"scopes","udt_name":"_text","data_type":"ARRAY","is_nullable":"NO"},{"table_name":"api_keys","column_name":"ip_whitelist","udt_name":"jsonb","data_type":"jsonb","is_nullable":"NO"},{"table_name":"api_keys","column_name":"callback_url","udt_name":"text","data_type":"text","is_nullable":"YES"},{"table_name":"api_keys","column_name":"status","udt_name":"ApiKeyStatus","data_type":"USER-DEFINED","is_nullable":"NO"},{"table_name":"api_keys","column_name":"last_used_at","udt_name":"timestamptz","data_type":"timestamp with time zone","is_nullable":"YES"},{"table_name":"api_keys","column_name":"created_at","udt_name":"timestamptz","data_type":"timestamp with time zone","is_nullable":"NO"},{"table_name":"api_keys","column_name":"rotated_at","udt_name":"timestamptz","data_type":"timestamp with time zone","is_nullable":"YES"},{"table_name":"api_keys","column_name":"expires_at","udt_name":"timestamptz","data_type":"timestamp with time zone","is_nullable":"YES"},{"table_name":"api_keys","column_name":"revoked_at","udt_name":"timestamptz","data_type":"timestamp with time zone","is_nullable":"YES"},{"table_name":"api_keys","column_name":"keyPrefix","udt_name":"text","data_type":"text","is_nullable":"YES"},{"table_name":"api_keys","column_name":"siteId","udt_name":"text","data_type":"text","is_nullable":"YES"},{"table_name":"api_keys","column_name":"tenantId","udt_name":"text","data_type":"text","is_nullable":"YES"},{"table_name":"api_keys","column_name":"ownerId","udt_name":"text","data_type":"text","is_nullable":"YES"},{"table_name":"api_keys","column_name":"ownerType","udt_name":"ApiKeyOwnerType","data_type":"USER-DEFINED","is_nullable":"YES"},{"table_name":"api_keys","column_name":"keyHash","udt_name":"text","data_type":"text","is_nullable":"YES"},{"table_name":"api_keys","column_name":"ipWhitelist","udt_name":"_text","data_type":"ARRAY","is_nullable":"YES"},{"table_name":"api_keys","column_name":"createdAt","udt_name":"timestamp","data_type":"timestamp without time zone","is_nullable":"YES"},{"table_name":"api_keys","column_name":"updatedAt","udt_name":"timestamp","data_type":"timestamp without time zone","is_nullable":"YES"},{"table_name":"api_keys","column_name":"revokedAt","udt_name":"timestamp","data_type":"timestamp without time zone","is_nullable":"YES"},{"table_name":"api_keys","column_name":"lastUsedAt","udt_name":"timestamp","data_type":"timestamp without time zone","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"id","udt_name":"text","data_type":"text","is_nullable":"NO"},{"table_name":"audit_logs","column_name":"site_id","udt_name":"uuid","data_type":"uuid","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"tenant_id","udt_name":"uuid","data_type":"uuid","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"actor_type","udt_name":"varchar","data_type":"character varying","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"actor_id","udt_name":"uuid","data_type":"uuid","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"action","udt_name":"varchar","data_type":"character varying","is_nullable":"NO"},{"table_name":"audit_logs","column_name":"target_type","udt_name":"varchar","data_type":"character varying","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"target_id","udt_name":"varchar","data_type":"character varying","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"target_user_id","udt_name":"uuid","data_type":"uuid","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"reason","udt_name":"text","data_type":"text","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"before_json","udt_name":"jsonb","data_type":"jsonb","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"after_json","udt_name":"jsonb","data_type":"jsonb","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"created_at","udt_name":"timestamptz","data_type":"timestamp with time zone","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"siteId","udt_name":"text","data_type":"text","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"tenantId","udt_name":"text","data_type":"text","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"actorType","udt_name":"AuditActorType","data_type":"USER-DEFINED","is_nullable":"NO"},{"table_name":"audit_logs","column_name":"actorId","udt_name":"text","data_type":"text","is_nullable":"NO"},{"table_name":"audit_logs","column_name":"targetType","udt_name":"text","data_type":"text","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"targetId","udt_name":"text","data_type":"text","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"requestId","udt_name":"text","data_type":"text","is_nullable":"NO"},{"table_name":"audit_logs","column_name":"ipAddress","udt_name":"text","data_type":"text","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"meta","udt_name":"jsonb","data_type":"jsonb","is_nullable":"YES"},{"table_name":"audit_logs","column_name":"createdAt","udt_name":"timestamp","data_type":"timestamp without time zone","is_nullable":"NO"}]},{"name":"api_key_indexes","ok":true,"rows":[{"tablename":"api_keys","indexname":"api_keys_pkey","indexdef":"CREATE UNIQUE INDEX api_keys_pkey ON public.api_keys USING btree (id)"},{"tablename":"api_keys","indexname":"ix_api_keys_prefix","indexdef":"CREATE INDEX ix_api_keys_prefix ON public.api_keys USING btree (key_prefix)"},{"tablename":"api_keys","indexname":"ix_api_keys_site_tenant_owner","indexdef":"CREATE INDEX ix_api_keys_site_tenant_owner ON public.api_keys USING btree (site_id, tenant_id, owner_type, owner_id)"},{"tablename":"api_keys","indexname":"ix_api_keys_status_expires_at","indexdef":"CREATE INDEX ix_api_keys_status_expires_at ON public.api_keys USING btree (status, expires_at)"},{"tablename":"api_keys","indexname":"ux_api_keys_hash","indexdef":"CREATE UNIQUE INDEX ux_api_keys_hash ON public.api_keys USING btree (key_hash)"},{"tablename":"audit_logs","indexname":"audit_logs_pkey","indexdef":"CREATE UNIQUE INDEX audit_logs_pkey ON public.audit_logs USING btree (id)"},{"tablename":"audit_logs","indexname":"ix_audit_logs_actor_time","indexdef":"CREATE INDEX ix_audit_logs_actor_time ON public.audit_logs USING btree (site_id, tenant_id, actor_type, actor_id, created_at DESC)"},{"tablename":"audit_logs","indexname":"ix_audit_logs_target_time","indexdef":"CREATE INDEX ix_audit_logs_target_time ON public.audit_logs USING btree (site_id, tenant_id, target_type, target_id, created_at DESC)"}]},{"name":"api_key_current_nulls","ok":true,"rows":[{"site_id_nulls":"0","tenant_id_nulls":"173","owner_id_nulls":"0","owner_type_nulls":"0","name_nulls":"0","key_hash_nulls":"0","key_prefix_nulls":"0","scopes_nulls":"0","ip_whitelist_nulls":"0","status_nulls":"0"}]},{"name":"price_override_duplicate_keys","ok":true,"rows":[]},{"name":"user_resource_price_override_duplicate_keys","ok":true,"rows":[]},{"name":"repair_platform_resources_account_unique","ok":true},{"name":"repair_resource_mappings_account_unique","ok":true},{"name":"repair_inventory_snapshot_lookup_idx","ok":true},{"name":"repair_upstream_logs_provider_status_idx","ok":true},{"name":"repair_upstream_logs_provider_created_idx","ok":true},{"name":"repair_pricing_current_columns","ok":true},{"name":"repair_pricing_id_types","ok":true},{"name":"repair_pricing_legacy_not_null","ok":true},{"name":"repair_pricing_unique_indexes","ok":true},{"name":"repair_reseller_sync_legacy_triggers","ok":true},{"name":"repair_order_purchase_legacy_schema","ok":true},{"name":"repair_tenant_admin_legacy_not_null","ok":true},{"name":"repair_ledger_entries_legacy_not_null","ok":true},{"name":"repair_api_keys_legacy_schema","ok":true},{"name":"repair_ledger_entries_legacy_backfill","ok":true}],"completedAt":"2026-07-02T16:32:22.630Z"}