用户表: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,完事了。