6sys_impl_plan.sql 2.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849
  1. USE `cnbg_20240511_001`;
  2. SET NAMES utf8mb4;
  3. SET FOREIGN_KEY_CHECKS = 0;
  4. -- ----------------------------
  5. -- Table structure for sys_impl_plan
  6. -- ----------------------------
  7. DROP TABLE IF EXISTS `sys_impl_plan`;
  8. CREATE TABLE `sys_impl_plan`
  9. (
  10. `plan_id` BIGINT AUTO_INCREMENT COMMENT '主键ID',
  11. `plan_name` VARCHAR(64) NOT NULL COMMENT '计划名称',
  12. `plan_type` VARCHAR(32) NOT NULL COMMENT '计划类型',
  13. `plan_state` VARCHAR(32) NOT NULL COMMENT '计划类型',
  14. `plan_score` BIGINT NOT NULL DEFAULT 0 COMMENT '计划值',
  15. `avail_score` BIGINT NOT NULL DEFAULT 0 COMMENT '可用值',
  16. `plan_issue` DATE NOT NULL COMMENT '签发时间',
  17. `plan_expiry` DATE NOT NULL COMMENT '截止日期',
  18. `parent_id` BIGINT NOT NULL COMMENT '父ID',
  19. `consignor_id` BIGINT NOT NULL COMMENT '委托人ID',
  20. `consignee_id` BIGINT NOT NULL COMMENT '受托人ID',
  21. `sku_id` BIGINT NOT NULL COMMENT '产品ID',
  22. `ckt_res` TINYINT(1) NULL COMMENT '审核结果',
  23. `ckt_msg` VARCHAR(255) NULL COMMENT '审核意见',
  24. `ckt_time` DATETIME NULL COMMENT '审核时间',
  25. `ckt_name` VARCHAR(64) NULL COMMENT '审核人用户名',
  26. `loc_flag` VARCHAR(1) NOT NULL COMMENT '锁定标记',
  27. `del_flag` VARCHAR(1) NOT NULL DEFAULT '0' COMMENT '删除标记',
  28. `create_by` VARCHAR(64) NOT NULL COMMENT '创建人',
  29. `update_by` VARCHAR(64) NOT NULL COMMENT '修改人',
  30. `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  31. `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
  32. PRIMARY KEY `pk_id` (`plan_id`),
  33. UNIQUE KEY `uk_name` (`plan_name`, `consignor_id`)
  34. ) ENGINE = InnoDB
  35. DEFAULT CHARSET = utf8mb4
  36. COLLATE = utf8mb4_general_ci
  37. ROW_FORMAT = DYNAMIC COMMENT ='执行计划';
  38. -- ----------------------------
  39. -- Records of sys_impl_plan
  40. -- ----------------------------
  41. BEGIN;
  42. COMMIT;
  43. SET FOREIGN_KEY_CHECKS = 1;