[
    {
        "name": "User",
        "type": "record",
        "logicalType": "Aggregate",
        "fields": [
            {"name": "uuid", "type": "string", "default": "-1"},
            {"name": "username", "type": "string"},
            {"name": "phone", "type": "string"}

        ],
        "indexes": [
          "uuid",
          "phone"
        ],
        "relations": [
          { "name": "subscription", "to": "Subscription", "count": "many", "from_fields": "uuid", "to_fields": "user_uuid" }
        ]
    },
    {
        "name": "Book",
        "type": "record",
        "logicalType": "Aggregate",
        "fields": [
            {"name": "uuid", "type": "string", "default": "-1"},
            {"name": "book_name", "type": "string"},
            {"name": "author", "type": "string"}
        ],
        "indexes": ["uuid"],
        "relations": [
          { "name": "subscription", "to": "Subscription", "count": "many", "from_fields": "uuid", "to_fields": "book_uuid" }
        ]
    },
    {
    "name": "Subscription",
    "type": "record",
    "logicalType": "Aggregate",
    "fields": [
        {"name": "uuid", "type": "string", "default": "-1"},
        {"name": "user_uuid", "type": "string"},
        {"name": "book_uuid", "type": "string"}
    ],
    "indexes": [
      {"name":"pkey", "parts": ["uuid", "user_uuid"]},
      "user_uuid",
      "book_uuid",
      "uuid"
    ],
    "relations": [
      { "name": "user", "to": "User", "count": "one", "from_fields": "user_uuid", "to_fields": "uuid" },
      { "name": "book", "to": "Book", "count": "one", "from_fields": "book_uuid", "to_fields": "uuid" }
    ]
    }
]