Kafdrop: Topic: schema-changes.merchant

Topic Messages: schema-changes.merchant_service.v2

Partition: 0 Offset: 0 Key: empty Timestamp: 2026-01-14 05:34:00.789 Headers: empty

{
  "source" : {
    "server" : "mysql"
  },
  "position" : {
    "ts_sec" : 1768368840,
    "file" : "mysql-bin.000050",
    "pos" : 185989916,
    "snapshot" : "INITIAL"
  },
  "ts_ms" : 1768368840767,
  "databaseName" : "",
  "ddl" : "SET character_set_server=utf8mb4, collation_server=utf8mb4_0900_ai_ci",
  "tableChanges" : [ ]
}

Partition: 0 Offset: 1 Key: empty Timestamp: 2026-01-14 05:34:00.791 Headers: empty

{
  "source" : {
    "server" : "mysql"
  },
  "position" : {
    "ts_sec" : 1768368840,
    "file" : "mysql-bin.000050",
    "pos" : 185989916,
    "snapshot" : "INITIAL"
  },
  "ts_ms" : 1768368840767,
  "databaseName" : "merchant_service",
  "ddl" : "DROP TABLE IF EXISTS `merchant_service`.`products`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"merchant_service\".\"products\""
  } ]
}

Partition: 0 Offset: 2 Key: empty Timestamp: 2026-01-14 05:34:00.791 Headers: empty

{
  "source" : {
    "server" : "mysql"
  },
  "position" : {
    "ts_sec" : 1768368840,
    "file" : "mysql-bin.000050",
    "pos" : 185989916,
    "snapshot" : "INITIAL"
  },
  "ts_ms" : 1768368840767,
  "databaseName" : "merchant_service",
  "ddl" : "DROP TABLE IF EXISTS `merchant_service`.`merchants`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"merchant_service\".\"merchants\""
  } ]
}

Partition: 0 Offset: 3 Key: empty Timestamp: 2026-01-14 05:34:00.792 Headers: empty

{
  "source" : {
    "server" : "mysql"
  },
  "position" : {
    "ts_sec" : 1768368840,
    "file" : "mysql-bin.000050",
    "pos" : 185989916,
    "snapshot" : "INITIAL"
  },
  "ts_ms" : 1768368840768,
  "databaseName" : "merchant_service",
  "ddl" : "DROP TABLE IF EXISTS `merchant_service`.`merchant_terminals`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"merchant_service\".\"merchant_terminals\""
  } ]
}

Partition: 0 Offset: 4 Key: empty Timestamp: 2026-01-14 05:34:00.792 Headers: empty

{
  "source" : {
    "server" : "mysql"
  },
  "position" : {
    "ts_sec" : 1768368840,
    "file" : "mysql-bin.000050",
    "pos" : 185989916,
    "snapshot" : "INITIAL"
  },
  "ts_ms" : 1768368840768,
  "databaseName" : "merchant_service",
  "ddl" : "DROP TABLE IF EXISTS `merchant_service`.`product_categories`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"merchant_service\".\"product_categories\""
  } ]
}

Partition: 0 Offset: 5 Key: empty Timestamp: 2026-01-14 05:34:00.794 Headers: empty

{
  "source" : {
    "server" : "mysql"
  },
  "position" : {
    "ts_sec" : 1768368840,
    "file" : "mysql-bin.000050",
    "pos" : 185989916,
    "snapshot" : "INITIAL"
  },
  "ts_ms" : 1768368840777,
  "databaseName" : "merchant_service",
  "ddl" : "CREATE TABLE `products` (\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n  `created_at` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6),\n  `modified_at` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),\n  `merchant_terminal_id` bigint unsigned NOT NULL,\n  `account_id` bigint unsigned NOT NULL,\n  `multiple_accounts` tinyint(1) NOT NULL DEFAULT '0',\n  `name` varchar(50) DEFAULT NULL,\n  `visible` tinyint NOT NULL,\n  `display_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,\n  `product_status` tinyint unsigned NOT NULL DEFAULT '0',\n  PRIMARY KEY (`id`),\n  KEY `fk_products_merchant_terminals` (`merchant_terminal_id`),\n  CONSTRAINT `fk_products_merchant_terminals` FOREIGN KEY (`merchant_terminal_id`) REFERENCES `merchant_terminals` (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC ENCRYPTION='Y'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"merchant_service\".\"products\"",
    "table" : {
      "defaultCharsetName" : "utf8mb4",
      "primaryKeyColumnNames" : [ "id" ],
      "columns" : [ {
        "name" : "id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 1,
        "optional" : false,
        "autoIncremented" : true,
        "generated" : true,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "created_at",
        "jdbcType" : 2014,
        "typeName" : "TIMESTAMP",
        "typeExpression" : "TIMESTAMP",
        "charsetName" : null,
        "length" : 6,
        "position" : 2,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "defaultValueExpression" : "1970-01-01 00:00:00",
        "enumValues" : [ ]
      }, {
        "name" : "modified_at",
        "jdbcType" : 2014,
        "typeName" : "TIMESTAMP",
        "typeExpression" : "TIMESTAMP",
        "charsetName" : null,
        "length" : 6,
        "position" : 3,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "defaultValueExpression" : "1970-01-01 00:00:00",
        "enumValues" : [ ]
      }, {
        "name" : "merchant_terminal_id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 4,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "account_id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 5,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "multiple_accounts",
        "jdbcType" : 5,
        "typeName" : "TINYINT",
        "typeExpression" : "TINYINT",
        "charsetName" : null,
        "length" : 1,
        "position" : 6,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "defaultValueExpression" : "0",
        "enumValues" : [ ]
      }, {
        "name" : "name",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8mb4",
        "length" : 50,
        "position" : 7,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "visible",
        "jdbcType" : 5,
        "typeName" : "TINYINT",
        "typeExpression" : "TINYINT",
        "charsetName" : null,
        "position" : 8,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "display_name",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8mb4",
        "length" : 100,
        "position" : 9,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "product_status",
        "jdbcType" : 5,
        "typeName" : "TINYINT UNSIGNED",
        "typeExpression" : "TINYINT UNSIGNED",
        "charsetName" : null,
        "position" : 10,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "defaultValueExpression" : "0",
        "enumValues" : [ ]
      } ],
      "attributes" : [ ]
    },
    "comment" : null
  } ]
}

Partition: 0 Offset: 6 Key: empty Timestamp: 2026-01-14 05:34:00.795 Headers: empty

{
  "source" : {
    "server" : "mysql"
  },
  "position" : {
    "ts_sec" : 1768368840,
    "file" : "mysql-bin.000050",
    "pos" : 185989916,
    "snapshot" : "INITIAL"
  },
  "ts_ms" : 1768368840781,
  "databaseName" : "merchant_service",
  "ddl" : "CREATE TABLE `merchants` (\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n  `created_at` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6),\n  `modified_at` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),\n  `name` varchar(45) NOT NULL,\n  `merchant_status` tinyint unsigned DEFAULT NULL,\n  `product_category_id` bigint unsigned DEFAULT NULL,\n  PRIMARY KEY (`id`),\n  KEY `fk_merchants_product_categories` (`product_category_id`),\n  CONSTRAINT `fk_merchants_product_categories` FOREIGN KEY (`product_category_id`) REFERENCES `product_categories` (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC ENCRYPTION='Y'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"merchant_service\".\"merchants\"",
    "table" : {
      "defaultCharsetName" : "utf8mb4",
      "primaryKeyColumnNames" : [ "id" ],
      "columns" : [ {
        "name" : "id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 1,
        "optional" : false,
        "autoIncremented" : true,
        "generated" : true,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "created_at",
        "jdbcType" : 2014,
        "typeName" : "TIMESTAMP",
        "typeExpression" : "TIMESTAMP",
        "charsetName" : null,
        "length" : 6,
        "position" : 2,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "defaultValueExpression" : "1970-01-01 00:00:00",
        "enumValues" : [ ]
      }, {
        "name" : "modified_at",
        "jdbcType" : 2014,
        "typeName" : "TIMESTAMP",
        "typeExpression" : "TIMESTAMP",
        "charsetName" : null,
        "length" : 6,
        "position" : 3,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "defaultValueExpression" : "1970-01-01 00:00:00",
        "enumValues" : [ ]
      }, {
        "name" : "name",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8mb4",
        "length" : 45,
        "position" : 4,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "merchant_status",
        "jdbcType" : 5,
        "typeName" : "TINYINT UNSIGNED",
        "typeExpression" : "TINYINT UNSIGNED",
        "charsetName" : null,
        "position" : 5,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "product_category_id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 6,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      } ],
      "attributes" : [ ]
    },
    "comment" : null
  } ]
}

Partition: 0 Offset: 7 Key: empty Timestamp: 2026-01-14 05:34:00.799 Headers: empty

{
  "source" : {
    "server" : "mysql"
  },
  "position" : {
    "ts_sec" : 1768368840,
    "file" : "mysql-bin.000050",
    "pos" : 185989916,
    "snapshot" : "INITIAL"
  },
  "ts_ms" : 1768368840784,
  "databaseName" : "merchant_service",
  "ddl" : "CREATE TABLE `merchant_terminals` (\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n  `created_at` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6),\n  `modified_at` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),\n  `terminal_name` varchar(100) NOT NULL,\n  `account_id` bigint unsigned NOT NULL,\n  `terminal_status` tinyint unsigned NOT NULL,\n  `merchant_id` bigint unsigned NOT NULL,\n  `merchant_code` varchar(30) DEFAULT NULL,\n  PRIMARY KEY (`id`),\n  KEY `fk_merchant_terminals_merchant` (`merchant_id`),\n  CONSTRAINT `fk_merchant_terminals_merchant` FOREIGN KEY (`merchant_id`) REFERENCES `merchants` (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC ENCRYPTION='Y'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"merchant_service\".\"merchant_terminals\"",
    "table" : {
      "defaultCharsetName" : "utf8mb4",
      "primaryKeyColumnNames" : [ "id" ],
      "columns" : [ {
        "name" : "id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 1,
        "optional" : false,
        "autoIncremented" : true,
        "generated" : true,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "created_at",
        "jdbcType" : 2014,
        "typeName" : "TIMESTAMP",
        "typeExpression" : "TIMESTAMP",
        "charsetName" : null,
        "length" : 6,
        "position" : 2,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "defaultValueExpression" : "1970-01-01 00:00:00",
        "enumValues" : [ ]
      }, {
        "name" : "modified_at",
        "jdbcType" : 2014,
        "typeName" : "TIMESTAMP",
        "typeExpression" : "TIMESTAMP",
        "charsetName" : null,
        "length" : 6,
        "position" : 3,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "defaultValueExpression" : "1970-01-01 00:00:00",
        "enumValues" : [ ]
      }, {
        "name" : "terminal_name",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8mb4",
        "length" : 100,
        "position" : 4,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "account_id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 5,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "terminal_status",
        "jdbcType" : 5,
        "typeName" : "TINYINT UNSIGNED",
        "typeExpression" : "TINYINT UNSIGNED",
        "charsetName" : null,
        "position" : 6,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "merchant_id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 7,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "merchant_code",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8mb4",
        "length" : 30,
        "position" : 8,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      } ],
      "attributes" : [ ]
    },
    "comment" : null
  } ]
}

Partition: 0 Offset: 8 Key: empty Timestamp: 2026-01-14 05:34:00.801 Headers: empty

{
  "source" : {
    "server" : "mysql"
  },
  "position" : {
    "ts_sec" : 1768368840,
    "file" : "mysql-bin.000050",
    "pos" : 185989916,
    "snapshot" : "INITIAL"
  },
  "ts_ms" : 1768368840787,
  "databaseName" : "merchant_service",
  "ddl" : "CREATE TABLE `product_categories` (\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n  `created_at` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6),\n  `modified_at` timestamp(6) NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),\n  `category_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,\n  `code` varchar(20) NOT NULL,\n  `parent_id` bigint unsigned DEFAULT NULL,\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ROW_FORMAT=DYNAMIC ENCRYPTION='Y'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"merchant_service\".\"product_categories\"",
    "table" : {
      "defaultCharsetName" : "utf8mb4",
      "primaryKeyColumnNames" : [ "id" ],
      "columns" : [ {
        "name" : "id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 1,
        "optional" : false,
        "autoIncremented" : true,
        "generated" : true,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "created_at",
        "jdbcType" : 2014,
        "typeName" : "TIMESTAMP",
        "typeExpression" : "TIMESTAMP",
        "charsetName" : null,
        "length" : 6,
        "position" : 2,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "defaultValueExpression" : "1970-01-01 00:00:00",
        "enumValues" : [ ]
      }, {
        "name" : "modified_at",
        "jdbcType" : 2014,
        "typeName" : "TIMESTAMP",
        "typeExpression" : "TIMESTAMP",
        "charsetName" : null,
        "length" : 6,
        "position" : 3,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "defaultValueExpression" : "1970-01-01 00:00:00",
        "enumValues" : [ ]
      }, {
        "name" : "category_name",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8mb4",
        "length" : 50,
        "position" : 4,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "code",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8mb4",
        "length" : 20,
        "position" : 5,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "parent_id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 6,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      } ],
      "attributes" : [ ]
    },
    "comment" : null
  } ]
}