cnbg-be/doc/db/24wm_pkg_rdp.sql

USE `cnbg_20240511_001`;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for wm_pkg_rdp
-- ----------------------------
DROP TABLE IF EXISTS `wm_pkg_rdp`;
CREATE TABLE `wm_pkg_rdp`
(
    `rdp_id`      BIGINT UNSIGNED AUTO_INCREMENT     NOT NULL COMMENT '主键ID',
    `pkg_id`      BIGINT UNSIGNED                    NOT NULL COMMENT '包ID',
    `rdp_res`     JSON                               NULL COMMENT '兑付结果',
    `act_mark`    INT UNSIGNED                       NOT NULL COMMENT '实际得分',
    `total_mark`  INT UNSIGNED                       NOT NULL COMMENT '满分',
    `create_by`   VARCHAR(32)                        NOT NULL COMMENT '创建人',
    `update_by`   VARCHAR(32)                        NOT NULL COMMENT '更新人',
    `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP NOT NULL COMMENT '创建时间',
    `update_time` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE NOT NULL COMMENT '更新时间',
    PRIMARY KEY `pk_id` (`rdp_id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4
  COLLATE = utf8mb4_general_ci
  ROW_FORMAT = DYNAMIC COMMENT ='执行包兑付凭证';


-- ----------------------------
-- Records of wm_pkg_rdp
-- ----------------------------
BEGIN;
COMMIT;


SET FOREIGN_KEY_CHECKS = 1;