{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223593, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223594652, "databaseName" : "", "ddl" : "SET character_set_server=utf8mb4, collation_server=utf8mb4_0900_ai_ci", "tableChanges" : [ ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223594, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223594825, "databaseName" : "odm-decision", "ddl" : "DROP TABLE IF EXISTS `odm-decision`.`decision_associated_analysis_process`", "tableChanges" : [ { "type" : "DROP", "id" : "\"odm-decision\".\"decision_associated_analysis_process\"" } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223594, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223594826, "databaseName" : "odm-decision", "ddl" : "DROP TABLE IF EXISTS `odm-decision`.`decision_decision_process`", "tableChanges" : [ { "type" : "DROP", "id" : "\"odm-decision\".\"decision_decision_process\"" } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223594, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223594826, "databaseName" : "odm-decision", "ddl" : "DROP TABLE IF EXISTS `odm-decision`.`decision_decision_reason`", "tableChanges" : [ { "type" : "DROP", "id" : "\"odm-decision\".\"decision_decision_reason\"" } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223594, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223594827, "databaseName" : "odm-decision", "ddl" : "DROP TABLE IF EXISTS `odm-decision`.`decision_decision_status`", "tableChanges" : [ { "type" : "DROP", "id" : "\"odm-decision\".\"decision_decision_status\"" } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223594, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223594827, "databaseName" : "odm-decision", "ddl" : "DROP TABLE IF EXISTS `odm-decision`.`decision_delegation_level`", "tableChanges" : [ { "type" : "DROP", "id" : "\"odm-decision\".\"decision_delegation_level\"" } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223594, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223594828, "databaseName" : "odm-decision", "ddl" : "DROP TABLE IF EXISTS `odm-decision`.`decision_element_reserve`", "tableChanges" : [ { "type" : "DROP", "id" : "\"odm-decision\".\"decision_element_reserve\"" } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223594, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223594828, "databaseName" : "odm-decision", "ddl" : "DROP TABLE IF EXISTS `odm-decision`.`decision_opinion`", "tableChanges" : [ { "type" : "DROP", "id" : "\"odm-decision\".\"decision_opinion\"" } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223594, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223594835, "databaseName" : "odm-decision", "ddl" : "DROP TABLE IF EXISTS `odm-decision`.`decision_opinion_maker`", "tableChanges" : [ { "type" : "DROP", "id" : "\"odm-decision\".\"decision_opinion_maker\"" } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223594, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223594839, "databaseName" : "odm-decision", "ddl" : "DROP TABLE IF EXISTS `odm-decision`.`decision_reason`", "tableChanges" : [ { "type" : "DROP", "id" : "\"odm-decision\".\"decision_reason\"" } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223594, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223594842, "databaseName" : "odm-decision", "ddl" : "DROP TABLE IF EXISTS `odm-decision`.`decision_reserve`", "tableChanges" : [ { "type" : "DROP", "id" : "\"odm-decision\".\"decision_reserve\"" } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223594, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223594842, "databaseName" : "odm-decision", "ddl" : "DROP TABLE IF EXISTS `odm-decision`.`decision_reserve_availability`", "tableChanges" : [ { "type" : "DROP", "id" : "\"odm-decision\".\"decision_reserve_availability\"" } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223597, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223597370, "databaseName" : "odm-decision", "ddl" : "CREATE DATABASE `odm-decision` CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci", "tableChanges" : [ ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223597, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223597434, "databaseName" : "odm-decision", "ddl" : "CREATE TABLE `decision_associated_analysis_process` (\n `id` varchar(50) NOT NULL,\n `_business_data` json DEFAULT NULL,\n `decision_process_id` varchar(50) DEFAULT NULL,\n `analysis_process_objecttype` varchar(250) DEFAULT NULL,\n `analysis_process_systemuid` varchar(50) DEFAULT NULL,\n `analysis_process_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 `DECISION_ASSOCIATED_ANALYSIS_PROCESS_DECISION_PROCESS_ID_IX` (`decision_process_id`),\n CONSTRAINT `decision_associated_analysis_process_decision_process_id_fk` FOREIGN KEY (`decision_process_id`) REFERENCES `decision_decision_process` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'", "tableChanges" : [ { "type" : "CREATE", "id" : "\"odm-decision\".\"decision_associated_analysis_process\"", "table" : { "defaultCharsetName" : "utf8", "primaryKeyColumnNames" : [ "id" ], "columns" : [ { "name" : "id", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 50, "position" : 1, "optional" : false, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : false, "enumValues" : [ ] }, { "name" : "_business_data", "jdbcType" : 1111, "typeName" : "JSON", "typeExpression" : "JSON", "charsetName" : null, "position" : 2, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "decision_process_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" : "analysis_process_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" : "analysis_process_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" : "analysis_process_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 } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223597, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223597463, "databaseName" : "odm-decision", "ddl" : "CREATE TABLE `decision_decision_process` (\n `id` varchar(50) NOT NULL,\n `_business_data` json DEFAULT NULL,\n `decision_entity_objecttype` varchar(250) DEFAULT NULL,\n `decision_entity_systemuid` varchar(50) DEFAULT NULL,\n `decision_entity_resourceuid` varchar(50) DEFAULT NULL,\n `_reference` 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 `decision_data` longtext,\n `_comment` longtext,\n `decision_date` datetime DEFAULT NULL,\n `decision_maker_id_objecttype` varchar(250) DEFAULT NULL,\n `decision_maker_id_systemuid` varchar(50) DEFAULT NULL,\n `decision_maker_id_resourceuid` varchar(50) DEFAULT NULL,\n `status_code` varchar(50) DEFAULT NULL,\n `delegation_level_id` varchar(50) DEFAULT NULL,\n PRIMARY KEY (`id`),\n UNIQUE KEY `DECISION_DECISION_PROCESS_OFFERREFERENCE` (`_reference`),\n KEY `DECISION_DECISION_PROCESS_STATUS_CODE_FIX` (`status_code`),\n KEY `DECISION_DECISION_PROCESS_DELEGATION_LEVEL_ID_FIX` (`delegation_level_id`),\n CONSTRAINT `decision_decision_process_delegation_level_id_fk` FOREIGN KEY (`delegation_level_id`) REFERENCES `decision_delegation_level` (`id`),\n CONSTRAINT `decision_decision_process_status_code_fk` FOREIGN KEY (`status_code`) REFERENCES `decision_decision_status` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'", "tableChanges" : [ { "type" : "CREATE", "id" : "\"odm-decision\".\"decision_decision_process\"", "table" : { "defaultCharsetName" : "utf8", "primaryKeyColumnNames" : [ "id" ], "columns" : [ { "name" : "id", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 50, "position" : 1, "optional" : false, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : false, "enumValues" : [ ] }, { "name" : "_business_data", "jdbcType" : 1111, "typeName" : "JSON", "typeExpression" : "JSON", "charsetName" : null, "position" : 2, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "decision_entity_objecttype", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 250, "position" : 3, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "decision_entity_systemuid", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 50, "position" : 4, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "decision_entity_resourceuid", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 50, "position" : 5, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_reference", "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" : "_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" : "decision_data", "jdbcType" : 12, "typeName" : "LONGTEXT", "typeExpression" : "LONGTEXT", "charsetName" : "utf8", "position" : 12, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_comment", "jdbcType" : 12, "typeName" : "LONGTEXT", "typeExpression" : "LONGTEXT", "charsetName" : "utf8", "position" : 13, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "decision_date", "jdbcType" : 93, "typeName" : "DATETIME", "typeExpression" : "DATETIME", "charsetName" : null, "position" : 14, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "decision_maker_id_objecttype", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 250, "position" : 15, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "decision_maker_id_systemuid", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 50, "position" : 16, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "decision_maker_id_resourceuid", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 50, "position" : 17, "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" : 18, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "delegation_level_id", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 50, "position" : 19, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] } ], "attributes" : [ ] }, "comment" : null } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223597, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223597497, "databaseName" : "odm-decision", "ddl" : "CREATE TABLE `decision_decision_reason` (\n `id` varchar(50) NOT NULL,\n `_business_data` json DEFAULT NULL,\n `decision_process_id` varchar(50) DEFAULT NULL,\n `reason_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 `DECISION_DECISION_REASON_DECISION_PROCESS_ID_FIX` (`decision_process_id`),\n KEY `DECISION_DECISION_REASON_REASON_CODE_FIX` (`reason_code`),\n CONSTRAINT `decision_decision_reason_decision_process_id_fk` FOREIGN KEY (`decision_process_id`) REFERENCES `decision_decision_process` (`id`),\n CONSTRAINT `decision_decision_reason_reason_code_fk` FOREIGN KEY (`reason_code`) REFERENCES `decision_reason` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'", "tableChanges" : [ { "type" : "CREATE", "id" : "\"odm-decision\".\"decision_decision_reason\"", "table" : { "defaultCharsetName" : "utf8", "primaryKeyColumnNames" : [ "id" ], "columns" : [ { "name" : "id", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 50, "position" : 1, "optional" : false, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : false, "enumValues" : [ ] }, { "name" : "_business_data", "jdbcType" : 1111, "typeName" : "JSON", "typeExpression" : "JSON", "charsetName" : null, "position" : 2, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "decision_process_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" : "reason_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" : "_daaq", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 255, "position" : 5, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_when_created", "jdbcType" : 93, "typeName" : "DATETIME", "typeExpression" : "DATETIME", "charsetName" : null, "position" : 6, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_when_modified", "jdbcType" : 93, "typeName" : "DATETIME", "typeExpression" : "DATETIME", "charsetName" : null, "position" : 7, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_who_created", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 255, "position" : 8, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_who_modified", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 255, "position" : 9, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] } ], "attributes" : [ ] }, "comment" : null } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223597, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223597517, "databaseName" : "odm-decision", "ddl" : "CREATE TABLE `decision_decision_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 `_when_created` datetime DEFAULT NULL,\n `_when_modified` datetime DEFAULT NULL,\n `_who_created` varchar(255) DEFAULT NULL,\n `_who_modified` varchar(255) DEFAULT NULL,\n `_daaq` varchar(255) DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `DECISION_DECISION_STATUS_INTERNAL_CODE_IX` (`internal_code`,`default_value`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'", "tableChanges" : [ { "type" : "CREATE", "id" : "\"odm-decision\".\"decision_decision_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" : "_when_created", "jdbcType" : 93, "typeName" : "DATETIME", "typeExpression" : "DATETIME", "charsetName" : null, "position" : 6, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_when_modified", "jdbcType" : 93, "typeName" : "DATETIME", "typeExpression" : "DATETIME", "charsetName" : null, "position" : 7, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_who_created", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 255, "position" : 8, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_who_modified", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 255, "position" : 9, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_daaq", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 255, "position" : 10, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] } ], "attributes" : [ ] }, "comment" : null } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223597, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223597552, "databaseName" : "odm-decision", "ddl" : "CREATE TABLE `decision_delegation_level` (\n `id` varchar(50) NOT NULL,\n `_business_data` json DEFAULT NULL,\n `validity_from` date DEFAULT NULL,\n `validity_until` date DEFAULT NULL,\n `i_18n_code` 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-decision\".\"decision_delegation_level\"", "table" : { "defaultCharsetName" : "utf8", "primaryKeyColumnNames" : [ "id" ], "columns" : [ { "name" : "id", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 50, "position" : 1, "optional" : false, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : false, "enumValues" : [ ] }, { "name" : "_business_data", "jdbcType" : 1111, "typeName" : "JSON", "typeExpression" : "JSON", "charsetName" : null, "position" : 2, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "validity_from", "jdbcType" : 91, "typeName" : "DATE", "typeExpression" : "DATE", "charsetName" : null, "position" : 3, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "validity_until", "jdbcType" : 91, "typeName" : "DATE", "typeExpression" : "DATE", "charsetName" : null, "position" : 4, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "i_18n_code", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 255, "position" : 5, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_daaq", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 255, "position" : 6, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_when_created", "jdbcType" : 93, "typeName" : "DATETIME", "typeExpression" : "DATETIME", "charsetName" : null, "position" : 7, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_when_modified", "jdbcType" : 93, "typeName" : "DATETIME", "typeExpression" : "DATETIME", "charsetName" : null, "position" : 8, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_who_created", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 255, "position" : 9, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_who_modified", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 255, "position" : 10, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] } ], "attributes" : [ ] }, "comment" : null } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223597, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223597599, "databaseName" : "odm-decision", "ddl" : "CREATE TABLE `decision_element_reserve` (\n `_discriminator` varchar(50) DEFAULT NULL,\n `id` varchar(50) NOT NULL,\n `_business_data` json DEFAULT NULL,\n `reserve_code` varchar(50) DEFAULT NULL,\n `analysis_id` varchar(50) DEFAULT NULL,\n `opinion_maker_id` varchar(50) DEFAULT NULL,\n `_comment` 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 `decision_process_id` varchar(50) DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `DECISION_ELEMENT_RESERVE_ANALYSIS_ID_FIX` (`analysis_id`),\n KEY `DECISION_ELEMENT_RESERVE_DECISION_PROCESS_ID_FIX` (`decision_process_id`),\n KEY `DECISION_ELEMENT_RESERVE_OPINION_MAKER_ID_FIX` (`opinion_maker_id`),\n KEY `DECISION_ELEMENT_RESERVE_RESERVE_CODE_FIX` (`reserve_code`),\n CONSTRAINT `decision_element_reserve_analysis_id_fk` FOREIGN KEY (`analysis_id`) REFERENCES `decision_associated_analysis_process` (`id`),\n CONSTRAINT `decision_element_reserve_decision_process_id_fk` FOREIGN KEY (`decision_process_id`) REFERENCES `decision_decision_process` (`id`),\n CONSTRAINT `decision_element_reserve_opinion_maker_id_fk` FOREIGN KEY (`opinion_maker_id`) REFERENCES `decision_opinion_maker` (`id`),\n CONSTRAINT `decision_element_reserve_reserve_code_fk` FOREIGN KEY (`reserve_code`) REFERENCES `decision_reserve` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'", "tableChanges" : [ { "type" : "CREATE", "id" : "\"odm-decision\".\"decision_element_reserve\"", "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" : "reserve_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" : "analysis_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" : "opinion_maker_id", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 50, "position" : 6, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_comment", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 255, "position" : 7, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_daaq", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 255, "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" : "decision_process_id", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 50, "position" : 13, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] } ], "attributes" : [ ] }, "comment" : null } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223597, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223597607, "databaseName" : "odm-decision", "ddl" : "CREATE TABLE `decision_opinion` (\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 `DECISION_OPINION_INTERNAL_CODE_IX` (`internal_code`,`default_value`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'", "tableChanges" : [ { "type" : "CREATE", "id" : "\"odm-decision\".\"decision_opinion\"", "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 } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223597, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223597631, "databaseName" : "odm-decision", "ddl" : "CREATE TABLE `decision_opinion_maker` (\n `id` varchar(50) NOT NULL,\n `_business_data` json DEFAULT NULL,\n `opinion_code` varchar(50) DEFAULT NULL,\n `decision_process_id` varchar(50) DEFAULT NULL,\n `opinion_maker_id_objecttype` varchar(250) DEFAULT NULL,\n `opinion_maker_id_systemuid` varchar(50) DEFAULT NULL,\n `opinion_maker_id_resourceuid` varchar(50) DEFAULT NULL,\n `_comment` longtext,\n `_daaq` varchar(255) DEFAULT NULL,\n `_when_created` datetime DEFAULT NULL,\n `_when_modified` datetime DEFAULT NULL,\n `_who_created` varchar(255) DEFAULT NULL,\n `_who_modified` varchar(255) DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `DECISION_OPINION_MAKER_DECISION_PROCESS_ID_IX` (`decision_process_id`),\n KEY `DECISION_OPINION_MAKER_OPINION_CODE_FIX` (`opinion_code`),\n CONSTRAINT `decision_opinion_maker_decision_process_id_fk` FOREIGN KEY (`decision_process_id`) REFERENCES `decision_decision_process` (`id`),\n CONSTRAINT `decision_opinion_maker_opinion_code_fk` FOREIGN KEY (`opinion_code`) REFERENCES `decision_opinion` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'", "tableChanges" : [ { "type" : "CREATE", "id" : "\"odm-decision\".\"decision_opinion_maker\"", "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" : "opinion_code", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 50, "position" : 3, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "decision_process_id", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 50, "position" : 4, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "opinion_maker_id_objecttype", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 250, "position" : 5, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "opinion_maker_id_systemuid", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 50, "position" : 6, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "opinion_maker_id_resourceuid", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 50, "position" : 7, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_comment", "jdbcType" : 12, "typeName" : "LONGTEXT", "typeExpression" : "LONGTEXT", "charsetName" : "utf8", "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 } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223597, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223597636, "databaseName" : "odm-decision", "ddl" : "CREATE TABLE `decision_reason` (\n `id` varchar(50) NOT NULL,\n `_business_data` json DEFAULT NULL,\n `_name` varchar(255) DEFAULT NULL,\n `decision_status_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 `DECISION_REASON_DECISION_STATUS_CODE_FIX` (`decision_status_code`),\n CONSTRAINT `decision_reason_decision_status_code_fk` FOREIGN KEY (`decision_status_code`) REFERENCES `decision_decision_status` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'", "tableChanges" : [ { "type" : "CREATE", "id" : "\"odm-decision\".\"decision_reason\"", "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" : "_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" : "decision_status_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" : "_daaq", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 255, "position" : 5, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_when_created", "jdbcType" : 93, "typeName" : "DATETIME", "typeExpression" : "DATETIME", "charsetName" : null, "position" : 6, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_when_modified", "jdbcType" : 93, "typeName" : "DATETIME", "typeExpression" : "DATETIME", "charsetName" : null, "position" : 7, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_who_created", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 255, "position" : 8, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "_who_modified", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 255, "position" : 9, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] } ], "attributes" : [ ] }, "comment" : null } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223597, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223597645, "databaseName" : "odm-decision", "ddl" : "CREATE TABLE `decision_reserve` (\n `id` varchar(50) NOT NULL,\n `_business_data` json DEFAULT NULL,\n `_name` 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-decision\".\"decision_reserve\"", "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" : "_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" : "_daaq", "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" : [ ] } ], "attributes" : [ ] }, "comment" : null } ] }
{ "source" : { "server" : "odm_decision" }, "position" : { "ts_sec" : 1733223597, "file" : "mysql-bin.000003", "pos" : 136843096, "snapshot" : true }, "ts_ms" : 1733223597652, "databaseName" : "odm-decision", "ddl" : "CREATE TABLE `decision_reserve_availability` (\n `id` varchar(50) NOT NULL,\n `_business_data` json DEFAULT NULL,\n `available_reserves_engine` varchar(50) DEFAULT NULL,\n `available_reserves_rule` json DEFAULT NULL,\n `application_name` varchar(255) DEFAULT NULL,\n `_context` 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-decision\".\"decision_reserve_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" : "available_reserves_engine", "jdbcType" : 12, "typeName" : "VARCHAR", "typeExpression" : "VARCHAR", "charsetName" : "utf8", "length" : 50, "position" : 3, "optional" : true, "autoIncremented" : false, "generated" : false, "comment" : null, "hasDefaultValue" : true, "enumValues" : [ ] }, { "name" : "available_reserves_rule", "jdbcType" : 1111, "typeName" : "JSON", "typeExpression" : "JSON", "charsetName" : null, "position" : 4, "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" : 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" : "_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 } ] }