Back
/*
Table: shelftags
Columns:
id int
upc int or varchar, dbms dependent
description varchar
normal_price dbms currency
brand varchar
sku varchar
size varchar
units int
vendor varchar
pricePerUnit varchar
count int
Depends on:
none
Use:
Data for generating shelf tag PDFs. id is used
to segment sets into different PDF documents.
An id maps to a buyer at WFC, but doesn't have to.
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.
Count is used to print multiples of the same tag
*/
Back