做一个简单的交易平台,用户A上传某商品信息,用户B选择商品后,通过支付宝或者微信将钱支付到平台。用户B收到东西后,确认收货,然后钱会到用户A的余额中。用户A可提现到自己的银行卡。或者平台给他转账到支付宝。如果用户A没有发货,钱会退回用户B的余额,用户B通过提现或者平台转账来把钱取出来。
从订单生成到交易完毕,再到用户A提现,这中间都需要记录哪些数据呢?比如,用户的流水信息之类的。
麻烦解答详细一些,不胜感激。
走同样的路,发现不同的人生
There are two types of users here, one is an ordinary user and the other is a merchant. They are probably: product table, miscellaneous product table, order table, which can be partitioned by month. User table, merchant table, user log, merchant log
There are two types of users here, one is an ordinary user and the other is a merchant. They are probably: product table, miscellaneous product table, order table, which can be partitioned by month. User table, merchant table, user log, merchant log