there are two table-building schemes that I have come up with:
first:
order_id order id
shop_id merchant id
goods_id goods id
.
this way is to write all kinds of id in the order table and associate them when needed.
second:
order_id order id
shop_name merchant name
goods_name purchased item name
price unit price
total total price
.
this method is like a handwritten ledger, which writes the account data directly in the table.
what are the advantages and disadvantages of these two? In general, how should the order form be designed?