pay_wallet.sql 2.7 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. -- ----------------------------
  2. -- 会员钱包表
  3. -- ----------------------------
  4. DROP TABLE IF EXISTS `pay_wallet`;
  5. CREATE TABLE `pay_wallet`
  6. (
  7. `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  8. `user_id` bigint NOT NULL COMMENT '用户编号',
  9. `user_type` tinyint NOT NULL DEFAULT 0 COMMENT '用户类型',
  10. `balance` int NOT NULL DEFAULT 0 COMMENT '余额,单位分',
  11. `total_expense` int NOT NULL DEFAULT 0 COMMENT '累计支出,单位分',
  12. `total_recharge` int NOT NULL DEFAULT 0 COMMENT '累计充值,单位分',
  13. `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  14. `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  15. `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  16. `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  17. `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  18. `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  19. PRIMARY KEY (`id`) USING BTREE
  20. ) ENGINE=InnoDB COMMENT='会员钱包表';
  21. -- ----------------------------
  22. -- 会员钱包流水表
  23. -- ----------------------------
  24. DROP TABLE IF EXISTS `pay_wallet_transaction`;
  25. CREATE TABLE `pay_wallet_transaction`
  26. (
  27. `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  28. `wallet_id` bigint NOT NULL COMMENT '会员钱包 id',
  29. `biz_type` tinyint NOT NULL COMMENT '关联类型',
  30. `biz_id` varchar(64) NOT NULL COMMENT '关联业务编号',
  31. `no` varchar(64) NOT NULL COMMENT '流水号',
  32. `title` varchar(128) NOT NULL COMMENT '流水标题',
  33. `price` int NOT NULL COMMENT '交易金额, 单位分',
  34. `balance` int NOT NULL COMMENT '余额, 单位分',
  35. `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  36. `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  37. `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  38. `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  39. `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  40. `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  41. PRIMARY KEY (`id`) USING BTREE
  42. ) ENGINE=InnoDB COMMENT='会员钱包流水表';