tessera.kbates9611.chatgpt.site

{
  "type": "object",
  "properties": {
    "datasetId": {
      "type": "string",
      "description": "Logical dataset ID",
      "maxLength": 8000
    },
    "period": {
      "type": "string",
      "description": "Month in YYYY-MM format",
      "maxLength": 8000,
      "pattern": "^\\d{4}-(0[1-9]|1[0-2])$"
    },
    "label": {
      "type": "string",
      "description": "Human-readable month label",
      "maxLength": 8000
    },
    "sourceName": {
      "type": "string",
      "description": "Uploaded source file name",
      "maxLength": 8000
    },
    "original": {
      "type": "object",
      "description": "Raw tabular fallback retained alongside the workbook",
      "properties": {
        "columns": {
          "type": "array",
          "description": "Column names",
          "items": {
            "type": "string",
            "description": "Column name",
            "maxLength": 8000
          },
          "maxItems": 500
        },
        "rows": {
          "type": "array",
          "description": "Table rows",
          "items": {
            "type": "array",
            "items": {}
          }
        }
      },
      "required": [
        "columns",
        "rows"
      ],
      "additionalProperties": false
    },
    "workbook": {
      "type": "object",
      "properties": {
        "fileName": {
          "type": "string",
          "description": "Original workbook file name",
          "maxLength": 8000
        },
        "byteLength": {
          "type": "number",
          "description": "Original file size in bytes",
          "minimum": 0
        },
        "checksum": {
          "type": "string",
          "description": "Optional source checksum",
          "maxLength": 8000
        },
        "storageKey": {
          "type": "string",
          "description": "Immutable object-storage key for the exact uploaded file",
          "maxLength": 8000
        },
        "contentType": {
          "type": "string",
          "description": "Original file MIME type",
          "maxLength": 8000
        },
        "sheets": {
          "type": "array",
          "description": "Every parsed worksheet in source order",
          "items": {
            "type": "object",
            "properties": {
              "name": {
                "type": "string",
                "description": "Worksheet name",
                "maxLength": 8000
              },
              "rowCount": {
                "type": "number",
                "description": "Worksheet row count",
                "minimum": 0
              },
              "columnCount": {
                "type": "number",
                "description": "Worksheet column count",
                "minimum": 0
              },
              "rows": {
                "type": "array",
                "description": "Raw worksheet rows",
                "items": {
                  "type": "array",
                  "items": {}
                }
              },
              "regions": {
                "type": "array",
                "description": "Confirmed or proposed regions",
                "items": {
                  "type": "object",
                  "properties": {
                    "id": {
                      "type": "string",
                      "description": "Stable region ID",
                      "maxLength": 8000
                    },
                    "sheet": {
                      "type": "string",
                      "description": "Exact worksheet name",
                      "maxLength": 8000
                    },
                    "name": {
                      "type": "string",
                      "description": "Short label shown on the worksheet outline, such as Facility detail or Ops notes",
                      "maxLength": 8000
                    },
                    "kind": {
                      "type": "string",
                      "description": "table for rows and columns to clean; narrative for titles, commentary, or prose; footnote for footers, sources, or totals",
                      "enum": [
                        "table",
                        "narrative",
                        "footnote"
                      ]
                    },
                    "confidence": {
                      "type": "number",
                      "description": "1 for the table that feeds this dataset; lower for secondary tables and non-table regions",
                      "minimum": 0,
                      "maximum": 1
                    },
                    "canonicalName": {
                      "type": "string",
                      "description": "Dataset name for the primary table; otherwise the region name",
                      "maxLength": 8000
                    },
                    "range": {
                      "type": "object",
                      "properties": {
                        "startRow": {
                          "type": "number",
                          "description": "One-based inclusive start row",
                          "minimum": 1
                        },
                        "startColumn": {
                          "type": "number",
                          "description": "One-based inclusive start column",
                          "minimum": 1
                        },
                        "endRow": {
                          "type": "number",
                          "description": "One-based inclusive end row",
                          "minimum": 2
                        },
                        "endColumn": {
                          "type": "number",
                          "description": "One-based inclusive end column",
                          "minimum": 1
                        }
                      },
                      "required": [
                        "startRow",
                        "startColumn",
                        "endRow",
                        "endColumn"
                      ],
                      "additionalProperties": false
                    }
                  },
                  "required": [
                    "name",
                    "kind",
                    "confidence",
                    "canonicalName",
                    "range"
                  ],
                  "additionalProperties": false
                },
                "maxItems": 1000
              }
            },
            "required": [
              "name",
              "rows"
            ],
            "additionalProperties": false
          },
          "maxItems": 1000
        }
      },
      "required": [
        "fileName",
        "sheets"
      ],
      "additionalProperties": false
    }
  },
  "required": [
    "datasetId",
    "period",
    "original",
    "workbook"
  ],
  "additionalProperties": false
}