Payments docs

Creates a payment request for the current tenant and stores a pending order row for later webhook updates.

POST /payment
Content-Type: application/json
X-Tenant-ID: TENANT_ABC

{
  "packageId": 4,
  "customerName": "Test Customer",
  "customerEmail": "customer@example.com"
}

// 200 OK
{
  "data": {
    "paymentId": 32,
    "redirectUrl": "https://..."
  }
}

Receives payment status updates from the provider and updates the matching order row.

{
  "event": "payment.succeeded",
  "payment": {
    "id": 123,
    "externalId": "ORD-123",
    "tenantId": "TENANT_ABC",
    "status": "succeeded",
    "amount": 157.5,
    "currency": "ZAR"
  }
}

CREATE TABLE IF NOT EXISTS orders (
  id            INT AUTO_INCREMENT PRIMARY KEY,
  tenant_id     VARCHAR(100) NOT NULL,
  order_id      VARCHAR(255) NOT NULL,
  payment_id    INT          NULL,
  status        VARCHAR(50)  NOT NULL DEFAULT 'pending',
  amount        DECIMAL(10,2) NOT NULL DEFAULT 0.00,
  currency      CHAR(3)      NOT NULL DEFAULT 'ZAR',
  metadata      JSON         NULL,
  created_at    DATETIME     NOT NULL DEFAULT CURRENT_TIMESTAMP,
  updated_at    DATETIME     NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  UNIQUE KEY uq_order (tenant_id, order_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS orders_webhook (
  id             INT AUTO_INCREMENT PRIMARY KEY,
  tenant_id      VARCHAR(100) NULL,
  event          VARCHAR(100) NULL,
  status         VARCHAR(50) NULL,
  message        TEXT NOT NULL,
  errors         TEXT NOT NULL,
  created_at     DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;