{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223593,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594654,
"databaseName" : "",
"ddl" : "SET character_set_server=utf8mb4, collation_server=utf8mb4_0900_ai_ci",
"tableChanges" : [ ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594742,
"databaseName" : "odm-analysis",
"ddl" : "DROP TABLE IF EXISTS `odm-analysis`.`analysis_analysis_process_status`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-analysis\".\"analysis_analysis_process_status\""
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594750,
"databaseName" : "odm-analysis",
"ddl" : "DROP TABLE IF EXISTS `odm-analysis`.`analysis_analysis_score`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-analysis\".\"analysis_analysis_score\""
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594751,
"databaseName" : "odm-analysis",
"ddl" : "DROP TABLE IF EXISTS `odm-analysis`.`analysis_assessment`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-analysis\".\"analysis_assessment\""
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594754,
"databaseName" : "odm-analysis",
"ddl" : "DROP TABLE IF EXISTS `odm-analysis`.`analysis_opinion_qualification`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-analysis\".\"analysis_opinion_qualification\""
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594756,
"databaseName" : "odm-analysis",
"ddl" : "DROP TABLE IF EXISTS `odm-analysis`.`analysis_opinion_qualification_type`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-analysis\".\"analysis_opinion_qualification_type\""
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594757,
"databaseName" : "odm-analysis",
"ddl" : "DROP TABLE IF EXISTS `odm-analysis`.`analysis_process`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-analysis\".\"analysis_process\""
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594802,
"databaseName" : "odm-analysis",
"ddl" : "DROP TABLE IF EXISTS `odm-analysis`.`analysis_rating`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-analysis\".\"analysis_rating\""
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594803,
"databaseName" : "odm-analysis",
"ddl" : "DROP TABLE IF EXISTS `odm-analysis`.`analysis_ratio_category`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-analysis\".\"analysis_ratio_category\""
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594806,
"databaseName" : "odm-analysis",
"ddl" : "DROP TABLE IF EXISTS `odm-analysis`.`analysis_ratio_evaluation`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-analysis\".\"analysis_ratio_evaluation\""
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594806,
"databaseName" : "odm-analysis",
"ddl" : "DROP TABLE IF EXISTS `odm-analysis`.`analysis_ratio_param`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-analysis\".\"analysis_ratio_param\""
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594807,
"databaseName" : "odm-analysis",
"ddl" : "DROP TABLE IF EXISTS `odm-analysis`.`analysis_ratio_param_type`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-analysis\".\"analysis_ratio_param_type\""
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223594,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223594807,
"databaseName" : "odm-analysis",
"ddl" : "DROP TABLE IF EXISTS `odm-analysis`.`analysis_ratio_value`",
"tableChanges" : [ {
"type" : "DROP",
"id" : "\"odm-analysis\".\"analysis_ratio_value\""
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223595,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223595098,
"databaseName" : "odm-analysis",
"ddl" : "CREATE DATABASE `odm-analysis` CHARSET utf8mb4 COLLATE utf8mb4_0900_ai_ci",
"tableChanges" : [ ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223595,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223595280,
"databaseName" : "odm-analysis",
"ddl" : "CREATE TABLE `analysis_analysis_process_status` (\n `id` varchar(50) NOT NULL COMMENT 'Resource UID',\n `default_value` tinyint(3) DEFAULT NULL COMMENT 'Default value for the associated enum',\n `label` varchar(255) DEFAULT NULL COMMENT 'Label for the associated enum',\n `internal_code` varchar(50) DEFAULT NULL COMMENT 'Associated enum value',\n `_business_data` json DEFAULT NULL COMMENT 'Business data',\n `_daaq` varchar(255) NOT NULL DEFAULT '/',\n `_when_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_when_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_who_created` varchar(255) NOT NULL,\n `_who_modified` varchar(255) NOT NULL,\n PRIMARY KEY (`id`),\n KEY `ANALYSIS_ANALYSIS_PROCESS_STATUS_INTERNAL_CODE_IX` (`internal_code`,`default_value`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Analysis process status'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-analysis\".\"analysis_analysis_process_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" : 3,
"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" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "/",
"enumValues" : [ ]
}, {
"name" : "_when_created",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 7,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_when_modified",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 8,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_who_created",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 9,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "_who_modified",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 10,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
} ],
"attributes" : [ ]
},
"comment" : null
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223595,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223595347,
"databaseName" : "odm-analysis",
"ddl" : "CREATE TABLE `analysis_analysis_score` (\n `id` varchar(50) NOT NULL COMMENT 'Resource UID',\n `_business_data` json DEFAULT NULL COMMENT 'Business data',\n `_value` varchar(255) DEFAULT NULL COMMENT 'Scoring value',\n `decision` varchar(255) DEFAULT NULL COMMENT 'Scoring decision',\n `_comment` longtext COMMENT 'Comment',\n `_daaq` varchar(255) NOT NULL DEFAULT '/',\n `_when_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_when_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_who_created` varchar(255) NOT NULL,\n `_who_modified` varchar(255) NOT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Analysis score'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-analysis\".\"analysis_analysis_score\"",
"table" : {
"defaultCharsetName" : "utf8",
"primaryKeyColumnNames" : [ "id" ],
"columns" : [ {
"name" : "id",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 1,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "_business_data",
"jdbcType" : 1111,
"typeName" : "JSON",
"typeExpression" : "JSON",
"charsetName" : null,
"position" : 2,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "_value",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 3,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "decision",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 4,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "_comment",
"jdbcType" : 12,
"typeName" : "LONGTEXT",
"typeExpression" : "LONGTEXT",
"charsetName" : "utf8",
"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" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "/",
"enumValues" : [ ]
}, {
"name" : "_when_created",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 7,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_when_modified",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 8,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_who_created",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 9,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "_who_modified",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 10,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
} ],
"attributes" : [ ]
},
"comment" : null
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223595,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223595386,
"databaseName" : "odm-analysis",
"ddl" : "CREATE TABLE `analysis_assessment` (\n `id` varchar(50) NOT NULL COMMENT 'Resource UID',\n `_business_data` json DEFAULT NULL COMMENT 'Business data',\n `analysis_score_rule_engine` varchar(50) DEFAULT NULL COMMENT 'Analysis assessment business rules from',\n `analysis_score_rule_rule` json DEFAULT NULL COMMENT 'Analysis assessment business rules until',\n `application_name` varchar(255) DEFAULT NULL COMMENT 'Application name',\n `validity_from` date DEFAULT NULL COMMENT 'Validity from',\n `validity_until` date DEFAULT NULL COMMENT 'Validity until',\n `analysis_rating_rule_engine` varchar(50) DEFAULT NULL COMMENT 'Analysis assessment business rules from',\n `analysis_rating_rule_rule` json DEFAULT NULL COMMENT 'Analysis assessment business rules until',\n `context_type` varchar(255) DEFAULT NULL COMMENT 'Context type',\n `_daaq` varchar(255) NOT NULL DEFAULT '/',\n `_when_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_when_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_who_created` varchar(255) NOT NULL,\n `_who_modified` varchar(255) NOT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Analysis assessment'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-analysis\".\"analysis_assessment\"",
"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" : "analysis_score_rule_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" : "analysis_score_rule_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" : "validity_from",
"jdbcType" : 91,
"typeName" : "DATE",
"typeExpression" : "DATE",
"charsetName" : null,
"position" : 6,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "validity_until",
"jdbcType" : 91,
"typeName" : "DATE",
"typeExpression" : "DATE",
"charsetName" : null,
"position" : 7,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "analysis_rating_rule_engine",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 8,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "analysis_rating_rule_rule",
"jdbcType" : 1111,
"typeName" : "JSON",
"typeExpression" : "JSON",
"charsetName" : null,
"position" : 9,
"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" : 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" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "/",
"enumValues" : [ ]
}, {
"name" : "_when_created",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 12,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_when_modified",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 13,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_who_created",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 14,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "_who_modified",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 15,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
} ],
"attributes" : [ ]
},
"comment" : null
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223595,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223595538,
"databaseName" : "odm-analysis",
"ddl" : "CREATE TABLE `analysis_opinion_qualification` (\n `id` varchar(50) NOT NULL COMMENT 'Resource UID',\n `_business_data` json DEFAULT NULL COMMENT 'Business data',\n `qualification_type_code` varchar(50) DEFAULT NULL COMMENT 'Opinion qualification type',\n `_comment` longtext COMMENT 'Decision comment',\n `_daaq` varchar(255) NOT NULL DEFAULT '/',\n `_when_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_when_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_who_created` varchar(255) NOT NULL,\n `_who_modified` varchar(255) NOT NULL,\n `process_id` varchar(50) DEFAULT NULL COMMENT 'Reverse attribute for opinionQualifications',\n PRIMARY KEY (`id`),\n KEY `ANALYSIS_OPINION_QUALIFICATION_QUALIFICATION_TYPE_CODE_FIX` (`qualification_type_code`),\n KEY `AN_OPINION_QUALIFICATION_PROCESS_ID_FIX` (`process_id`),\n CONSTRAINT `analysis_opinion_qualification_process_id_fk` FOREIGN KEY (`process_id`) REFERENCES `analysis_process` (`id`),\n CONSTRAINT `analysis_opinion_qualification_qualification_type_code_fk` FOREIGN KEY (`qualification_type_code`) REFERENCES `analysis_opinion_qualification_type` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Analysis opinion qualification'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-analysis\".\"analysis_opinion_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" : "qualification_type_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" : "_comment",
"jdbcType" : 12,
"typeName" : "LONGTEXT",
"typeExpression" : "LONGTEXT",
"charsetName" : "utf8",
"position" : 4,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "_daaq",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 5,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "/",
"enumValues" : [ ]
}, {
"name" : "_when_created",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 6,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_when_modified",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 7,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_who_created",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 8,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "_who_modified",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 9,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "process_id",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 10,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
} ],
"attributes" : [ ]
},
"comment" : null
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223595,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223595581,
"databaseName" : "odm-analysis",
"ddl" : "CREATE TABLE `analysis_opinion_qualification_type` (\n `id` varchar(50) NOT NULL COMMENT 'Resource UID',\n `_business_data` json DEFAULT NULL COMMENT 'Business data',\n `_daaq` varchar(255) NOT NULL DEFAULT '/',\n `_when_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_when_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_who_created` varchar(255) NOT NULL,\n `_who_modified` varchar(255) NOT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Opinion qualification type'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-analysis\".\"analysis_opinion_qualification_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" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "/",
"enumValues" : [ ]
}, {
"name" : "_when_created",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 4,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_when_modified",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 5,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_who_created",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 6,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "_who_modified",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 7,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
} ],
"attributes" : [ ]
},
"comment" : null
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223595,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223595706,
"databaseName" : "odm-analysis",
"ddl" : "CREATE TABLE `analysis_process` (\n `id` varchar(50) NOT NULL COMMENT 'Resource UID',\n `_business_data` json DEFAULT NULL COMMENT 'Business data',\n `status_code` varchar(50) DEFAULT NULL COMMENT 'Analysis status',\n `analysis_data` longtext COMMENT 'Analysis data',\n `assessment_code` varchar(50) DEFAULT NULL COMMENT 'Analysis configuration',\n `_daaq` varchar(255) NOT NULL DEFAULT '/',\n `_when_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_when_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_who_created` varchar(255) NOT NULL,\n `_who_modified` varchar(255) NOT NULL,\n `analysis_entity_objecttype` varchar(250) DEFAULT NULL COMMENT 'Analysis entity objectType',\n `analysis_entity_systemuid` varchar(50) DEFAULT NULL COMMENT 'Analysis entity systemUid',\n `analysis_entity_resourceuid` varchar(50) DEFAULT NULL COMMENT 'Analysis entity resourceUid',\n `_reference` varchar(100) DEFAULT NULL COMMENT 'Analysis reference',\n `owner_objecttype` varchar(250) DEFAULT NULL COMMENT 'Analysis owner objectType',\n `owner_systemuid` varchar(50) DEFAULT NULL COMMENT 'Analysis owner systemUid',\n `owner_resourceuid` varchar(50) DEFAULT NULL COMMENT 'Analysis owner resourceUid',\n `analysis_score_id` varchar(50) DEFAULT NULL COMMENT 'Analysis score',\n PRIMARY KEY (`id`),\n KEY `ANALYSIS_PROCESS_ASSESSMENT_CODE_FIX` (`assessment_code`),\n KEY `ANALYSIS_PROCESS_STATUS_CODE_FIX` (`status_code`),\n KEY `AN_PROCESS_ANALYSIS_SCORE_ID_FIX` (`analysis_score_id`),\n CONSTRAINT `analysis_process_analysis_score_id_fk` FOREIGN KEY (`analysis_score_id`) REFERENCES `analysis_analysis_score` (`id`),\n CONSTRAINT `analysis_process_assessment_code_fk` FOREIGN KEY (`assessment_code`) REFERENCES `analysis_assessment` (`id`),\n CONSTRAINT `analysis_process_status_code_fk` FOREIGN KEY (`status_code`) REFERENCES `analysis_analysis_process_status` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Analysis process'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-analysis\".\"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" : "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" : "analysis_data",
"jdbcType" : 12,
"typeName" : "LONGTEXT",
"typeExpression" : "LONGTEXT",
"charsetName" : "utf8",
"position" : 4,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "assessment_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" : "_daaq",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 6,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "/",
"enumValues" : [ ]
}, {
"name" : "_when_created",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 7,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_when_modified",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 8,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_who_created",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 9,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "_who_modified",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 10,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "analysis_entity_objecttype",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 250,
"position" : 11,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "analysis_entity_systemuid",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 12,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "analysis_entity_resourceuid",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 13,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "_reference",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 100,
"position" : 14,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "owner_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" : "owner_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" : "owner_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" : "analysis_score_id",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 18,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
} ],
"attributes" : [ ]
},
"comment" : null
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223595,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223595737,
"databaseName" : "odm-analysis",
"ddl" : "CREATE TABLE `analysis_rating` (\n `id` varchar(50) NOT NULL COMMENT 'Resource UID',\n `_business_data` json DEFAULT NULL COMMENT 'Business data',\n `process_id` varchar(50) DEFAULT NULL COMMENT 'Reverse attribute for analysisRatings',\n `decision` varchar(255) DEFAULT NULL COMMENT 'Analysis rating decision',\n `_comment` longtext COMMENT 'Comment',\n `_daaq` varchar(255) NOT NULL DEFAULT '/',\n `_when_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_when_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_who_created` varchar(255) NOT NULL,\n `_who_modified` varchar(255) NOT NULL,\n `_type` varchar(255) DEFAULT NULL COMMENT 'Type',\n `validity_from` date DEFAULT NULL COMMENT 'Rating date range from',\n `validity_until` date DEFAULT NULL COMMENT 'Rating date range until',\n `calculated_value` varchar(255) DEFAULT NULL COMMENT 'Analysis rating calculated value',\n `updated_value` varchar(255) DEFAULT NULL COMMENT 'Analysis rating updated value',\n PRIMARY KEY (`id`),\n KEY `ANALYSIS_RATING_PROCESS_ID_FIX` (`process_id`),\n CONSTRAINT `analysis_rating_process_id_fk` FOREIGN KEY (`process_id`) REFERENCES `analysis_process` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Analysis rating'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-analysis\".\"analysis_rating\"",
"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" : "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" : "decision",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 4,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "_comment",
"jdbcType" : 12,
"typeName" : "LONGTEXT",
"typeExpression" : "LONGTEXT",
"charsetName" : "utf8",
"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" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "/",
"enumValues" : [ ]
}, {
"name" : "_when_created",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 7,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_when_modified",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 8,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_who_created",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 9,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "_who_modified",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 10,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "_type",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 11,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "validity_from",
"jdbcType" : 91,
"typeName" : "DATE",
"typeExpression" : "DATE",
"charsetName" : null,
"position" : 12,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "validity_until",
"jdbcType" : 91,
"typeName" : "DATE",
"typeExpression" : "DATE",
"charsetName" : null,
"position" : 13,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "calculated_value",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 14,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "updated_value",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 15,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
} ],
"attributes" : [ ]
},
"comment" : null
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223595,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223595824,
"databaseName" : "odm-analysis",
"ddl" : "CREATE TABLE `analysis_ratio_category` (\n `id` varchar(50) NOT NULL COMMENT 'Resource UID',\n `_business_data` json DEFAULT NULL COMMENT 'Business data',\n `_daaq` varchar(255) NOT NULL DEFAULT '/',\n `_when_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_when_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_who_created` varchar(255) NOT NULL,\n `_who_modified` varchar(255) NOT NULL,\n PRIMARY KEY (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ratio category'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-analysis\".\"analysis_ratio_category\"",
"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" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "/",
"enumValues" : [ ]
}, {
"name" : "_when_created",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 4,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_when_modified",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 5,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_who_created",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 6,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "_who_modified",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 7,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
} ],
"attributes" : [ ]
},
"comment" : null
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223595,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223595885,
"databaseName" : "odm-analysis",
"ddl" : "CREATE TABLE `analysis_ratio_evaluation` (\n `id` varchar(50) NOT NULL COMMENT 'Resource UID',\n `_business_data` json DEFAULT NULL COMMENT 'Business data',\n `_value` varchar(255) DEFAULT NULL COMMENT 'Ratio evaluation value',\n `analysis_ratio_id` varchar(50) DEFAULT NULL COMMENT 'Reverse attribute for ratioEvaluations',\n `_type` varchar(255) DEFAULT NULL COMMENT 'Evaluation type',\n `decision` varchar(255) DEFAULT NULL COMMENT 'Evaluation decision',\n `_comment` longtext COMMENT 'Comment',\n `_daaq` varchar(255) NOT NULL DEFAULT '/',\n `_when_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_when_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_who_created` varchar(255) NOT NULL,\n `_who_modified` varchar(255) NOT NULL,\n PRIMARY KEY (`id`),\n KEY `ANALYSIS_RATIO_EVALUATION_ANALYSIS_RATIO_ID_IX` (`analysis_ratio_id`),\n CONSTRAINT `analysis_ratio_evaluation_analysis_ratio_id_fk` FOREIGN KEY (`analysis_ratio_id`) REFERENCES `analysis_ratio_value` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ratio evaluation'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-analysis\".\"analysis_ratio_evaluation\"",
"table" : {
"defaultCharsetName" : "utf8",
"primaryKeyColumnNames" : [ "id" ],
"columns" : [ {
"name" : "id",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 1,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "_business_data",
"jdbcType" : 1111,
"typeName" : "JSON",
"typeExpression" : "JSON",
"charsetName" : null,
"position" : 2,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "_value",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 3,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "analysis_ratio_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" : "_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" : "decision",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 6,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "_comment",
"jdbcType" : 12,
"typeName" : "LONGTEXT",
"typeExpression" : "LONGTEXT",
"charsetName" : "utf8",
"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" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "/",
"enumValues" : [ ]
}, {
"name" : "_when_created",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 9,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_when_modified",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 10,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_who_created",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 11,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "_who_modified",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 12,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
} ],
"attributes" : [ ]
},
"comment" : null
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223595,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223596046,
"databaseName" : "odm-analysis",
"ddl" : "CREATE TABLE `analysis_ratio_param` (\n `_discriminator` varchar(50) DEFAULT NULL COMMENT 'Polymorphic discriminator',\n `id` varchar(50) NOT NULL COMMENT 'Resource UID',\n `_business_data` json DEFAULT NULL COMMENT 'Business data',\n `data_formula` varchar(255) DEFAULT NULL COMMENT 'Data formula qualification',\n `data_external_service` varchar(255) DEFAULT NULL COMMENT 'Data external service qualification',\n `ratio_eval_rule_engine` varchar(50) DEFAULT NULL COMMENT 'Analysis ratio business rules from',\n `ratio_eval_rule_rule` json DEFAULT NULL COMMENT 'Analysis ratio business rules until',\n `data_internal_service` varchar(255) DEFAULT NULL COMMENT 'Data internal service qualification',\n `data_info` varchar(255) DEFAULT NULL COMMENT 'Data info qualification',\n `assessment_id` varchar(50) DEFAULT NULL COMMENT 'Reverse attribute for ratioParams',\n `ratio_qualification_rule_engine` varchar(50) DEFAULT NULL COMMENT 'Ratio qualification rule from',\n `ratio_qualification_rule_rule` json DEFAULT NULL COMMENT 'Ratio qualification rule until',\n `_daaq` varchar(255) NOT NULL DEFAULT '/',\n `_when_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_when_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_who_created` varchar(255) NOT NULL,\n `_who_modified` varchar(255) NOT NULL,\n `type_code` varchar(50) DEFAULT NULL COMMENT 'Ratio type',\n `_name` varchar(255) DEFAULT NULL COMMENT 'Ratio label',\n `data_business_rule_engine` varchar(50) DEFAULT NULL COMMENT 'Ratio qualification rule from',\n `data_business_rule_rule` json DEFAULT NULL COMMENT 'Ratio qualification rule until',\n `only_for_calculation` tinyint(3) DEFAULT NULL COMMENT 'Ratio used only for calculation',\n `category_code` varchar(50) DEFAULT NULL COMMENT 'Ratio category',\n PRIMARY KEY (`id`),\n KEY `ANALYSIS_RATIO_PARAM_ASSESSMENT_ID_FIX` (`assessment_id`),\n KEY `AN_RATIO_PARAM_TYPE_CODE_FIX` (`type_code`),\n KEY `AN_RATIO_PARAM_CATEGORY_CODE_FIX` (`category_code`),\n CONSTRAINT `analysis_ratio_param_assessment_id_fk` FOREIGN KEY (`assessment_id`) REFERENCES `analysis_assessment` (`id`),\n CONSTRAINT `analysis_ratio_param_category_code_fk` FOREIGN KEY (`category_code`) REFERENCES `analysis_ratio_category` (`id`),\n CONSTRAINT `analysis_ratio_param_type_code_fk` FOREIGN KEY (`type_code`) REFERENCES `analysis_ratio_param_type` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Analysis ratio param'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-analysis\".\"analysis_ratio_param\"",
"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" : "data_formula",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 4,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "data_external_service",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 5,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "ratio_eval_rule_engine",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 6,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "ratio_eval_rule_rule",
"jdbcType" : 1111,
"typeName" : "JSON",
"typeExpression" : "JSON",
"charsetName" : null,
"position" : 7,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "data_internal_service",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 8,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "data_info",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 9,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "assessment_id",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 10,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "ratio_qualification_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" : "ratio_qualification_rule_rule",
"jdbcType" : 1111,
"typeName" : "JSON",
"typeExpression" : "JSON",
"charsetName" : null,
"position" : 12,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "_daaq",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 13,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "/",
"enumValues" : [ ]
}, {
"name" : "_when_created",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 14,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_when_modified",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 15,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_who_created",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 16,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "_who_modified",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 17,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "type_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" : "_name",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 19,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "data_business_rule_engine",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 20,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "data_business_rule_rule",
"jdbcType" : 1111,
"typeName" : "JSON",
"typeExpression" : "JSON",
"charsetName" : null,
"position" : 21,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "only_for_calculation",
"jdbcType" : 5,
"typeName" : "TINYINT",
"typeExpression" : "TINYINT",
"charsetName" : null,
"length" : 3,
"position" : 22,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "category_code",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 23,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
} ],
"attributes" : [ ]
},
"comment" : null
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223596,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223596135,
"databaseName" : "odm-analysis",
"ddl" : "CREATE TABLE `analysis_ratio_param_type` (\n `id` varchar(50) NOT NULL COMMENT 'Resource UID',\n `default_value` tinyint(3) DEFAULT NULL COMMENT 'Default value for the associated enum',\n `label` varchar(255) DEFAULT NULL COMMENT 'Label for the associated enum',\n `internal_code` varchar(50) DEFAULT NULL COMMENT 'Associated enum value',\n `_business_data` json DEFAULT NULL COMMENT 'Business data',\n `_daaq` varchar(255) NOT NULL DEFAULT '/',\n `_when_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_when_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_who_created` varchar(255) NOT NULL,\n `_who_modified` varchar(255) NOT NULL,\n PRIMARY KEY (`id`),\n KEY `AN_RATIO_PARAM_TYPE_INTERNAL_CODE_IX` (`internal_code`,`default_value`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Ratio param type'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-analysis\".\"analysis_ratio_param_type\"",
"table" : {
"defaultCharsetName" : "utf8",
"primaryKeyColumnNames" : [ "id" ],
"columns" : [ {
"name" : "id",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 1,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "default_value",
"jdbcType" : 5,
"typeName" : "TINYINT",
"typeExpression" : "TINYINT",
"charsetName" : null,
"length" : 3,
"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" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "/",
"enumValues" : [ ]
}, {
"name" : "_when_created",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 7,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_when_modified",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 8,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_who_created",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 9,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "_who_modified",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 10,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
} ],
"attributes" : [ ]
},
"comment" : null
} ]
}
{
"source" : {
"server" : "odm_analysis"
},
"position" : {
"ts_sec" : 1733223596,
"file" : "mysql-bin.000003",
"pos" : 136843096,
"snapshot" : true
},
"ts_ms" : 1733223596200,
"databaseName" : "odm-analysis",
"ddl" : "CREATE TABLE `analysis_ratio_value` (\n `id` varchar(50) NOT NULL COMMENT 'Resource UID',\n `_business_data` json DEFAULT NULL COMMENT 'Business data',\n `_value` varchar(255) DEFAULT NULL COMMENT 'Ratio value',\n `ratio_param_code` varchar(50) DEFAULT NULL COMMENT 'Analysis ratio param',\n `process_id` varchar(50) DEFAULT NULL COMMENT 'Reverse attribute for ratios',\n `_daaq` varchar(255) NOT NULL DEFAULT '/',\n `_when_created` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_when_modified` timestamp NULL DEFAULT CURRENT_TIMESTAMP,\n `_who_created` varchar(255) NOT NULL,\n `_who_modified` varchar(255) NOT NULL,\n PRIMARY KEY (`id`),\n KEY `ANALYSIS_RATIO_VALUE_PROCESS_ID_IX` (`process_id`),\n KEY `ANALYSIS_RATIO_VALUE_RATIO_PARAM_CODE_FIX` (`ratio_param_code`),\n CONSTRAINT `analysis_ratio_value_process_id_fk` FOREIGN KEY (`process_id`) REFERENCES `analysis_process` (`id`),\n CONSTRAINT `analysis_ratio_value_ratio_param_code_fk` FOREIGN KEY (`ratio_param_code`) REFERENCES `analysis_ratio_param` (`id`)\n) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Analysis ratio value'",
"tableChanges" : [ {
"type" : "CREATE",
"id" : "\"odm-analysis\".\"analysis_ratio_value\"",
"table" : {
"defaultCharsetName" : "utf8",
"primaryKeyColumnNames" : [ "id" ],
"columns" : [ {
"name" : "id",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 1,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "_business_data",
"jdbcType" : 1111,
"typeName" : "JSON",
"typeExpression" : "JSON",
"charsetName" : null,
"position" : 2,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "_value",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 3,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "ratio_param_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" : "process_id",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 50,
"position" : 5,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"enumValues" : [ ]
}, {
"name" : "_daaq",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 6,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "/",
"enumValues" : [ ]
}, {
"name" : "_when_created",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 7,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_when_modified",
"jdbcType" : 2014,
"typeName" : "TIMESTAMP",
"typeExpression" : "TIMESTAMP",
"charsetName" : null,
"position" : 8,
"optional" : true,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : true,
"defaultValueExpression" : "1970-01-01 00:00:00",
"enumValues" : [ ]
}, {
"name" : "_who_created",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 9,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
}, {
"name" : "_who_modified",
"jdbcType" : 12,
"typeName" : "VARCHAR",
"typeExpression" : "VARCHAR",
"charsetName" : "utf8",
"length" : 255,
"position" : 10,
"optional" : false,
"autoIncremented" : false,
"generated" : false,
"comment" : null,
"hasDefaultValue" : false,
"enumValues" : [ ]
} ],
"attributes" : [ ]
},
"comment" : null
} ]
}