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