{
  "tables": [
    {
      "name": "customers",
      "columns": ["id", "name"],
      "foreign_keys": []
    },
    {
      "name": "orders",
      "columns": ["id", "customer_id", "amount"],
      "foreign_keys": [
        {
          "column": "customer_id",
          "references": {
            "table": "customers",
            "column": "id"
          }
        }
      ]
    }
  ]
}