webchat-payment.sql 2.3 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344
  1. -- 红包信息表
  2. CREATE TABLE webchat_payment.`web_chat_red_packet` (
  3. `ID` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  4. `send_user_id` char(100) NOT NULL COMMENT '红包发送人',
  5. `receiver_user_id` char(100) NOT NULL COMMENT '接受人',
  6. `type` int(4) NOT NULL COMMENT '消息类型',
  7. `count` int(4) NOT NULL COMMENT '红包个数',
  8. `status` int(4) NOT NULL COMMENT '状态',
  9. `total_money` DECIMAL(10, 2) default '0.00' COMMENT '金额',
  10. `CREATE_BY` char(100) DEFAULT NULL COMMENT '创建人',
  11. `CREATE_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  12. `expire_date` datetime NOT NULL COMMENT '过期时间',
  13. `UPDATE_BY` char(100) DEFAULT NULL COMMENT '更新人',
  14. `UPDATE_DATE` datetime DEFAULT NULL COMMENT '更新时间',
  15. `VERSION` int DEFAULT '0' COMMENT '版本',
  16. PRIMARY KEY (`ID`),
  17. KEY `INDEX_SEND_USER_ID` (`send_user_id`),
  18. KEY `INDEX_STATUS_EXPIRE_DATE` (`status`, `expire_date`)
  19. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='红包信息表';
  20. -- 红包拆分记录明细表
  21. CREATE TABLE webchat_payment.`web_chat_red_packet_record` (
  22. `ID` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  23. `red_packet_id` bigint NOT NULL COMMENT '红包id',
  24. `user_id` char(100) NOT NULL COMMENT '领取人',
  25. `money` DECIMAL(10, 2) default '0.00' COMMENT '领取金额',
  26. `CREATE_DATE` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  27. PRIMARY KEY (`ID`),
  28. KEY `INDEX_RED_PACKET_ID` (`red_packet_id`),
  29. KEY `INDEX_USER_ID` (`user_id`)
  30. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='红包拆分记录明细表';
  31. -- 用户钱包
  32. CREATE TABLE webchat_payment.`web_chat_user_wallet` (
  33. `ID` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  34. `trans_event` int(4) NOT NULL COMMENT '事件类型',
  35. `trans_type` int(4) NOT NULL COMMENT '收入/支出',
  36. `user_id` char(100) NOT NULL COMMENT '用户id',
  37. `target_user_id` char(100) NOT NULL COMMENT '目标用户',
  38. `money` DECIMAL(10, 2) default '0.00' COMMENT '流转金额',
  39. `trans_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '流转时间',
  40. PRIMARY KEY (`ID`),
  41. KEY `INDEX_USER_ID` (`user_id`)
  42. ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='用户钱包';