Topic Messages: schema-changes.contactmechanism

First Offset: 0  Last Offset: 30  Size: 30
  
  
  
  
  
No available descriptor, please check.
  
  
Offset: 0   Key: empty   Timestamp: 2024-12-03 11:00:01.984 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223593,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223594651,
  "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.995 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223594,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223594825,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "DROP TABLE IF EXISTS `odm-contactmechanism`.`contactmechanism_communication_event`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_communication_event\""
  } ]
}
Offset: 2   Key: empty   Timestamp: 2024-12-03 11:00:02.015 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223594,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223594825,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "DROP TABLE IF EXISTS `odm-contactmechanism`.`contactmechanism_communication_metadata`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_communication_metadata\""
  } ]
}
Offset: 3   Key: empty   Timestamp: 2024-12-03 11:00:02.020 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223594,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223594826,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "DROP TABLE IF EXISTS `odm-contactmechanism`.`contactmechanism_contact_mechanism_client`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_contact_mechanism_client\""
  } ]
}
Offset: 4   Key: empty   Timestamp: 2024-12-03 11:00:02.025 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223594,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223594826,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "DROP TABLE IF EXISTS `odm-contactmechanism`.`contactmechanism_email_template`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_email_template\""
  } ]
}
Offset: 5   Key: empty   Timestamp: 2024-12-03 11:00:02.029 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223594,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223594834,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "DROP TABLE IF EXISTS `odm-contactmechanism`.`contactmechanism_message_recipient`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_message_recipient\""
  } ]
}
Offset: 6   Key: empty   Timestamp: 2024-12-03 11:00:02.032 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223594,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223594835,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "DROP TABLE IF EXISTS `odm-contactmechanism`.`contactmechanism_message_status`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_message_status\""
  } ]
}
Offset: 7   Key: empty   Timestamp: 2024-12-03 11:00:02.035 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223594,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223594835,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "DROP TABLE IF EXISTS `odm-contactmechanism`.`contactmechanism_message_subject`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_message_subject\""
  } ]
}
Offset: 8   Key: empty   Timestamp: 2024-12-03 11:00:02.054 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223594,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223594837,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "DROP TABLE IF EXISTS `odm-contactmechanism`.`contactmechanism_message_template`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_message_template\""
  } ]
}
Offset: 9   Key: empty   Timestamp: 2024-12-03 11:00:02.083 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223594,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223594837,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "DROP TABLE IF EXISTS `odm-contactmechanism`.`contactmechanism_message_type`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_message_type\""
  } ]
}
Offset: 10   Key: empty   Timestamp: 2024-12-03 11:00:02.088 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223594,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223594841,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "DROP TABLE IF EXISTS `odm-contactmechanism`.`contactmechanism_notice_template`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_notice_template\""
  } ]
}
Offset: 11   Key: empty   Timestamp: 2024-12-03 11:00:02.097 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223594,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223594843,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "DROP TABLE IF EXISTS `odm-contactmechanism`.`contactmechanism_notice_template_availability`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_notice_template_availability\""
  } ]
}
Offset: 12   Key: empty   Timestamp: 2024-12-03 11:00:02.104 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223594,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223594843,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "DROP TABLE IF EXISTS `odm-contactmechanism`.`contactmechanism_pack_notice_template_item`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_pack_notice_template_item\""
  } ]
}
Offset: 13   Key: empty   Timestamp: 2024-12-03 11:00:02.113 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223594,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223594848,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "DROP TABLE IF EXISTS `odm-contactmechanism`.`contactmechanism_sms_template`",
  "tableChanges" : [ {
    "type" : "DROP",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_sms_template\""
  } ]
}
Offset: 14   Key: empty   Timestamp: 2024-12-03 11:00:02.128 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223596,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223596961,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "DROP DATABASE IF EXISTS `odm-contactmechanism`",
  "tableChanges" : [ ]
}
Offset: 15   Key: empty   Timestamp: 2024-12-03 11:00:02.149 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223596,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223596962,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "CREATE DATABASE `odm-contactmechanism` CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci",
  "tableChanges" : [ ]
}
Offset: 16   Key: empty   Timestamp: 2024-12-03 11:00:02.164 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223596,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223596962,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "USE `odm-contactmechanism`",
  "tableChanges" : [ ]
}
Offset: 17   Key: empty   Timestamp: 2024-12-03 11:00:02.174 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223596,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223597034,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "CREATE TABLE `contactmechanism_communication_event` (\n  `_discriminator` varchar(50) DEFAULT NULL,\n  `id` varchar(50) NOT NULL,\n  `_business_data` json DEFAULT NULL,\n  `sender` varchar(255) DEFAULT NULL,\n  `hidden_recipient` varchar(255) DEFAULT NULL,\n  `client_application_objecttype` varchar(250) DEFAULT NULL,\n  `client_application_systemuid` varchar(50) DEFAULT NULL,\n  `client_application_resourceuid` varchar(50) DEFAULT NULL,\n  `related_objects` json DEFAULT NULL,\n  `body` longtext,\n  `recipient` varchar(255) DEFAULT NULL,\n  `copy_recipient` varchar(255) DEFAULT NULL,\n  `communication_date` datetime DEFAULT NULL,\n  `_subject` 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  `status_code` varchar(50) DEFAULT NULL,\n  `type_code` varchar(50) DEFAULT NULL,\n  `transfer_msg_parent_id` varchar(50) DEFAULT NULL,\n  `subject_code` varchar(50) DEFAULT NULL,\n  `reply_msg_parent_id` varchar(50) DEFAULT NULL,\n  `priority` tinyint(1) DEFAULT NULL,\n  `document_objecttype` varchar(250) DEFAULT NULL,\n  `document_systemuid` varchar(50) DEFAULT NULL,\n  `document_resourceuid` varchar(50) DEFAULT NULL,\n  `sender_uid_objecttype` varchar(250) DEFAULT NULL,\n  `sender_uid_systemuid` varchar(50) DEFAULT NULL,\n  `sender_uid_resourceuid` varchar(50) DEFAULT NULL,\n  PRIMARY KEY (`id`),\n  KEY `CONTACTMECHANISM_COMMUNICATION_EVENT_REPLY_MSG_PARENT_ID_FIX` (`reply_msg_parent_id`),\n  KEY `CONTACTMECHANISM_COMMUNICATION_EVENT_STATUS_CODE_FIX` (`status_code`),\n  KEY `CONTACTMECHANISM_COMMUNICATION_EVENT_SUBJECT_CODE_FIX` (`subject_code`),\n  KEY `CONTACTMECHANISM_COMMUNICATION_EVENT_TRANSFER_MSG_PARENT_ID_FIX` (`transfer_msg_parent_id`),\n  KEY `CONTACTMECHANISM_COMMUNICATION_EVENT_TYPE_CODE_FIX` (`type_code`),\n  CONSTRAINT `contactmechanism_communication_event_reply_msg_parent_id_fk` FOREIGN KEY (`reply_msg_parent_id`) REFERENCES `contactmechanism_communication_event` (`id`),\n  CONSTRAINT `contactmechanism_communication_event_status_code_fk` FOREIGN KEY (`status_code`) REFERENCES `contactmechanism_message_status` (`id`),\n  CONSTRAINT `contactmechanism_communication_event_subject_code_fk` FOREIGN KEY (`subject_code`) REFERENCES `contactmechanism_message_subject` (`id`),\n  CONSTRAINT `contactmechanism_communication_event_transfer_msg_parent_id_fk` FOREIGN KEY (`transfer_msg_parent_id`) REFERENCES `contactmechanism_communication_event` (`id`),\n  CONSTRAINT `contactmechanism_communication_event_type_code_fk` FOREIGN KEY (`type_code`) REFERENCES `contactmechanism_message_type` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_communication_event\"",
    "table" : {
      "defaultCharsetName" : "utf8",
      "primaryKeyColumnNames" : [ "id" ],
      "columns" : [ {
        "name" : "_discriminator",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 1,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "id",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 2,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "_business_data",
        "jdbcType" : 1111,
        "typeName" : "JSON",
        "typeExpression" : "JSON",
        "charsetName" : null,
        "position" : 3,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "sender",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 4,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "hidden_recipient",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 5,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "client_application_objecttype",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 250,
        "position" : 6,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "client_application_systemuid",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 7,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "client_application_resourceuid",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 8,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "related_objects",
        "jdbcType" : 1111,
        "typeName" : "JSON",
        "typeExpression" : "JSON",
        "charsetName" : null,
        "position" : 9,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "body",
        "jdbcType" : 12,
        "typeName" : "LONGTEXT",
        "typeExpression" : "LONGTEXT",
        "charsetName" : "utf8",
        "position" : 10,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "recipient",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 11,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "copy_recipient",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 12,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "communication_date",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 13,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_subject",
        "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" : [ ]
      }, {
        "name" : "_daaq",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 19,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "status_code",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 20,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "type_code",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 21,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "transfer_msg_parent_id",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 22,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "subject_code",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 23,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "reply_msg_parent_id",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 24,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "priority",
        "jdbcType" : 5,
        "typeName" : "TINYINT",
        "typeExpression" : "TINYINT",
        "charsetName" : null,
        "length" : 1,
        "position" : 25,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "document_objecttype",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 250,
        "position" : 26,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "document_systemuid",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 27,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "document_resourceuid",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 28,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "sender_uid_objecttype",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 250,
        "position" : 29,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "sender_uid_systemuid",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 30,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "sender_uid_resourceuid",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 31,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      } ],
      "attributes" : [ ]
    },
    "comment" : null
  } ]
}
Offset: 18   Key: empty   Timestamp: 2024-12-03 11:00:02.181 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223597,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223597051,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "CREATE TABLE `contactmechanism_communication_metadata` (\n  `id` varchar(50) NOT NULL,\n  `_business_data` json DEFAULT NULL,\n  `_value` varchar(255) DEFAULT NULL,\n  `_key` varchar(255) DEFAULT NULL,\n  `communication_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 `CONTACTMECHANISM_COMMUNICATION_METADATA_COMMUNICATION_ID_IX` (`communication_id`),\n  CONSTRAINT `contactmechanism_communication_metadata_communication_id_fk` FOREIGN KEY (`communication_id`) REFERENCES `contactmechanism_communication_event` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_communication_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" : "_key",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 4,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "communication_id",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "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: 19   Key: empty   Timestamp: 2024-12-03 11:00:02.199 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223597,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223597071,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "CREATE TABLE `contactmechanism_contact_mechanism_client` (\n  `id` varchar(50) NOT NULL,\n  `_business_data` json DEFAULT NULL,\n  `label` varchar(255) DEFAULT NULL,\n  `email_server_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  `callback_base_url` varchar(255) DEFAULT NULL,\n  `use_callback` tinyint(1) DEFAULT NULL,\n  `use_sms` tinyint(1) DEFAULT NULL,\n  `use_email` tinyint(1) 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-contactmechanism\".\"contactmechanism_contact_mechanism_client\"",
    "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" : "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" : "email_server_key",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 4,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_created",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 5,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_modified",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 6,
        "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" : 7,
        "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" : 8,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "callback_base_url",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 9,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "use_callback",
        "jdbcType" : 5,
        "typeName" : "TINYINT",
        "typeExpression" : "TINYINT",
        "charsetName" : null,
        "length" : 1,
        "position" : 10,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "use_sms",
        "jdbcType" : 5,
        "typeName" : "TINYINT",
        "typeExpression" : "TINYINT",
        "charsetName" : null,
        "length" : 1,
        "position" : 11,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "use_email",
        "jdbcType" : 5,
        "typeName" : "TINYINT",
        "typeExpression" : "TINYINT",
        "charsetName" : null,
        "length" : 1,
        "position" : 12,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_daaq",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 13,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      } ],
      "attributes" : [ ]
    },
    "comment" : null
  } ]
}
Offset: 20   Key: empty   Timestamp: 2024-12-03 11:00:02.207 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223597,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223597101,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "CREATE TABLE `contactmechanism_email_template` (\n  `id` varchar(50) NOT NULL,\n  `_business_data` json DEFAULT NULL,\n  `sender` longtext,\n  `hidden_recipient` longtext,\n  `body` longtext,\n  `recipient` longtext,\n  `copy_recipient` longtext,\n  `_subject` longtext,\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-contactmechanism\".\"contactmechanism_email_template\"",
    "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" : "sender",
        "jdbcType" : 12,
        "typeName" : "LONGTEXT",
        "typeExpression" : "LONGTEXT",
        "charsetName" : "utf8",
        "position" : 3,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "hidden_recipient",
        "jdbcType" : 12,
        "typeName" : "LONGTEXT",
        "typeExpression" : "LONGTEXT",
        "charsetName" : "utf8",
        "position" : 4,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "body",
        "jdbcType" : 12,
        "typeName" : "LONGTEXT",
        "typeExpression" : "LONGTEXT",
        "charsetName" : "utf8",
        "position" : 5,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "recipient",
        "jdbcType" : 12,
        "typeName" : "LONGTEXT",
        "typeExpression" : "LONGTEXT",
        "charsetName" : "utf8",
        "position" : 6,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "copy_recipient",
        "jdbcType" : 12,
        "typeName" : "LONGTEXT",
        "typeExpression" : "LONGTEXT",
        "charsetName" : "utf8",
        "position" : 7,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_subject",
        "jdbcType" : 12,
        "typeName" : "LONGTEXT",
        "typeExpression" : "LONGTEXT",
        "charsetName" : "utf8",
        "position" : 8,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_created",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 9,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_modified",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 10,
        "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" : 11,
        "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" : 12,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_daaq",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 13,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      } ],
      "attributes" : [ ]
    },
    "comment" : null
  } ]
}
Offset: 21   Key: empty   Timestamp: 2024-12-03 11:00:02.228 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223597,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223597112,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "CREATE TABLE `contactmechanism_message_recipient` (\n  `id` varchar(50) NOT NULL,\n  `_business_data` json DEFAULT NULL,\n  `message_event_id` varchar(50) DEFAULT NULL,\n  `recipient_objecttype` varchar(250) DEFAULT NULL,\n  `recipient_systemuid` varchar(50) DEFAULT NULL,\n  `recipient_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  PRIMARY KEY (`id`),\n  KEY `CONTACTMECHANISM_MESSAGE_RECIPIENT_MESSAGE_EVENT_ID_FIX` (`message_event_id`),\n  CONSTRAINT `contactmechanism_message_recipient_message_event_id_fk` FOREIGN KEY (`message_event_id`) REFERENCES `contactmechanism_communication_event` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_message_recipient\"",
    "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" : "message_event_id",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 3,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "recipient_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" : "recipient_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" : "recipient_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" : [ ]
      } ],
      "attributes" : [ ]
    },
    "comment" : null
  } ]
}
Offset: 22   Key: empty   Timestamp: 2024-12-03 11:00:02.244 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223597,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223597124,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "CREATE TABLE `contactmechanism_message_status` (\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 `CONTACTMECHANISM_MESSAGE_STATUS_INTERNAL_CODE_IX` (`internal_code`,`default_value`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_message_status\"",
    "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: 23   Key: empty   Timestamp: 2024-12-03 11:00:02.249 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223597,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223597129,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "CREATE TABLE `contactmechanism_message_subject` (\n  `id` varchar(50) NOT 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) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_message_subject\"",
    "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" : "_daaq",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 3,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_created",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 4,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_modified",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 5,
        "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" : 6,
        "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" : 7,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      } ],
      "attributes" : [ ]
    },
    "comment" : null
  } ]
}
Offset: 24   Key: empty   Timestamp: 2024-12-03 11:00:02.262 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223597,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223597161,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "CREATE TABLE `contactmechanism_message_template` (\n  `id` varchar(50) NOT NULL,\n  `_business_data` json DEFAULT NULL,\n  `sender` longtext,\n  `type_code` varchar(50) DEFAULT NULL,\n  `body` longtext,\n  `user_recipients` longtext,\n  `priority` tinyint(1) DEFAULT NULL,\n  `group_recipients` longtext,\n  `subject_code` 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 `CONTACTMECHANISM_MESSAGE_TEMPLATE_SUBJECT_CODE_FIX` (`subject_code`),\n  KEY `CONTACTMECHANISM_MESSAGE_TEMPLATE_TYPE_CODE_FIX` (`type_code`),\n  KEY `cm_message_template_type_code_fix` (`type_code`),\n  CONSTRAINT `contactmechanism_message_template_subject_code_fk` FOREIGN KEY (`subject_code`) REFERENCES `contactmechanism_message_subject` (`id`),\n  CONSTRAINT `contactmechanism_message_template_type_code_fk` FOREIGN KEY (`type_code`) REFERENCES `contactmechanism_message_type` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_message_template\"",
    "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" : "sender",
        "jdbcType" : 12,
        "typeName" : "LONGTEXT",
        "typeExpression" : "LONGTEXT",
        "charsetName" : "utf8",
        "position" : 3,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "type_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" : "body",
        "jdbcType" : 12,
        "typeName" : "LONGTEXT",
        "typeExpression" : "LONGTEXT",
        "charsetName" : "utf8",
        "position" : 5,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "user_recipients",
        "jdbcType" : 12,
        "typeName" : "LONGTEXT",
        "typeExpression" : "LONGTEXT",
        "charsetName" : "utf8",
        "position" : 6,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "priority",
        "jdbcType" : 5,
        "typeName" : "TINYINT",
        "typeExpression" : "TINYINT",
        "charsetName" : null,
        "length" : 1,
        "position" : 7,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "group_recipients",
        "jdbcType" : 12,
        "typeName" : "LONGTEXT",
        "typeExpression" : "LONGTEXT",
        "charsetName" : "utf8",
        "position" : 8,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "subject_code",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "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" : [ ]
      }, {
        "name" : "_when_created",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 11,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_modified",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 12,
        "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" : 13,
        "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" : 14,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      } ],
      "attributes" : [ ]
    },
    "comment" : null
  } ]
}
Offset: 25   Key: empty   Timestamp: 2024-12-03 11:00:02.269 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223597,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223597171,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "CREATE TABLE `contactmechanism_message_type` (\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 `CONTACTMECHANISM_MESSAGE_TYPE_INTERNAL_CODE_IX` (`internal_code`,`default_value`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_message_type\"",
    "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: 26   Key: empty   Timestamp: 2024-12-03 11:00:02.276 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223597,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223597186,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "CREATE TABLE `contactmechanism_notice_template` (\n  `_discriminator` varchar(50) DEFAULT NULL,\n  `id` varchar(50) NOT NULL,\n  `_business_data` json DEFAULT NULL,\n  `sender` longtext,\n  `body` longtext,\n  `validity_from` date DEFAULT NULL,\n  `validity_until` date DEFAULT NULL,\n  `recipient` longtext,\n  `file_name` varchar(255) DEFAULT NULL,\n  `file_path` 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) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_notice_template\"",
    "table" : {
      "defaultCharsetName" : "utf8",
      "primaryKeyColumnNames" : [ "id" ],
      "columns" : [ {
        "name" : "_discriminator",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 1,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "id",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 2,
        "optional" : false,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : false,
        "enumValues" : [ ]
      }, {
        "name" : "_business_data",
        "jdbcType" : 1111,
        "typeName" : "JSON",
        "typeExpression" : "JSON",
        "charsetName" : null,
        "position" : 3,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "sender",
        "jdbcType" : 12,
        "typeName" : "LONGTEXT",
        "typeExpression" : "LONGTEXT",
        "charsetName" : "utf8",
        "position" : 4,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "body",
        "jdbcType" : 12,
        "typeName" : "LONGTEXT",
        "typeExpression" : "LONGTEXT",
        "charsetName" : "utf8",
        "position" : 5,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "validity_from",
        "jdbcType" : 91,
        "typeName" : "DATE",
        "typeExpression" : "DATE",
        "charsetName" : null,
        "position" : 6,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "validity_until",
        "jdbcType" : 91,
        "typeName" : "DATE",
        "typeExpression" : "DATE",
        "charsetName" : null,
        "position" : 7,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "recipient",
        "jdbcType" : 12,
        "typeName" : "LONGTEXT",
        "typeExpression" : "LONGTEXT",
        "charsetName" : "utf8",
        "position" : 8,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "file_name",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 9,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "file_path",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 10,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_daaq",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 11,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_created",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 12,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_modified",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 13,
        "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" : 14,
        "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" : 15,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      } ],
      "attributes" : [ ]
    },
    "comment" : null
  } ]
}
Offset: 27   Key: empty   Timestamp: 2024-12-03 11:00:02.285 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223597,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223597198,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "CREATE TABLE `contactmechanism_notice_template_availability` (\n  `id` varchar(50) NOT NULL,\n  `_business_data` json DEFAULT NULL,\n  `application_name` varchar(255) DEFAULT NULL,\n  `validity_from` date DEFAULT NULL,\n  `validity_until` date DEFAULT NULL,\n  `_context` varchar(255) DEFAULT NULL,\n  `available_notice_templates_engine` varchar(50) DEFAULT NULL,\n  `available_notice_templates_rule` 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 `CONTACTMECHANISM_NOTICE_TEMPLATE_AVAILABILITY_APPLICATIONNAME` (`application_name`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_notice_template_availability\"",
    "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" : "application_name",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 3,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "validity_from",
        "jdbcType" : 91,
        "typeName" : "DATE",
        "typeExpression" : "DATE",
        "charsetName" : null,
        "position" : 4,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "validity_until",
        "jdbcType" : 91,
        "typeName" : "DATE",
        "typeExpression" : "DATE",
        "charsetName" : null,
        "position" : 5,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_context",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 6,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "available_notice_templates_engine",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 7,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "available_notice_templates_rule",
        "jdbcType" : 1111,
        "typeName" : "JSON",
        "typeExpression" : "JSON",
        "charsetName" : null,
        "position" : 8,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_daaq",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 255,
        "position" : 9,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_created",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 10,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_modified",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 11,
        "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" : 12,
        "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" : 13,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      } ],
      "attributes" : [ ]
    },
    "comment" : null
  } ]
}
Offset: 28   Key: empty   Timestamp: 2024-12-03 11:00:02.314 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223597,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223597221,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "CREATE TABLE `contactmechanism_pack_notice_template_item` (\n  `id` varchar(50) NOT NULL,\n  `_business_data` json DEFAULT NULL,\n  `document_order` bigint(20) DEFAULT NULL,\n  `item_template_code` varchar(50) DEFAULT NULL,\n  `pack_notice_template_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  `pack_notice_template_item_rule_engine` varchar(50) DEFAULT NULL,\n  `pack_notice_template_item_rule_rule` json DEFAULT NULL,\n  PRIMARY KEY (`id`),\n  KEY `CM_PACK_NOTICE_TEMPLATE_ITEM_ITEM_TEMPLATE_CODE_FIX` (`item_template_code`),\n  KEY `CM_PACK_NOTICE_TEMPLATE_ITEM_PACK_NOTICE_TEMPLATE_ID_FIX` (`pack_notice_template_id`),\n  CONSTRAINT `contactmechanism_pack_notice_template_item_item_template_code_fk` FOREIGN KEY (`item_template_code`) REFERENCES `contactmechanism_notice_template` (`id`),\n  CONSTRAINT `contactmechanism_template_item_pack_notice_template_id_fk` FOREIGN KEY (`pack_notice_template_id`) REFERENCES `contactmechanism_notice_template` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
  "tableChanges" : [ {
    "type" : "CREATE",
    "id" : "\"odm-contactmechanism\".\"contactmechanism_pack_notice_template_item\"",
    "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" : "document_order",
        "jdbcType" : -5,
        "typeName" : "BIGINT",
        "typeExpression" : "BIGINT",
        "charsetName" : null,
        "length" : 20,
        "position" : 3,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "item_template_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" : "pack_notice_template_id",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "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" : [ ]
      }, {
        "name" : "pack_notice_template_item_rule_engine",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 50,
        "position" : 11,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "pack_notice_template_item_rule_rule",
        "jdbcType" : 1111,
        "typeName" : "JSON",
        "typeExpression" : "JSON",
        "charsetName" : null,
        "position" : 12,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      } ],
      "attributes" : [ ]
    },
    "comment" : null
  } ]
}
Offset: 29   Key: empty   Timestamp: 2024-12-03 11:00:02.357 Headers: empty
  
{
  "source" : {
    "server" : "odm_contactmechanism"
  },
  "position" : {
    "ts_sec" : 1733223597,
    "file" : "mysql-bin.000003",
    "pos" : 136843096,
    "snapshot" : true
  },
  "ts_ms" : 1733223597242,
  "databaseName" : "odm-contactmechanism",
  "ddl" : "CREATE TABLE `contactmechanism_sms_template` (\n  `id` varchar(50) NOT NULL,\n  `_business_data` json DEFAULT NULL,\n  `body` longtext,\n  `recipient` varchar(20) 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-contactmechanism\".\"contactmechanism_sms_template\"",
    "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" : "body",
        "jdbcType" : 12,
        "typeName" : "LONGTEXT",
        "typeExpression" : "LONGTEXT",
        "charsetName" : "utf8",
        "position" : 3,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "recipient",
        "jdbcType" : 12,
        "typeName" : "VARCHAR",
        "typeExpression" : "VARCHAR",
        "charsetName" : "utf8",
        "length" : 20,
        "position" : 4,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_created",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 5,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_when_modified",
        "jdbcType" : 93,
        "typeName" : "DATETIME",
        "typeExpression" : "DATETIME",
        "charsetName" : null,
        "position" : 6,
        "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" : 7,
        "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" : 8,
        "optional" : true,
        "autoIncremented" : false,
        "generated" : false,
        "comment" : null,
        "hasDefaultValue" : true,
        "enumValues" : [ ]
      }, {
        "name" : "_daaq",
        "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
  } ]
}