请问如何解析ddl中的索引

[inlovingrest]

DROP TABLE IF EXISTS test_table;
CREATE TABLE test_table (
id bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键',
name varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '名称',
test varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '测试',
PRIMARY KEY (id) USING BTREE,
INDEX idx_test(name, test) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 148 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '测试表' ROW_FORMAT = Dynamic;