{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223594,
"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" : [ ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594989,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_answer_option`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_answer_option\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594990,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_answer_type`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_answer_type\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594990,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_assessment_context`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_assessment_context\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594990,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_check_points`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_check_points\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594991,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_check_points_config`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_check_points_config\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594991,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_check_points_status`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_check_points_status\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594992,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_content_qualification`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_content_qualification\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594992,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_document_type`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_document_type\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594992,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_field_value_type_config`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_field_value_type_config\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594993,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_gathering_process`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_gathering_process\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594993,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_gathering_process_item`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_gathering_process_item\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594993,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_process_status`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_process_status\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594998,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_question`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_question\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594998,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_question_category`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_question_category\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594999,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_questionnaire_gathering_question`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_questionnaire_gathering_question\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594999,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_received_file`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_received_file\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594999,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_received_file_content`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_received_file_content\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223595000,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_received_file_status`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_received_file_status\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223595,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223595000,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_supporting_document`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_supporting_document\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223595,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223595000,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_supporting_document_entity_def`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_supporting_document_entity_def\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223595,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223595001,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_supporting_document_entity_metadata`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_supporting_document_entity_metadata\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223595,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223595001,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_supporting_document_entity_target`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_supporting_document_entity_target\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223595,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223595004,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_supporting_document_family`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_supporting_document_family\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223595,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223595004,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_supporting_document_status`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_supporting_document_status\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223595,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223595005,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_supporting_type`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_supporting_type\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223595,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223595005,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP TABLE IF EXISTS `odm-supportingdocument`.`supportingdocument_trigger_action_config`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-supportingdocument\".\"supportingdocument_trigger_action_config\""
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223601,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223601454,
"databaseName" : "odm-supportingdocument",
"ddl" : "DROP DATABASE IF EXISTS `odm-supportingdocument`",
"tableChanges" : [ ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223601,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223601454,
"databaseName" : "odm-supportingdocument",
"ddl" : "CREATE DATABASE `odm-supportingdocument` CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci",
"tableChanges" : [ ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223601,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223601467,
"databaseName" : "odm-supportingdocument",
"ddl" : "CREATE TABLE `supportingdocument_answer_option` (\n `id` varchar(50) NOT NULL,\n `_business_data` json DEFAULT NULL,\n `type_id` varchar(50) 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 `answer_order` bigint(20) DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `SP_ANSWER_OPTION_TYPE_ID_FIX` (`type_id`),\n CONSTRAINT `sp_answer_option_type_id_fk` FOREIGN KEY (`type_id`) REFERENCES `supportingdocument_answer_type` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-supportingdocument\".\"supportingdocument_answer_option\"",
"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" : "type_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" : "i_18n_code",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"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" : [ ]
}, {
"name" : "answer_order",
"jdbcType" : -5,
"typeName" : "BIGINT",
"typeExpression" : "BIGINT",
"charsetName" : null,
"length" : 20,
"position" : 10,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
} ],
"attributes" : [ ]
},
"comment" : null
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223601,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223601475,
"databaseName" : "odm-supportingdocument",
"ddl" : "CREATE TABLE `supportingdocument_answer_type` (\n `id` varchar(50) NOT NULL,\n `_business_data` json DEFAULT NULL,\n `_description` 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-supportingdocument\".\"supportingdocument_answer_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" : "_business_data",
"jdbcType" : 1111,
"typeName" : "JSON",
"typeExpression" : "JSON",
"charsetName" : null,
"position" : 2,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "_description",
"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_supportingdocument"
},
"position" : {
"ts_sec" : 1733223601,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223601488,
"databaseName" : "odm-supportingdocument",
"ddl" : "CREATE TABLE `supportingdocument_assessment_context` (\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 `context_type` 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 `reevaluate_rule_engine` varchar(50) DEFAULT NULL,\n `reevaluate_rule_rule` json DEFAULT NULL,\n `closing_rule_engine` varchar(50) DEFAULT NULL,\n `closing_rule_rule` json DEFAULT NULL,\n `int_rule_engine` varchar(50) DEFAULT NULL,\n `int_rule_rule` json DEFAULT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-supportingdocument\".\"supportingdocument_assessment_context\"",
"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" : "context_type",
"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" : [ ]
}, {
"name" : "reevaluate_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" : "reevaluate_rule_rule",
"jdbcType" : 1111,
"typeName" : "JSON",
"typeExpression" : "JSON",
"charsetName" : null,
"position" : 12,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "closing_rule_engine",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 13,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "closing_rule_rule",
"jdbcType" : 1111,
"typeName" : "JSON",
"typeExpression" : "JSON",
"charsetName" : null,
"position" : 14,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "int_rule_engine",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 15,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "int_rule_rule",
"jdbcType" : 1111,
"typeName" : "JSON",
"typeExpression" : "JSON",
"charsetName" : null,
"position" : 16,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
} ],
"attributes" : [ ]
},
"comment" : null
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223601,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223601504,
"databaseName" : "odm-supportingdocument",
"ddl" : "CREATE TABLE `supportingdocument_check_points` (\n `_discriminator` varchar(50) DEFAULT NULL,\n `id` varchar(50) NOT NULL,\n `_business_data` json DEFAULT NULL,\n `target_entity_uid` varchar(50) DEFAULT NULL,\n `status_code` varchar(50) DEFAULT NULL,\n `check_points_config_code` varchar(50) DEFAULT NULL,\n `completion_date` date DEFAULT NULL,\n `check_point_id` varchar(50) DEFAULT NULL,\n `field_type_code` varchar(50) DEFAULT NULL,\n `i_18n_label` varchar(255) DEFAULT NULL,\n `field_value` varchar(255) DEFAULT NULL,\n `check_order` bigint(20) DEFAULT NULL,\n `check_comment` varchar(255) DEFAULT NULL,\n `checked` tinyint(1) 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 `flag_manually` tinyint(1) DEFAULT NULL,\n `supporting_document_id` varchar(50) DEFAULT NULL,\n `i_18n_reference_label` varchar(255) DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `SP_CHECK_POINTS_CHECK_POINT_ID_FIX` (`check_point_id`),\n KEY `SP_CHECK_POINTS_CHECK_POINTS_CONFIG_CODE_FIX` (`check_points_config_code`),\n KEY `SP_CHECK_POINTS_FIELD_TYPE_CODE_FIX` (`field_type_code`),\n KEY `SP_CHECK_POINTS_STATUS_CODE_FIX` (`status_code`),\n KEY `SP_CHECK_POINTS_SUPPORTING_DOCUMENT_ID_FIX` (`supporting_document_id`),\n CONSTRAINT `sp_check_points_check_point_id_fk` FOREIGN KEY (`check_point_id`) REFERENCES `supportingdocument_gathering_process_item` (`id`),\n CONSTRAINT `sp_check_points_check_points_config_code_fk` FOREIGN KEY (`check_points_config_code`) REFERENCES `supportingdocument_check_points_config` (`id`),\n CONSTRAINT `sp_check_points_field_type_code_fk` FOREIGN KEY (`field_type_code`) REFERENCES `supportingdocument_field_value_type_config` (`id`),\n CONSTRAINT `sp_check_points_status_code_fk` FOREIGN KEY (`status_code`) REFERENCES `supportingdocument_check_points_status` (`id`),\n CONSTRAINT `sp_check_points_supporting_document_id_fk` FOREIGN KEY (`supporting_document_id`) REFERENCES `supportingdocument_supporting_document` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-supportingdocument\".\"supportingdocument_check_points\"",
"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" : "target_entity_uid",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 4,
"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" : 5,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "check_points_config_code",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 6,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "completion_date",
"jdbcType" : 91,
"typeName" : "DATE",
"typeExpression" : "DATE",
"charsetName" : null,
"position" : 7,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "check_point_id",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 8,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "field_type_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" : "i_18n_label",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 10,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "field_value",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 11,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "check_order",
"jdbcType" : -5,
"typeName" : "BIGINT",
"typeExpression" : "BIGINT",
"charsetName" : null,
"length" : 20,
"position" : 12,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "check_comment",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 13,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "checked",
"jdbcType" : 5,
"typeName" : "TINYINT",
"typeExpression" : "TINYINT",
"charsetName" : null,
"length" : 1,
"position" : 14,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "_daaq",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 15,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "_when_created",
"jdbcType" : 93,
"typeName" : "DATETIME",
"typeExpression" : "DATETIME",
"charsetName" : null,
"position" : 16,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "_when_modified",
"jdbcType" : 93,
"typeName" : "DATETIME",
"typeExpression" : "DATETIME",
"charsetName" : null,
"position" : 17,
"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" : 18,
"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" : 19,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "flag_manually",
"jdbcType" : 5,
"typeName" : "TINYINT",
"typeExpression" : "TINYINT",
"charsetName" : null,
"length" : 1,
"position" : 20,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "supporting_document_id",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 21,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "i_18n_reference_label",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 22,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
} ],
"attributes" : [ ]
},
"comment" : null
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223601,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223601535,
"databaseName" : "odm-supportingdocument",
"ddl" : "CREATE TABLE `supportingdocument_check_points_config` (\n `_discriminator` varchar(50) DEFAULT NULL,\n `id` varchar(50) NOT NULL,\n `_business_data` json DEFAULT NULL,\n `business_rule_value_engine` varchar(50) DEFAULT NULL,\n `business_rule_value_rule` json DEFAULT NULL,\n `type_code` varchar(50) DEFAULT NULL,\n `deadline_duration` bigint(20) DEFAULT NULL,\n `deadline_unit` varchar(20) DEFAULT NULL,\n `trigger_action_code` varchar(50) DEFAULT NULL,\n `i_18n_label` varchar(255) DEFAULT NULL,\n `check_order` bigint(20) DEFAULT NULL,\n `_enable` tinyint(1) DEFAULT NULL,\n `document_family_code` varchar(50) DEFAULT NULL,\n `i_18n_reference_label` 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 `flag_manually` tinyint(1) DEFAULT NULL,\n `field_object_type` varchar(255) DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `SP_CHECK_POINTS_CONFIG_DOCUMENT_FAMILY_CODE_FIX` (`document_family_code`),\n KEY `SP_CHECK_POINTS_CONFIG_TRIGGER_ACTION_CODE_FIX` (`trigger_action_code`),\n KEY `SP_CHECK_POINTS_CONFIG_TYPE_CODE_FIX` (`type_code`),\n CONSTRAINT `sp_check_points_config_document_family_code_fk` FOREIGN KEY (`document_family_code`) REFERENCES `supportingdocument_supporting_document_family` (`id`),\n CONSTRAINT `sp_check_points_config_trigger_action_code_fk` FOREIGN KEY (`trigger_action_code`) REFERENCES `supportingdocument_trigger_action_config` (`id`),\n CONSTRAINT `sp_check_points_config_type_code_fk` FOREIGN KEY (`type_code`) REFERENCES `supportingdocument_field_value_type_config` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-supportingdocument\".\"supportingdocument_check_points_config\"",
"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" : "business_rule_value_engine",
"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_rule_value_rule",
"jdbcType" : 1111,
"typeName" : "JSON",
"typeExpression" : "JSON",
"charsetName" : null,
"position" : 5,
"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" : 6,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "deadline_duration",
"jdbcType" : -5,
"typeName" : "BIGINT",
"typeExpression" : "BIGINT",
"charsetName" : null,
"length" : 20,
"position" : 7,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "deadline_unit",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 20,
"position" : 8,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "trigger_action_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" : "i_18n_label",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 10,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "check_order",
"jdbcType" : -5,
"typeName" : "BIGINT",
"typeExpression" : "BIGINT",
"charsetName" : null,
"length" : 20,
"position" : 11,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "_enable",
"jdbcType" : 5,
"typeName" : "TINYINT",
"typeExpression" : "TINYINT",
"charsetName" : null,
"length" : 1,
"position" : 12,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "document_family_code",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 13,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "i_18n_reference_label",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 14,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "_daaq",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 15,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "_when_created",
"jdbcType" : 93,
"typeName" : "DATETIME",
"typeExpression" : "DATETIME",
"charsetName" : null,
"position" : 16,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "_when_modified",
"jdbcType" : 93,
"typeName" : "DATETIME",
"typeExpression" : "DATETIME",
"charsetName" : null,
"position" : 17,
"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" : 18,
"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" : 19,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "flag_manually",
"jdbcType" : 5,
"typeName" : "TINYINT",
"typeExpression" : "TINYINT",
"charsetName" : null,
"length" : 1,
"position" : 20,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "field_object_type",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 21,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
} ],
"attributes" : [ ]
},
"comment" : null
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223601,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223601546,
"databaseName" : "odm-supportingdocument",
"ddl" : "CREATE TABLE `supportingdocument_check_points_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 `SP_CHECK_POINTS_STATUS_INTERNAL_CODE_IX` (`internal_code`,`default_value`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-supportingdocument\".\"supportingdocument_check_points_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
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223601,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223601566,
"databaseName" : "odm-supportingdocument",
"ddl" : "CREATE TABLE `supportingdocument_content_qualification` (\n `id` varchar(50) NOT NULL,\n `_business_data` json DEFAULT NULL,\n `supporting_document_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 `content_id` varchar(50) DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `SP_CONTENT_QUALIFICATION_CONTENT_ID_IX` (`content_id`),\n KEY `SP_CONTENT_QUALIFICATION_SUPPORTING_DOCUMENT_ID_FIX` (`supporting_document_id`),\n KEY `SP_CONTENT_QUALIFICATION_CONTENT_ID_FIX` (`content_id`),\n CONSTRAINT `sp_content_qualification_content_id_fk` FOREIGN KEY (`content_id`) REFERENCES `supportingdocument_received_file_content` (`id`),\n CONSTRAINT `sp_content_qualification_supporting_document_id_fk` FOREIGN KEY (`supporting_document_id`) REFERENCES `supportingdocument_supporting_document` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-supportingdocument\".\"supportingdocument_content_qualification\"",
"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" : "supporting_document_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" : "_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" : [ ]
}, {
"name" : "content_id",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 9,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
} ],
"attributes" : [ ]
},
"comment" : null
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223601,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223601573,
"databaseName" : "odm-supportingdocument",
"ddl" : "CREATE TABLE `supportingdocument_document_type` (\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-supportingdocument\".\"supportingdocument_document_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" : "_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
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223601,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223601579,
"databaseName" : "odm-supportingdocument",
"ddl" : "CREATE TABLE `supportingdocument_field_value_type_config` (\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 `SP_FIELD_VALUE_TYPE_CONFIG_INTERNAL_CODE_IX` (`internal_code`,`default_value`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-supportingdocument\".\"supportingdocument_field_value_type_config\"",
"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_supportingdocument"
},
"position" : {
"ts_sec" : 1733223601,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223601587,
"databaseName" : "odm-supportingdocument",
"ddl" : "CREATE TABLE `supportingdocument_gathering_process` (\n `id` varchar(50) NOT NULL,\n `_business_data` json DEFAULT NULL,\n `status_code` varchar(50) DEFAULT NULL,\n `start_process_timestamp` datetime DEFAULT NULL,\n `end_process_timestamp` datetime DEFAULT NULL,\n `last_update_timestamp` datetime DEFAULT NULL,\n `context_type` varchar(255) DEFAULT NULL,\n `process_valid_until` datetime DEFAULT NULL,\n `assessment_context_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 `SP_GATHERING_PROCESS_ASSESSMENT_CONTEXT_ID_FIX` (`assessment_context_id`),\n KEY `SP_GATHERING_PROCESS_STATUS_CODE_FIX` (`status_code`),\n CONSTRAINT `sp_gathering_process_assessment_context_id_fk` FOREIGN KEY (`assessment_context_id`) REFERENCES `supportingdocument_assessment_context` (`id`),\n CONSTRAINT `sp_gathering_process_status_code_fk` FOREIGN KEY (`status_code`) REFERENCES `supportingdocument_process_status` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-supportingdocument\".\"supportingdocument_gathering_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" : "status_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" : "start_process_timestamp",
"jdbcType" : 93,
"typeName" : "DATETIME",
"typeExpression" : "DATETIME",
"charsetName" : null,
"position" : 4,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "end_process_timestamp",
"jdbcType" : 93,
"typeName" : "DATETIME",
"typeExpression" : "DATETIME",
"charsetName" : null,
"position" : 5,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "last_update_timestamp",
"jdbcType" : 93,
"typeName" : "DATETIME",
"typeExpression" : "DATETIME",
"charsetName" : null,
"position" : 6,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "context_type",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 7,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "process_valid_until",
"jdbcType" : 93,
"typeName" : "DATETIME",
"typeExpression" : "DATETIME",
"charsetName" : null,
"position" : 8,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "assessment_context_id",
"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
} ]
}
{
"source" : {
"server" : "odm_supportingdocument"
},
"position" : {
"ts_sec" : 1733223601,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223601594,
"databaseName" : "odm-supportingdocument",
"ddl" : "CREATE TABLE `supportingdocument_gathering_process_item` (\n `_discriminator` varchar(50) DEFAULT NULL,\n `id` varchar(50) NOT NULL,\n `_business_data` json DEFAULT NULL,\n `process_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 `_description` varchar(255) DEFAULT NULL,\n `i_18n_code` varchar(255) DEFAULT NULL,\n PRIMARY KEY (`id`),\n KEY `SP_GATHERING_PROCESS_ITEM_PROCESS_ID_IX` (`process_id`),\n KEY `SP_GATHERING_PROCESS_ITEM_PROCESS_ID_FIX` (`process_id`),\n CONSTRAINT `sp_gathering_process_item_process_id_fk` FOREIGN KEY (`process_id`) REFERENCES `supportingdocument_gathering_process` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='TRIAL'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-supportingdocument\".\"supportingdocument_gathering_process_item\"",
"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" : "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" : "_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" : [ ]
}, {
"name" : "_description",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 10,
"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" : 11,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
} ],
"attributes" : [ ]
},
"comment" : null
} ]
}