用户表:user id:1 | name:xiaowang | iphone:17734343434 | record:[{name:P33},{name:U590}] id:2 | name:zhangshan | iphone:18734231231| | record:[{name:U590}] 商品表:goods id:1 | name:P33 |pice:150 id:2 | name:U590 |pice:350 订单表:order id:1 | name:xiaowang | record:[{name:P33},{name:U590}] id:2 | name:zhangshan | record:[{name:U590}]
如有5000个用户,每个用户购买不同的商品
问:每个用户购买的商品数据放在user表record字段里好,还是单独放在order表里?
订单表加个用户ID,完事了。