17sys_chain_gateway.sql 1.1 KB

123456789101112131415161718192021222324252627
  1. USE `cnbg_20240511_001`;
  2. SET NAMES utf8mb4;
  3. SET FOREIGN_KEY_CHECKS = 0;
  4. -- ----------------------------
  5. -- Table structure for sys_chain_gateway
  6. -- ----------------------------
  7. DROP TABLE IF EXISTS `sys_chain_gateway`;
  8. CREATE TABLE `sys_chain_gateway`
  9. (
  10. `gateway_id` BIGINT AUTO_INCREMENT COMMENT 'Id',
  11. `gateway_type` VARCHAR(32) NOT NULL COMMENT '网关类型',
  12. `rule_type` VARCHAR(32) NOT NULL COMMENT '规则类型',
  13. `pre_node_id` BIGINT NULL COMMENT '上游节点',
  14. `next_node_id` BIGINT NULL COMMENT '下游游节点',
  15. `del_flag` VARCHAR(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
  16. `create_by` VARCHAR(64) NOT NULL DEFAULT 'admin' COMMENT '创建人',
  17. `update_by` VARCHAR(64) NOT NULL DEFAULT 'admin' COMMENT '修改人',
  18. `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  19. `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  20. PRIMARY KEY `pk_id` (`gateway_id`) USING BTREE
  21. ) ENGINE = InnoDB
  22. COMMENT ='审批链网关';
  23. SET FOREIGN_KEY_CHECKS = 1;