Topic Messages: schema-changes.transactor_service.v2

Partition: 0   Offset: 0   Key: empty   Timestamp: 2026-01-14 05:34:01.422 Headers: empty
  
{
  "source" : {
    "server" : "mysql"
  },
  "position" : {
    "ts_sec" : 1768368841,
    "file" : "mysql-bin.000050",
    "pos" : 185989916,
    "snapshot" : "INITIAL"
  },
  "ts_ms" : 1768368841385,
  "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:01.424 Headers: empty
  
{
  "source" : {
    "server" : "mysql"
  },
  "position" : {
    "ts_sec" : 1768368841,
    "file" : "mysql-bin.000050",
    "pos" : 185989916,
    "snapshot" : "INITIAL"
  },
  "ts_ms" : 1768368841385,
  "databaseName" : "transactor_service",
  "ddl" : "DROP TABLE IF EXISTS `transactor_service`.`accounts`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"transactor_service\".\"accounts\""
  } ]
}
Partition: 0   Offset: 2   Key: empty   Timestamp: 2026-01-14 05:34:01.425 Headers: empty
  
{
  "source" : {
    "server" : "mysql"
  },
  "position" : {
    "ts_sec" : 1768368841,
    "file" : "mysql-bin.000050",
    "pos" : 185989916,
    "snapshot" : "INITIAL"
  },
  "ts_ms" : 1768368841386,
  "databaseName" : "transactor_service",
  "ddl" : "DROP TABLE IF EXISTS `transactor_service`.`transactions`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"transactor_service\".\"transactions\""
  } ]
}
Partition: 0   Offset: 3   Key: empty   Timestamp: 2026-01-14 05:34:01.425 Headers: empty
  
{
  "source" : {
    "server" : "mysql"
  },
  "position" : {
    "ts_sec" : 1768368841,
    "file" : "mysql-bin.000050",
    "pos" : 185989916,
    "snapshot" : "INITIAL"
  },
  "ts_ms" : 1768368841386,
  "databaseName" : "transactor_service",
  "ddl" : "DROP TABLE IF EXISTS `transactor_service`.`transaction_journals`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"transactor_service\".\"transaction_journals\""
  } ]
}
Partition: 0   Offset: 4   Key: empty   Timestamp: 2026-01-14 05:34:01.426 Headers: empty
  
{
  "source" : {
    "server" : "mysql"
  },
  "position" : {
    "ts_sec" : 1768368841,
    "file" : "mysql-bin.000050",
    "pos" : 185989916,
    "snapshot" : "INITIAL"
  },
  "ts_ms" : 1768368841386,
  "databaseName" : "transactor_service",
  "ddl" : "DROP TABLE IF EXISTS `transactor_service`.`transaction_attributes`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"transactor_service\".\"transaction_attributes\""
  } ]
}
Partition: 0   Offset: 5   Key: empty   Timestamp: 2026-01-14 05:34:01.429 Headers: empty
  
{
  "source" : {
    "server" : "mysql"
  },
  "position" : {
    "ts_sec" : 1768368841,
    "file" : "mysql-bin.000050",
    "pos" : 185989916,
    "snapshot" : "INITIAL"
  },
  "ts_ms" : 1768368841404,
  "databaseName" : "transactor_service",
  "ddl" : "CREATE TABLE `accounts` (\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),\n  `modified_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),\n  `balance` decimal(19,4) DEFAULT NULL,\n  `lien_balance` decimal(19,4) DEFAULT NULL,\n  `account_status` tinyint DEFAULT NULL,\n  `internal_account` bit(1) NOT NULL DEFAULT b'0',\n  PRIMARY KEY (`id`),\n  CONSTRAINT `chk_accounts_status` CHECK ((`account_status` between 0 and 2))\n) ENGINE=InnoDB AUTO_INCREMENT=2927 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ENCRYPTION='Y'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"transactor_service\".\"accounts\"",
    "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" : false,
        "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" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "defaultValueExpression" : "1970-01-01 00:00:00",
        "enumValues" : [ ]
      }, {
        "name" : "balance",
        "jdbcType" : 3,
        "typeName" : "DECIMAL",
        "typeExpression" : "DECIMAL",
        "charsetName" : null,
        "length" : 19,
        "scale" : 4,
        "position" : 4,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "lien_balance",
        "jdbcType" : 3,
        "typeName" : "DECIMAL",
        "typeExpression" : "DECIMAL",
        "charsetName" : null,
        "length" : 19,
        "scale" : 4,
        "position" : 5,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "account_status",
        "jdbcType" : 5,
        "typeName" : "TINYINT",
        "typeExpression" : "TINYINT",
        "charsetName" : null,
        "position" : 6,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "internal_account",
        "jdbcType" : -7,
        "typeName" : "BIT",
        "typeExpression" : "BIT",
        "charsetName" : null,
        "length" : 1,
        "position" : 7,
        "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:01.431 Headers: empty
  
{
  "source" : {
    "server" : "mysql"
  },
  "position" : {
    "ts_sec" : 1768368841,
    "file" : "mysql-bin.000050",
    "pos" : 185989916,
    "snapshot" : "INITIAL"
  },
  "ts_ms" : 1768368841410,
  "databaseName" : "transactor_service",
  "ddl" : "CREATE TABLE `transactions` (\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),\n  `modified_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),\n  `amount` decimal(19,4) DEFAULT NULL,\n  `category_id` varchar(255) DEFAULT NULL,\n  `commission` decimal(19,4) DEFAULT NULL,\n  `completed_date` timestamp(6) NULL DEFAULT NULL,\n  `module_id` bigint unsigned NOT NULL,\n  `parent_id` bigint unsigned DEFAULT NULL,\n  `payer_account_id` bigint unsigned NOT NULL,\n  `payer_cas_id` bigint unsigned NOT NULL,\n  `product_id` bigint unsigned DEFAULT NULL,\n  `receiver_account_id` bigint unsigned NOT NULL,\n  `receiver_cas_id` bigint unsigned NOT NULL,\n  `reference_id` varchar(50) DEFAULT NULL,\n  `session_id` bigint unsigned DEFAULT NULL,\n  `transaction_status` tinyint unsigned DEFAULT NULL,\n  `narration_id` bigint unsigned NOT NULL,\n  `narration_description` varchar(255) DEFAULT NULL,\n  PRIMARY KEY (`id`),\n  KEY `fk_transactions_narrations` (`narration_id`),\n  CONSTRAINT `fk_transactions_narrations` FOREIGN KEY (`narration_id`) REFERENCES `narrations` (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=135425 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ENCRYPTION='Y'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"transactor_service\".\"transactions\"",
    "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" : false,
        "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" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "defaultValueExpression" : "1970-01-01 00:00:00",
        "enumValues" : [ ]
      }, {
        "name" : "amount",
        "jdbcType" : 3,
        "typeName" : "DECIMAL",
        "typeExpression" : "DECIMAL",
        "charsetName" : null,
        "length" : 19,
        "scale" : 4,
        "position" : 4,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "category_id",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8mb4",
        "length" : 255,
        "position" : 5,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "commission",
        "jdbcType" : 3,
        "typeName" : "DECIMAL",
        "typeExpression" : "DECIMAL",
        "charsetName" : null,
        "length" : 19,
        "scale" : 4,
        "position" : 6,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "completed_date",
        "jdbcType" : 2014,
        "typeName" : "TIMESTAMP",
        "typeExpression" : "TIMESTAMP",
        "charsetName" : null,
        "length" : 6,
        "position" : 7,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "module_id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 8,
        "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" : 9,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "payer_account_id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 10,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "payer_cas_id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 11,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "product_id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 12,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "receiver_account_id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 13,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "receiver_cas_id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 14,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "reference_id",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8mb4",
        "length" : 50,
        "position" : 15,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "session_id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 16,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "transaction_status",
        "jdbcType" : 5,
        "typeName" : "TINYINT UNSIGNED",
        "typeExpression" : "TINYINT UNSIGNED",
        "charsetName" : null,
        "position" : 17,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "narration_id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 18,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "narration_description",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8mb4",
        "length" : 255,
        "position" : 19,
        "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:01.437 Headers: empty
  
{
  "source" : {
    "server" : "mysql"
  },
  "position" : {
    "ts_sec" : 1768368841,
    "file" : "mysql-bin.000050",
    "pos" : 185989916,
    "snapshot" : "INITIAL"
  },
  "ts_ms" : 1768368841417,
  "databaseName" : "transactor_service",
  "ddl" : "CREATE TABLE `transaction_journals` (\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),\n  `modified_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),\n  `amount` decimal(19,4) DEFAULT NULL,\n  `balance` decimal(19,4) DEFAULT NULL,\n  `debit` bit(1) NOT NULL,\n  `transaction_type` tinyint(1) DEFAULT NULL,\n  `account_id` bigint unsigned NOT NULL,\n  `narration_id` bigint unsigned NOT NULL,\n  `transaction_id` bigint unsigned NOT NULL,\n  `narration_description` varchar(100) DEFAULT NULL,\n  PRIMARY KEY (`id`),\n  KEY `fk_transaction_journals_accounts` (`account_id`),\n  KEY `fk_transaction_journals_narrations` (`narration_id`),\n  KEY `fk_transaction_journals_transactions` (`transaction_id`),\n  CONSTRAINT `fk_transaction_journals_accounts` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`),\n  CONSTRAINT `fk_transaction_journals_narrations` FOREIGN KEY (`narration_id`) REFERENCES `narrations` (`id`),\n  CONSTRAINT `fk_transaction_journals_transactions` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=250879 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ENCRYPTION='Y'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"transactor_service\".\"transaction_journals\"",
    "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" : false,
        "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" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "defaultValueExpression" : "1970-01-01 00:00:00",
        "enumValues" : [ ]
      }, {
        "name" : "amount",
        "jdbcType" : 3,
        "typeName" : "DECIMAL",
        "typeExpression" : "DECIMAL",
        "charsetName" : null,
        "length" : 19,
        "scale" : 4,
        "position" : 4,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "balance",
        "jdbcType" : 3,
        "typeName" : "DECIMAL",
        "typeExpression" : "DECIMAL",
        "charsetName" : null,
        "length" : 19,
        "scale" : 4,
        "position" : 5,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "debit",
        "jdbcType" : -7,
        "typeName" : "BIT",
        "typeExpression" : "BIT",
        "charsetName" : null,
        "length" : 1,
        "position" : 6,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "transaction_type",
        "jdbcType" : 5,
        "typeName" : "TINYINT",
        "typeExpression" : "TINYINT",
        "charsetName" : null,
        "length" : 1,
        "position" : 7,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "account_id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 8,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "narration_id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 9,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "transaction_id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 10,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "narration_description",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8mb4",
        "length" : 100,
        "position" : 11,
        "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:01.439 Headers: empty
  
{
  "source" : {
    "server" : "mysql"
  },
  "position" : {
    "ts_sec" : 1768368841,
    "file" : "mysql-bin.000050",
    "pos" : 185989916,
    "snapshot" : "INITIAL"
  },
  "ts_ms" : 1768368841420,
  "databaseName" : "transactor_service",
  "ddl" : "CREATE TABLE `transaction_attributes` (\n  `id` bigint unsigned NOT NULL AUTO_INCREMENT,\n  `created_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6),\n  `modified_at` timestamp(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6) ON UPDATE CURRENT_TIMESTAMP(6),\n  `attribute_key` varchar(255) DEFAULT NULL,\n  `attribute_value` varchar(255) DEFAULT NULL,\n  `transaction_id` bigint unsigned NOT NULL,\n  `is_primary` bit(1) NOT NULL,\n  `is_visible` bit(1) NOT NULL,\n  PRIMARY KEY (`id`),\n  KEY `fk_transactions_transaction_attributes` (`transaction_id`),\n  CONSTRAINT `fk_transactions_transaction_attributes` FOREIGN KEY (`transaction_id`) REFERENCES `transactions` (`id`)\n) ENGINE=InnoDB AUTO_INCREMENT=126194 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci ENCRYPTION='Y'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"transactor_service\".\"transaction_attributes\"",
    "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" : false,
        "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" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "defaultValueExpression" : "1970-01-01 00:00:00",
        "enumValues" : [ ]
      }, {
        "name" : "attribute_key",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8mb4",
        "length" : 255,
        "position" : 4,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "attribute_value",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8mb4",
        "length" : 255,
        "position" : 5,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "transaction_id",
        "jdbcType" : -5,
        "typeName" : "BIGINT UNSIGNED",
        "typeExpression" : "BIGINT UNSIGNED",
        "charsetName" : null,
        "position" : 6,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "is_primary",
        "jdbcType" : -7,
        "typeName" : "BIT",
        "typeExpression" : "BIT",
        "charsetName" : null,
        "length" : 1,
        "position" : 7,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "is_visible",
        "jdbcType" : -7,
        "typeName" : "BIT",
        "typeExpression" : "BIT",
        "charsetName" : null,
        "length" : 1,
        "position" : 8,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      } ],
      "attributes" : [ ]
    },
    "comment" : null
  } ]
}