Data Models

Declare entities and how they relate. Generated data respects these relationships — unrelated random rows do not exercise joins or indexes, so they measure the wrong system.

{
  "entities": [
    {
      "name": "customer",
      "count": 1000,
      "fields": [
        {
          "name": "name",
          "generator": "name"
        }
      ]
    },
    {
      "name": "order",
      "count": 5000,
      "fields": [
        {
          "name": "status",
          "distribution": {
            "Delivered": 60,
            "Shipped": 15,
            "Processing": 10,
            "Cancelled": 10,
            "Pending": 5
          }
        }
      ]
    },
    {
      "name": "order_item",
      "count": 15000,
      "fields": [
        {
          "name": "qty",
          "type": "integer",
          "minimum": 1,
          "maximum": 5
        }
      ]
    }
  ],
  "relationships": [
    {
      "name": "customer_orders",
      "parent": "customer",
      "child": "order",
      "cardinality": "1:N",
      "min_children": 1,
      "max_children": 8
    },
    {
      "name": "order_items",
      "parent": "order",
      "child": "order_item",
      "cardinality": "1:N",
      "min_children": 1,
      "max_children": 4
    }
  ]
}