Back
/*
Table: batchBarcodes
Columns:
upc bigint or varchar, dbms dependent
description varchar(30)
normal_price dbms currency
brand varchar(50)
sku varchar(14)
size varchar(50)
units varchar(15)
vendor varchar(50)
batchID int
Depends on:
batches (table)
Use:
This table has information for generating shelf tags
for a batch. This makes sense primarily when working
with batches that update items' regular price rather
than sale batches.
Note: size relates to an indivdual product.
Units relates to a case. So a case of beer has 24
units, each with a size of 12 oz.
*/
Back