schema.json

[
  {
    "database": "load_planner",
    "index": "saas-base",
    "nodes": {
      "table": "saas_api_user",
      "schema": "public",
      "columns": [],
      "transform": {
        "rename": {
          "id": "user.id",
          "email": "user.email",
          "first_name": "user.first_name",
          "last_name": "user.last_name",
          "lang": "user.lang",
          "balance": "user.balance"
        }
      },
      "children": [
        {
          "table": "saas_api_role",
          "schema": "public",
          "columns": [
            "id", "name", "title"
          ],
          "relationship": {
            "type": "one_to_many",
            "variant": "object",
            "through_tables": [
              "saas_api_user_roles"
            ]
          },
          "children": [
            {
              "table": "saas_api_district",
              "label": "district",
              "schema": "public",
              "columns": [
                "id", "name"
              ],
              "relationship": {
                "variant": "object",
                "type": "one_to_many"
              },
              "children": [
                {
                  "table": "saas_api_tenant",
                  "label": "tenant",
                  "schema": "public",
                  "relationship": {
                    "variant": "object",
                    "type": "one_to_many"
                  },
                  "columns": [
                    "id", "name", "product_name", "schema_name", "subdomain", "organization",
                    "tier", "created"
                  ]
                }
              ]
            }
          ]
        }
      ]
    }
  }
]