spdm-backend/flowable/sql/process_node_param.sql

CREATE TABLE `flowable`.`process_node_param`
(
    `id`                  bigint   NOT NULL AUTO_INCREMENT,
    `processDefinitionId` varchar(64)       DEFAULT NULL COMMENT '流程定义ID',
    `processInstanceId` varchar(64)       DEFAULT NULL COMMENT '流程实例ID',
    `nodeId`              varchar(64)       DEFAULT NULL COMMENT '节点ID',
    `paramJson`           text COMMENT '输入参数JSON',
    `createTime`          datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `updateTime`          datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `uk_processInstanceId_nodeId` (`processInstanceId`,`nodeId`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='流程节点输入参数表';