.table(iName).colInt("id").colInt("tid").colInt("z").pk("id").joinTo(SCHEMA, TABLE, "fk2").on("tid", "id")
.groupIndex("x_y", Index.JoinType.LEFT).on(TABLE, "y").and("p", "x") // spans 2
.groupIndex("x_y_z", Index.JoinType.LEFT).on("i", "z").and(TABLE, "y").and("p", "x"); // spans 3
Table t1 = builder.unvalidatedAIS().getTable(TABLE_NAME);
builder = AISBBasedBuilder.create(SCHEMA, typesTranslator);
builder.table("p").colInt("id").colInt("x").pk("id")
.table(TABLE).colInt("id").colInt("pid").colInt("y").pk("id").key("fk1", "pid")
.table(iName).colInt("id").colInt("tid").colInt("z").pk("id").joinTo(SCHEMA, TABLE, "fk2").on("tid", "id");
Table t2 = builder.unvalidatedAIS().getTable(TABLE_NAME);
validate(
t1, t2,