我有一项维护ITEMS库存的任务 [英] I have a task to maintain ITEMS stock

问题描述

物品来自零件和盒子.

例如，假设，

我已购买100片(片剂)的 medicineX .
我购买了一个包含50个 medicineY 的盒子.

现在，物品只能按部分配.

表示 MedicineX 将根据客户的需求量提供给他们一，二或五件.

与 MedicineY 相同，我将打开50片药品的包装盒，并按客户要求的2、5片等方式给予客户...等

现在，我需要在SQL Server数据库中有一个表.

我对我将要创建的表中的字段内容感到困惑.请帮助...谢谢……

Items are comes in Piece and Boxes.

e.g Suppose,

I have purchase 100 piece (tablet) of medicineX.
I have purchase one Box which contain 50 medicineY.

Now item dispense by piece wise only.

Means MedicineX will be given to customer by how much piece they demands one or two or five as per their demands.

Same for MedicineY, I will open the Box of 50 medicine and will give to customer as they demands means 2 , 5 Piece, …etc

Now I required to have a Table in SQL-Server Database.

I have confusion in what are the field should be in table I will create. Please help…thanks……

推荐答案

您至少需要两个字段.一个将存储药品名称(使用varchar)，而另一个字段将不包含.物品的数量(使用int或Bigint)，无论物品是装在盒子中还是装在盒子中.如果物品是装在盒子中，则只需将所有物品都放入盒子中即可.就是这样.

You should need two fields at minimum. One will store medicine name (use varchar)and other field will contain no. of pieces(use int or Bigint) regardless of whether the items come in piece or box.If the items come in box, then just add all the pieces in the box. That''s it.

这篇关于我有一项维护ITEMS库存的任务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！