UNIDIA206/db/algorithm_scheduling.sql

/*
 Navicat Premium Dump SQL

 Source Server         : 国航
 Source Server Type    : MySQL
 Source Server Version : 80030 (8.0.30-commercial)
 Source Host           : 10.211.67.169:3306
 Source Schema         : UNIDIA

 Target Server Type    : MySQL
 Target Server Version : 80030 (8.0.30-commercial)
 File Encoding         : 65001

 Date: 18/06/2025 07:58:27
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for algorithm_scheduling
-- ----------------------------
DROP TABLE IF EXISTS `algorithm_scheduling`;
CREATE TABLE `algorithm_scheduling`  (
  `algorithm_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '算法编号',
  `algorithm_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '算法名称',
  `service_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL COMMENT '所属服务编号',
  `execution_order` int NOT NULL COMMENT '执行顺序',
  `file_path` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '文件路径',
  `class_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '方法类名',
  `method_name` varchar(2048) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '方法名称',
  `input_data_template` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '入参模板',
  `result_save_type` int NULL DEFAULT NULL COMMENT '结果存储类型',
  `preconditions` varchar(1024) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '是否执行的前置条件',
  `preconditions_param_template` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '前置执行条件参数模板',
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL COMMENT '算法描述',
  PRIMARY KEY (`algorithm_code`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci ROW_FORMAT = Dynamic;

SET FOREIGN_KEY_CHECKS = 1;