通过条形码唯一标识产品 [英] Uniquely Identifies the Product by Barcode

问题描述

先生，我需要帮助

我对如何使用条形码唯一标识产品有疑问.我在哪里将条形码ID放在表格中.
我有一个产品表，类别表，价格表，订单明细表.

产品表
prodID
名称
Desc
CategoryID
ReorderLevel

类别表
CategoryID
名称

订单明细表
O.DetailsID
prodID
OrderID
单价
数量

价格表
PriceID
ProdID
售价

Sir, I need help

I have a problem on how to uniquely identify the product using barcode. Where tables do I put the barcodeId.
I have a product table, category table, price table, order details table.

Product table
prodID
Name
Desc
CategoryID
ReorderLevel

Category Table
CategoryID
Name

Order Details Table
O.DetailsID
prodID
OrderID
UnitPrice
Quantity

Price Table
PriceID
ProdID
Selling Price

推荐答案

条形码(通常)返回的ArticleNumber-最多15位数字，可唯一标识特定的品牌，型号和尺寸单位:因此，每100克糖果的包装将具有与200克相同糖果的包装不同的商品编号(并因此具有条形码)，或者每盒包含20罐100克糖果的包装盒.

因此，将其放置在产品"表中的唯一明智的位置-它必须反映该产品，并且不能在全球范围内用于任何其他产品(即使您已停止使用原始产品).在大多数公司中，有相当严格的法律规定有关号码及其处理方式，主要是出于保护消费者的目的.

A barcode (normally) returns the ArticleNumber - which is a up-to-15-digit number which uniquely identifies a specific make, model, and size of unit: so a 100g tube of sweeties will have a different Article Number (and thus barcode) to a 200g tube of teh same sweeties, or a box containing 20 tubes of 100g of sweeties.

So the only sensible place to put it is in the Product table - it must reflect the product, and cannot be used for any other product, worldwide (even if you have discontinued the original). There are pretty strict laws in most companies about there numbers and how they are to be handled, mostly for consumer protection purposes.

这篇关于通过条形码唯一标识产品的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！