Kafdrop: Topic: schema-changes.odm

Topic Messages: schema-changes.odm_filemngt

First Offset: 0 Last Offset: 8 Size: 8

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

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

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

{
  "source" : {
    "server" : "odm_filemngt"
  },
  "position" : {
    "ts_sec" : 1733223594,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223594911,
  "databaseName" : "odm-filemngt",
  "ddl" : "DROP TABLE IF EXISTS `odm-filemngt`.`filemngt_file_descriptor`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"odm-filemngt\".\"filemngt_file_descriptor\""
  } ]
}

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

{
  "source" : {
    "server" : "odm_filemngt"
  },
  "position" : {
    "ts_sec" : 1733223594,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223594911,
  "databaseName" : "odm-filemngt",
  "ddl" : "DROP TABLE IF EXISTS `odm-filemngt`.`filemngt_file_metadata`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"odm-filemngt\".\"filemngt_file_metadata\""
  } ]
}

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

{
  "source" : {
    "server" : "odm_filemngt"
  },
  "position" : {
    "ts_sec" : 1733223597,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223597728,
  "databaseName" : "odm-filemngt",
  "ddl" : "DROP DATABASE IF EXISTS `odm-filemngt`",
  "tableChanges" : [ ]
}

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

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

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

{
  "source" : {
    "server" : "odm_filemngt"
  },
  "position" : {
    "ts_sec" : 1733223597,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223597728,
  "databaseName" : "odm-filemngt",
  "ddl" : "USE `odm-filemngt`",
  "tableChanges" : [ ]
}

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

{
  "source" : {
    "server" : "odm_filemngt"
  },
  "position" : {
    "ts_sec" : 1733223597,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223597734,
  "databaseName" : "odm-filemngt",
  "ddl" : "CREATE TABLE `filemngt_file_descriptor` (\n  `id` varchar(50) NOT NULL,\n  `_business_data` json DEFAULT NULL,\n  `file_location` varchar(255) DEFAULT NULL,\n  `relations` json DEFAULT NULL,\n  `original_file_name` varchar(255) DEFAULT NULL,\n  `_format` varchar(255) DEFAULT NULL,\n  `md_5hash` 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  `_daaq` varchar(255) DEFAULT NULL,\n  PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"odm-filemngt\".\"filemngt_file_descriptor\"",
    "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" : "file_location",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 3,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "relations",
        "jdbcType" : 1111,
        "typeName" : "JSON",
        "typeExpression" : "JSON",
        "charsetName" : null,
        "position" : 4,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "original_file_name",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 5,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_format",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 6,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "md_5hash",
        "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" : "_daaq",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 12,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      } ],
      "attributes" : [ ]
    },
    "comment" : null
  } ]
}

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

{
  "source" : {
    "server" : "odm_filemngt"
  },
  "position" : {
    "ts_sec" : 1733223597,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223597746,
  "databaseName" : "odm-filemngt",
  "ddl" : "CREATE TABLE `filemngt_file_metadata` (\n  `id` varchar(50) NOT NULL,\n  `_business_data` json DEFAULT NULL,\n  `_value` varchar(255) DEFAULT NULL,\n  `file_id` varchar(50) DEFAULT NULL,\n  `_key` 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  `_daaq` varchar(255) DEFAULT NULL,\n  PRIMARY KEY (`id`),\n  KEY `FILEMNGT_FILE_METADATA_FILE_ID_IX` (`file_id`),\n  KEY `FILEMNGT_FILE_METADATA_FILE_ID_FIX` (`file_id`),\n  CONSTRAINT `filemngt_file_metadata_file_id_fk` FOREIGN KEY (`file_id`) REFERENCES `filemngt_file_descriptor` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"odm-filemngt\".\"filemngt_file_metadata\"",
    "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" : "_value",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 3,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "file_id",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 4,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_key",
        "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" : [ ]
      }, {
        "name" : "_daaq",
        "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
  } ]
}