Kafdrop: Topic: schema-changes.odm

Topic Messages: schema-changes.odm_scoring

First Offset: 0 Last Offset: 14 Size: 14

Offset: 0 Key: empty Timestamp: 2024-12-03 11:00:02.435 Headers: empty

{
  "source" : {
    "server" : "odm_scoring"
  },
  "position" : {
    "ts_sec" : 1733223594,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223594655,
  "databaseName" : "",
  "ddl" : "SET character_set_server=utf8mb4, collation_server=utf8mb4_0900_ai_ci",
  "tableChanges" : [ ]
}

Offset: 1 Key: empty Timestamp: 2024-12-03 11:00:02.444 Headers: empty

{
  "source" : {
    "server" : "odm_scoring"
  },
  "position" : {
    "ts_sec" : 1733223595,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223595070,
  "databaseName" : "odm-scoring",
  "ddl" : "DROP TABLE IF EXISTS `odm-scoring`.`scoring_scoring_audit_trail`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"odm-scoring\".\"scoring_scoring_audit_trail\""
  } ]
}

Offset: 2 Key: empty Timestamp: 2024-12-03 11:00:02.449 Headers: empty

{
  "source" : {
    "server" : "odm_scoring"
  },
  "position" : {
    "ts_sec" : 1733223595,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223595070,
  "databaseName" : "odm-scoring",
  "ddl" : "DROP TABLE IF EXISTS `odm-scoring`.`scoring_scoring_level`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"odm-scoring\".\"scoring_scoring_level\""
  } ]
}

Offset: 3 Key: empty Timestamp: 2024-12-03 11:00:02.452 Headers: empty

{
  "source" : {
    "server" : "odm_scoring"
  },
  "position" : {
    "ts_sec" : 1733223595,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223595070,
  "databaseName" : "odm-scoring",
  "ddl" : "DROP TABLE IF EXISTS `odm-scoring`.`scoring_scoring_request`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"odm-scoring\".\"scoring_scoring_request\""
  } ]
}

Offset: 4 Key: empty Timestamp: 2024-12-03 11:00:02.454 Headers: empty

{
  "source" : {
    "server" : "odm_scoring"
  },
  "position" : {
    "ts_sec" : 1733223595,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223595071,
  "databaseName" : "odm-scoring",
  "ddl" : "DROP TABLE IF EXISTS `odm-scoring`.`scoring_scoring_request_params`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"odm-scoring\".\"scoring_scoring_request_params\""
  } ]
}

Offset: 5 Key: empty Timestamp: 2024-12-03 11:00:02.456 Headers: empty

{
  "source" : {
    "server" : "odm_scoring"
  },
  "position" : {
    "ts_sec" : 1733223595,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223595071,
  "databaseName" : "odm-scoring",
  "ddl" : "DROP TABLE IF EXISTS `odm-scoring`.`scoring_scoring_response`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"odm-scoring\".\"scoring_scoring_response\""
  } ]
}

Offset: 6 Key: empty Timestamp: 2024-12-03 11:00:02.459 Headers: empty

{
  "source" : {
    "server" : "odm_scoring"
  },
  "position" : {
    "ts_sec" : 1733223601,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223601510,
  "databaseName" : "odm-scoring",
  "ddl" : "DROP DATABASE IF EXISTS `odm-scoring`",
  "tableChanges" : [ ]
}

Offset: 7 Key: empty Timestamp: 2024-12-03 11:00:02.464 Headers: empty

{
  "source" : {
    "server" : "odm_scoring"
  },
  "position" : {
    "ts_sec" : 1733223601,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223601510,
  "databaseName" : "odm-scoring",
  "ddl" : "CREATE DATABASE `odm-scoring` CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci",
  "tableChanges" : [ ]
}

Offset: 8 Key: empty Timestamp: 2024-12-03 11:00:02.468 Headers: empty

{
  "source" : {
    "server" : "odm_scoring"
  },
  "position" : {
    "ts_sec" : 1733223601,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223601510,
  "databaseName" : "odm-scoring",
  "ddl" : "USE `odm-scoring`",
  "tableChanges" : [ ]
}

Offset: 9 Key: empty Timestamp: 2024-12-03 11:00:02.472 Headers: empty

{
  "source" : {
    "server" : "odm_scoring"
  },
  "position" : {
    "ts_sec" : 1733223601,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223601518,
  "databaseName" : "odm-scoring",
  "ddl" : "CREATE TABLE `scoring_scoring_audit_trail` (\n  `id` varchar(50) NOT NULL,\n  `_business_data` json DEFAULT NULL,\n  `internal_response` longtext,\n  `internal_scoring_data` longtext,\n  `_daaq` varchar(255) DEFAULT NULL,\n  `_when_created` datetime DEFAULT NULL,\n  `_when_modified` datetime DEFAULT NULL,\n  `_who_created` varchar(255) DEFAULT NULL,\n  `_who_modified` varchar(255) DEFAULT NULL,\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"odm-scoring\".\"scoring_scoring_audit_trail\"",
    "table" : {
      "defaultCharsetName" : "utf8",
      "primaryKeyColumnNames" : [ "id" ],
      "columns" : [ {
        "name" : "id",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 1,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "_business_data",
        "jdbcType" : 1111,
        "typeName" : "JSON",
        "typeExpression" : "JSON",
        "charsetName" : null,
        "position" : 2,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "internal_response",
        "jdbcType" : 12,
        "typeName" : "LONGTEXT",
        "typeExpression" : "LONGTEXT",
        "charsetName" : "utf8",
        "position" : 3,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "internal_scoring_data",
        "jdbcType" : 12,
        "typeName" : "LONGTEXT",
        "typeExpression" : "LONGTEXT",
        "charsetName" : "utf8",
        "position" : 4,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_daaq",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 5,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_created",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 6,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_modified",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 7,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_who_created",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 8,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_who_modified",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 9,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      } ],
      "attributes" : [ ]
    },
    "comment" : null
  } ]
}

Offset: 10 Key: empty Timestamp: 2024-12-03 11:00:02.475 Headers: empty

{
  "source" : {
    "server" : "odm_scoring"
  },
  "position" : {
    "ts_sec" : 1733223601,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223601531,
  "databaseName" : "odm-scoring",
  "ddl" : "CREATE TABLE `scoring_scoring_level` (\n  `id` varchar(50) NOT NULL,\n  `default_value` tinyint(1) DEFAULT NULL,\n  `label` varchar(255) DEFAULT NULL,\n  `internal_code` varchar(50) DEFAULT NULL,\n  `_business_data` json DEFAULT NULL,\n  `_daaq` varchar(255) DEFAULT NULL,\n  `_when_created` datetime DEFAULT NULL,\n  `_when_modified` datetime DEFAULT NULL,\n  `_who_created` varchar(255) DEFAULT NULL,\n  `_who_modified` varchar(255) DEFAULT NULL,\n  PRIMARY KEY (`id`),\n  KEY `SCORING_SCORING_LEVEL_INTERNAL_CODE_IX` (`internal_code`,`default_value`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"odm-scoring\".\"scoring_scoring_level\"",
    "table" : {
      "defaultCharsetName" : "utf8",
      "primaryKeyColumnNames" : [ "id" ],
      "columns" : [ {
        "name" : "id",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 1,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "default_value",
        "jdbcType" : 5,
        "typeName" : "TINYINT",
        "typeExpression" : "TINYINT",
        "charsetName" : null,
        "length" : 1,
        "position" : 2,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "label",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 3,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "internal_code",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 4,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_business_data",
        "jdbcType" : 1111,
        "typeName" : "JSON",
        "typeExpression" : "JSON",
        "charsetName" : null,
        "position" : 5,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_daaq",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 6,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_created",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 7,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_modified",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 8,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_who_created",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 9,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_who_modified",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 10,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      } ],
      "attributes" : [ ]
    },
    "comment" : null
  } ]
}

Offset: 11 Key: empty Timestamp: 2024-12-03 11:00:02.479 Headers: empty

{
  "source" : {
    "server" : "odm_scoring"
  },
  "position" : {
    "ts_sec" : 1733223601,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223601551,
  "databaseName" : "odm-scoring",
  "ddl" : "CREATE TABLE `scoring_scoring_request` (\n  `id` varchar(50) NOT NULL,\n  `_business_data` json DEFAULT NULL,\n  `decision_process_objecttype` varchar(250) DEFAULT NULL,\n  `decision_process_systemuid` varchar(50) DEFAULT NULL,\n  `decision_process_resourceuid` varchar(50) DEFAULT NULL,\n  `audit_trail_id` varchar(50) DEFAULT NULL,\n  `event_date` datetime DEFAULT NULL,\n  `request_id` varchar(50) DEFAULT NULL,\n  `scored_entity_objecttype` varchar(250) DEFAULT NULL,\n  `scored_entity_systemuid` varchar(50) DEFAULT NULL,\n  `scored_entity_resourceuid` varchar(50) DEFAULT NULL,\n  `response_id` varchar(50) DEFAULT NULL,\n  `original_request_id` varchar(50) DEFAULT NULL,\n  `_daaq` varchar(255) DEFAULT NULL,\n  `_when_created` datetime DEFAULT NULL,\n  `_when_modified` datetime DEFAULT NULL,\n  `_who_created` varchar(255) DEFAULT NULL,\n  `_who_modified` varchar(255) DEFAULT NULL,\n  PRIMARY KEY (`id`),\n  KEY `SCORING_SCORING_REQUEST_REQUEST_ID_FIX` (`request_id`),\n  KEY `SCORING_SCORING_REQUEST_RESPONSE_ID_FIX` (`response_id`),\n  KEY `SCORING_SCORING_REQUEST_AUDIT_TRAIL_ID_FIX` (`audit_trail_id`),\n  CONSTRAINT `scoring_scoring_request_audit_trail_id_fk` FOREIGN KEY (`audit_trail_id`) REFERENCES `scoring_scoring_audit_trail` (`id`),\n  CONSTRAINT `scoring_scoring_request_request_id_fk` FOREIGN KEY (`request_id`) REFERENCES `scoring_scoring_request_params` (`id`),\n  CONSTRAINT `scoring_scoring_request_response_id_fk` FOREIGN KEY (`response_id`) REFERENCES `scoring_scoring_response` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"odm-scoring\".\"scoring_scoring_request\"",
    "table" : {
      "defaultCharsetName" : "utf8",
      "primaryKeyColumnNames" : [ "id" ],
      "columns" : [ {
        "name" : "id",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 1,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "_business_data",
        "jdbcType" : 1111,
        "typeName" : "JSON",
        "typeExpression" : "JSON",
        "charsetName" : null,
        "position" : 2,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "decision_process_objecttype",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 250,
        "position" : 3,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "decision_process_systemuid",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 4,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "decision_process_resourceuid",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 5,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "audit_trail_id",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 6,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "event_date",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 7,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "request_id",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 8,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "scored_entity_objecttype",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 250,
        "position" : 9,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "scored_entity_systemuid",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 10,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "scored_entity_resourceuid",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 11,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "response_id",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 12,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "original_request_id",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 13,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_daaq",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 14,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_created",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 15,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_modified",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 16,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_who_created",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 17,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_who_modified",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 18,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      } ],
      "attributes" : [ ]
    },
    "comment" : null
  } ]
}

Offset: 12 Key: empty Timestamp: 2024-12-03 11:00:02.487 Headers: empty

{
  "source" : {
    "server" : "odm_scoring"
  },
  "position" : {
    "ts_sec" : 1733223601,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223601572,
  "databaseName" : "odm-scoring",
  "ddl" : "CREATE TABLE `scoring_scoring_request_params` (\n  `id` varchar(50) NOT NULL,\n  `_business_data` json DEFAULT NULL,\n  `scoring_data` longtext,\n  `scored_entity_objecttype` varchar(250) DEFAULT NULL,\n  `scored_entity_systemuid` varchar(50) DEFAULT NULL,\n  `scored_entity_resourceuid` varchar(50) DEFAULT NULL,\n  `_daaq` varchar(255) DEFAULT NULL,\n  `_when_created` datetime DEFAULT NULL,\n  `_when_modified` datetime DEFAULT NULL,\n  `_who_created` varchar(255) DEFAULT NULL,\n  `_who_modified` varchar(255) DEFAULT NULL,\n  `decision_process_objecttype` varchar(250) DEFAULT NULL,\n  `decision_process_systemuid` varchar(50) DEFAULT NULL,\n  `decision_process_resourceuid` varchar(50) DEFAULT NULL,\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"odm-scoring\".\"scoring_scoring_request_params\"",
    "table" : {
      "defaultCharsetName" : "utf8",
      "primaryKeyColumnNames" : [ "id" ],
      "columns" : [ {
        "name" : "id",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 1,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "_business_data",
        "jdbcType" : 1111,
        "typeName" : "JSON",
        "typeExpression" : "JSON",
        "charsetName" : null,
        "position" : 2,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "scoring_data",
        "jdbcType" : 12,
        "typeName" : "LONGTEXT",
        "typeExpression" : "LONGTEXT",
        "charsetName" : "utf8",
        "position" : 3,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "scored_entity_objecttype",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 250,
        "position" : 4,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "scored_entity_systemuid",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 5,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "scored_entity_resourceuid",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 6,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_daaq",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 7,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_created",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 8,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_modified",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 9,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_who_created",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 10,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_who_modified",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 11,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "decision_process_objecttype",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 250,
        "position" : 12,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "decision_process_systemuid",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 13,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "decision_process_resourceuid",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 14,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      } ],
      "attributes" : [ ]
    },
    "comment" : null
  } ]
}

Offset: 13 Key: empty Timestamp: 2024-12-03 11:00:02.496 Headers: empty

{
  "source" : {
    "server" : "odm_scoring"
  },
  "position" : {
    "ts_sec" : 1733223601,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223601578,
  "databaseName" : "odm-scoring",
  "ddl" : "CREATE TABLE `scoring_scoring_response` (\n  `id` varchar(50) NOT NULL,\n  `_business_data` json DEFAULT NULL,\n  `decision_qualification` varchar(255) DEFAULT NULL,\n  `level_code` varchar(50) DEFAULT NULL,\n  `decision` varchar(255) DEFAULT NULL,\n  `_daaq` varchar(255) DEFAULT NULL,\n  `_when_created` datetime DEFAULT NULL,\n  `_when_modified` datetime DEFAULT NULL,\n  `_who_created` varchar(255) DEFAULT NULL,\n  `_who_modified` varchar(255) DEFAULT NULL,\n  PRIMARY KEY (`id`),\n  KEY `SCORING_SCORING_RESPONSE_LEVEL_CODE_FIX` (`level_code`),\n  CONSTRAINT `scoring_scoring_response_level_code_fk` FOREIGN KEY (`level_code`) REFERENCES `scoring_scoring_level` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"odm-scoring\".\"scoring_scoring_response\"",
    "table" : {
      "defaultCharsetName" : "utf8",
      "primaryKeyColumnNames" : [ "id" ],
      "columns" : [ {
        "name" : "id",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 1,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "_business_data",
        "jdbcType" : 1111,
        "typeName" : "JSON",
        "typeExpression" : "JSON",
        "charsetName" : null,
        "position" : 2,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "decision_qualification",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 3,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "level_code",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 4,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "decision",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 5,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_daaq",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 6,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_created",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 7,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_modified",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 8,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_who_created",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 9,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_who_modified",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 10,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      } ],
      "attributes" : [ ]
    },
    "comment" : null
  } ]
}