import type { StorefrontDisputeEscalationStatus } from "../core/aftercare"; import type { CommerceDb } from "./queries"; import { commerceStorefrontCaseEscalations } from "./index"; export type StorefrontCaseEscalation = typeof commerceStorefrontCaseEscalations.$inferSelect; export type StorefrontDisputeOutcomeAnalytics = { acknowledgement: { acknowledged: number; averageMinutes: number | null; open: number; promoted: number; }; evidence: { lostWithEvidence: number; lostWithoutEvidence: number; wonWithEvidence: number; wonWithoutEvidence: number; }; outcomes: { active: number; lost: number; otherTerminal: number; total: number; won: number; }; }; export declare const createStorefrontAftercareEscalationService: (options: { db: CommerceDb; enabled?: boolean; leaseMs?: number; now?: () => Date; promoteIncident: (input: { escalation: StorefrontCaseEscalation; idempotencyKey: string; }) => Promise<{ reference: string; }>; retryMs?: number; }) => { acknowledge: (input: { actor: string; escalationId: string; ownerKey: string; }) => Promise<{ acknowledged_at: Date | null; acknowledged_by: string | null; assigned_to: string | null; bucket: string; case_id: string; created_at: Date; due_at: Date; event_key: string; id: string; incident_reference: string | null; last_error: string | null; lease_expires_at: Date | null; next_promotion_at: Date | null; notification_audiences: ("admin" | "owner")[]; owner_key: string; promotion_attempts: number; promoted_at: Date | null; resolved_at: Date | null; status: StorefrontDisputeEscalationStatus; updated_at: Date; worker_id: string | null; }>; analytics: (ownerKey?: string) => Promise; assign: (input: { assignedTo: string | null; escalationId: string; ownerKey: string; }) => Promise<{ acknowledged_at: Date | null; acknowledged_by: string | null; assigned_to: string | null; bucket: string; case_id: string; created_at: Date; due_at: Date; event_key: string; id: string; incident_reference: string | null; last_error: string | null; lease_expires_at: Date | null; next_promotion_at: Date | null; notification_audiences: ("admin" | "owner")[]; owner_key: string; promotion_attempts: number; promoted_at: Date | null; resolved_at: Date | null; status: StorefrontDisputeEscalationStatus; updated_at: Date; worker_id: string | null; }>; get: (ownerKey: string, escalationId: string) => Promise<{ acknowledged_at: Date | null; acknowledged_by: string | null; assigned_to: string | null; bucket: string; case_id: string; created_at: Date; due_at: Date; event_key: string; id: string; incident_reference: string | null; last_error: string | null; lease_expires_at: Date | null; next_promotion_at: Date | null; notification_audiences: ("admin" | "owner")[]; owner_key: string; promotion_attempts: number; promoted_at: Date | null; resolved_at: Date | null; status: StorefrontDisputeEscalationStatus; updated_at: Date; worker_id: string | null; }>; listFleet: () => Omit; acknowledged_by: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgVarcharBuilder<[string, ...string[]]>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; assigned_to: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgVarcharBuilder<[string, ...string[]]>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; bucket: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetNotNull>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; case_id: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetNotNull, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string uuid"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; created_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetHasDefault>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; due_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetNotNull, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; event_key: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetNotNull>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; id: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetIsPrimaryKey>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string uuid"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; incident_reference: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgVarcharBuilder<[string, ...string[]]>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; last_error: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTextBuilder<[string, ...string[]]>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; lease_expires_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTimestampBuilder, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; next_promotion_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTimestampBuilder, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; notification_audiences: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetHasDefault, ("admin" | "owner")[]>>>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "custom"; data: ("admin" | "owner")[]; driverParam: unknown; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; owner_key: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetNotNull>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; promotion_attempts: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetHasDefault>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "number int32"; data: number; driverParam: string | number; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; promoted_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTimestampBuilder, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; resolved_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTimestampBuilder, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; status: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetHasDefault, StorefrontDisputeEscalationStatus>>>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: StorefrontDisputeEscalationStatus; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; updated_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetHasDefault>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; worker_id: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgVarcharBuilder<[string, ...string[]]>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; }, "single", Record<"commerce_storefront_case_escalations", "not-null">, false, "orderBy", { acknowledged_at: Date | null; acknowledged_by: string | null; assigned_to: string | null; bucket: string; case_id: string; created_at: Date; due_at: Date; event_key: string; id: string; incident_reference: string | null; last_error: string | null; lease_expires_at: Date | null; next_promotion_at: Date | null; notification_audiences: ("admin" | "owner")[]; owner_key: string; promotion_attempts: number; promoted_at: Date | null; resolved_at: Date | null; status: StorefrontDisputeEscalationStatus; updated_at: Date; worker_id: string | null; }[], { acknowledged_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTimestampBuilder, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; acknowledged_by: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgVarcharBuilder<[string, ...string[]]>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; assigned_to: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgVarcharBuilder<[string, ...string[]]>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; bucket: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetNotNull>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; case_id: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetNotNull, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string uuid"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; created_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetHasDefault>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; due_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetNotNull, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; event_key: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetNotNull>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; id: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetIsPrimaryKey>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string uuid"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; incident_reference: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgVarcharBuilder<[string, ...string[]]>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; last_error: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTextBuilder<[string, ...string[]]>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; lease_expires_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTimestampBuilder, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; next_promotion_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTimestampBuilder, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; notification_audiences: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetHasDefault, ("admin" | "owner")[]>>>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "custom"; data: ("admin" | "owner")[]; driverParam: unknown; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; owner_key: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetNotNull>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; promotion_attempts: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetHasDefault>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "number int32"; data: number; driverParam: string | number; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; promoted_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTimestampBuilder, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; resolved_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTimestampBuilder, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; status: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetHasDefault, StorefrontDisputeEscalationStatus>>>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: StorefrontDisputeEscalationStatus; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; updated_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetHasDefault>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; worker_id: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgVarcharBuilder<[string, ...string[]]>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; }>, "orderBy">; listOwner: (ownerKey: string) => Omit; acknowledged_by: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgVarcharBuilder<[string, ...string[]]>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; assigned_to: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgVarcharBuilder<[string, ...string[]]>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; bucket: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetNotNull>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; case_id: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetNotNull, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string uuid"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; created_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetHasDefault>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; due_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetNotNull, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; event_key: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetNotNull>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; id: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetIsPrimaryKey>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string uuid"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; incident_reference: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgVarcharBuilder<[string, ...string[]]>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; last_error: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTextBuilder<[string, ...string[]]>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; lease_expires_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTimestampBuilder, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; next_promotion_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTimestampBuilder, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; notification_audiences: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetHasDefault, ("admin" | "owner")[]>>>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "custom"; data: ("admin" | "owner")[]; driverParam: unknown; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; owner_key: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetNotNull>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; promotion_attempts: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetHasDefault>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "number int32"; data: number; driverParam: string | number; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; promoted_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTimestampBuilder, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; resolved_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTimestampBuilder, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; status: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetHasDefault, StorefrontDisputeEscalationStatus>>>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: StorefrontDisputeEscalationStatus; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; updated_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetHasDefault>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; worker_id: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgVarcharBuilder<[string, ...string[]]>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; }, "single", Record<"commerce_storefront_case_escalations", "not-null">, false, "orderBy" | "where", { acknowledged_at: Date | null; acknowledged_by: string | null; assigned_to: string | null; bucket: string; case_id: string; created_at: Date; due_at: Date; event_key: string; id: string; incident_reference: string | null; last_error: string | null; lease_expires_at: Date | null; next_promotion_at: Date | null; notification_audiences: ("admin" | "owner")[]; owner_key: string; promotion_attempts: number; promoted_at: Date | null; resolved_at: Date | null; status: StorefrontDisputeEscalationStatus; updated_at: Date; worker_id: string | null; }[], { acknowledged_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTimestampBuilder, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; acknowledged_by: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgVarcharBuilder<[string, ...string[]]>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; assigned_to: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgVarcharBuilder<[string, ...string[]]>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; bucket: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetNotNull>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; case_id: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetNotNull, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string uuid"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; created_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetHasDefault>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; due_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetNotNull, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; event_key: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetNotNull>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; id: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetIsPrimaryKey>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string uuid"; data: string; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; incident_reference: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgVarcharBuilder<[string, ...string[]]>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; last_error: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTextBuilder<[string, ...string[]]>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; lease_expires_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTimestampBuilder, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; next_promotion_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTimestampBuilder, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; notification_audiences: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetHasDefault, ("admin" | "owner")[]>>>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "custom"; data: ("admin" | "owner")[]; driverParam: unknown; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; owner_key: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetNotNull>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: true; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; promotion_attempts: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetHasDefault>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "number int32"; data: number; driverParam: string | number; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; promoted_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTimestampBuilder, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; resolved_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgTimestampBuilder, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; status: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetHasDefault, StorefrontDisputeEscalationStatus>>>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: StorefrontDisputeEscalationStatus; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; updated_at: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").SetHasDefault>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "object date"; data: Date; driverParam: string; notNull: true; hasDefault: true; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; worker_id: import("drizzle-orm/pg-core").PgBuildColumn<"commerce_storefront_case_escalations", import("drizzle-orm/pg-core").PgVarcharBuilder<[string, ...string[]]>, { name: string; tableName: "commerce_storefront_case_escalations"; dataType: "string"; data: string; driverParam: string; notNull: false; hasDefault: false; isPrimaryKey: false; isAutoincrement: false; hasRuntimeDefault: false; enumValues: undefined; identity: undefined; generated: undefined; }>; }>, "orderBy" | "where">; runPromotionCycle: (workerId: string, limit?: number, ownerKey?: string) => Promise<{ escalationId: string; status: "promoted" | "retry"; }[]>; };