Schema of flattened data

hyper-schema.json

{
  "type": "object",
  "properties" : {
    "id" : {
      "type" : "string",
      "$comment" : "Used to identify the record, it is usually the ID assigned by the source system"
    },
    "contentType" : {
      "type" : "string",
      "$comment" : "Name of data type represented. Used to determine the name of table in UPSERTs commands"
    },
    "source" : {
      "type" : "string",
      "enum" : [ "jira", "rally", "snow" ],
      "$comment" : "Source system name. Used to store the detailed fields of each record"
    },
    "fields" : {
      "type" : "array",
      "items" : {
        "type": "object",
        "properties" : {
          "name" : { "type": "string" },
          "dataType" : { "type" : "string", "enum" : ["number", "date", "timestamp", "boolean", "list"] },
          "format" : { "type": "string" },
          "value" : { "type": "string" },
          "listValues" : { "type": "array" },
          "$comment" : "Detail of each field. 'string' is the dataType assumed by default. The format is required only for dates and numbers. The 'listValues' is required only for 'list'"
        },
        "required": ["name", "value"]
      }
    }
  }
}