pay_wallet.sql 5.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475
  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. `freeze_price` int NOT NULL DEFAULT 0 COMMENT '冻结金额,单位分',
  14. `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  15. `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  16. `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  17. `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  18. `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  19. `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  20. PRIMARY KEY (`id`) USING BTREE
  21. ) ENGINE=InnoDB COMMENT='会员钱包表';
  22. -- ----------------------------
  23. -- 会员钱包流水表
  24. -- ----------------------------
  25. DROP TABLE IF EXISTS `pay_wallet_transaction`;
  26. CREATE TABLE `pay_wallet_transaction`
  27. (
  28. `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  29. `wallet_id` bigint NOT NULL COMMENT '会员钱包 id',
  30. `biz_type` tinyint NOT NULL COMMENT '关联类型',
  31. `biz_id` varchar(64) NOT NULL COMMENT '关联业务编号',
  32. `no` varchar(64) NOT NULL COMMENT '流水号',
  33. `title` varchar(128) NOT NULL COMMENT '流水标题',
  34. `price` int NOT NULL COMMENT '交易金额, 单位分',
  35. `balance` int NOT NULL COMMENT '余额, 单位分',
  36. `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  37. `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  38. `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  39. `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  40. `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  41. `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  42. PRIMARY KEY (`id`) USING BTREE
  43. ) ENGINE=InnoDB COMMENT='会员钱包流水表';
  44. -- ----------------------------
  45. -- 会员钱包充值
  46. -- ----------------------------
  47. DROP TABLE IF EXISTS `pay_wallet_recharge`;
  48. CREATE TABLE `pay_wallet_recharge`
  49. (
  50. `id` bigint NOT NULL AUTO_INCREMENT COMMENT '编号',
  51. `wallet_id` bigint NOT NULL COMMENT '会员钱包 id',
  52. `total_price` int NOT NULL COMMENT '用户实际到账余额,例如充 100 送 20,则该值是 120',
  53. `pay_price` int NOT NULL COMMENT '实际支付金额',
  54. `bonus_price` int NOT NULL COMMENT '钱包赠送金额',
  55. `pay_status` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否已支付:[0:未支付 1:已经支付过]',
  56. `pay_order_id` bigint NULL COMMENT '支付订单编号',
  57. `pay_channel_code` varchar(16) NULL COMMENT '支付成功的支付渠道',
  58. `pay_time` datetime NULL COMMENT '订单支付时间',
  59. `pay_refund_id` bigint NULL COMMENT '支付退款单编号',
  60. `refund_total_price` int NOT NULL DEFAULT 0 COMMENT '退款金额,包含赠送金额',
  61. `refund_pay_price` int NOT NULL DEFAULT 0 COMMENT '退款支付金额',
  62. `refund_bonus_price` int NOT NULL DEFAULT 0 COMMENT '退款钱包赠送金额',
  63. `refund_time` datetime NULL COMMENT '退款时间',
  64. `refund_status` int NOT NULL DEFAULT 0 COMMENT '退款状态',
  65. `creator` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '创建者',
  66. `create_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  67. `updater` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT '' COMMENT '更新者',
  68. `update_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  69. `deleted` bit(1) NOT NULL DEFAULT b'0' COMMENT '是否删除',
  70. `tenant_id` bigint NOT NULL DEFAULT 0 COMMENT '租户编号',
  71. PRIMARY KEY (`id`) USING BTREE
  72. ) ENGINE=InnoDB COMMENT='会员钱包充值';