PostgreSQL JSON Validation Function Generator

JSON Schema

{
  "FlowState": {
    "type": "object",
    "properties": {
      "currentStep": { "type": "string", "nullable": true },
      "currentSubstep": { "type": "array", "items": { "type": "string" } }
    },
    "required": ["currentStep", "currentSubstep"],
    "description": "Highlevel state of a flow execution."
  },
  "FlowOutlineStep": {
    "type": "object",
    "properties": {
      "id": { "type": "string", "format": "uuid" },
      "name": { "type": "string" },
      "active": { "type": "boolean" },
      "completed": { "type": "boolean" },
      "display": {
        "type": "object",
        "properties": { "title": { "type": "string" }, "intro": { "type": "string" } },
        "required": ["title"]
      },
      "resumableFrom": {
        "type": "array",
        "items": { "type": "string", "pattern": "[a-zA-Z_][a-zA-Z0-9_]*" }
      }
    },
    "required": ["id", "name", "active", "completed", "display", "resumableFrom"],
    "description": "Outline information for a step."
  },
  "FlowOutline": {
    "type": "object",
    "properties": {
      "steps": {
        "type": "array",
        "items": { "$ref": "#/components/schemas/FlowOutlineStep" },
        "description": "Outline information for a step."
      }
    },
    "required": ["steps"],
    "description": "The outline of the steps within a flow."
  }
}

PostgreSQL JSON Validation Function Generator

JSON Schema

Validation Functions