这里要问的问题是，您是希望能够按单位订购，还是通过混合在一起的单个商品编号订购。

您是否需要记录订购的单位，或者您只是使用它们来快速输入订单，并且只保存项目总数？


看起来你要么需要一张桌子with：


UnitNumber - text，PK

CrossArmCount - 整数

InsulatorCount - 整数

PinCount - 整数

OtherPartCount - 所有部分的整数

等

The question to ask here is whether you want to be able to order by unit only, or also by individual item number mixed together.
Do you need to record the units ordered, or can you just use them to quickly enter orders, and save only the item totals?

It seems like either way you will need a table with:

UnitNumber - text, PK
CrossArmCount - integer
InsulatorCount - integer
PinCount - integer
OtherPartCount - integer
etc. for all parts

您好，ChipR。


表格可以更加规范化。 ...恕我直言


亲切问候，

鱼

Hi, ChipR.

The table could be "more normalized". ... IMHO

Kind regards,
Fish

他们可以选择订购按部件号其中该订单中的所有项目均按部件号进行，然后单独选择按单位排序。其中该订单中的所有项目均按单位编号完成。只要两个不同的订单仍然可以链接回项目。例如，执行计量部分的人可能想按订单号订购他的东西，其中构建生产线的人想要按单位订购。

They are okay with having the option of "order by part number" where all items within that order are by part number and then a separate option of "order by unit" where all items within that order are done by unit number. As long as the two different orders can still be linked back to the project. For instance, the guy who does the metering portion may want to order his stuff by order number, where the guys who build the line would want to order by unit.