Shop Til You Drop manual - Database fields

Shop 'Til You Drop stores data in a relational database. This consists of several separate tables (files) within the database folder which are linked together by common fields.

Field types

String - Text field
Integer - 32-bit integer field; whole numbers in the range -2147483648 to 2147483647
Decimal - Floating-point numeric field; -10E307 to 10E308 with 15 significant digits

Table name	Field name	Type	Links / Notes
Items	ItemID	Integer
	Product	Integer	Products \| ProdID
	Brand	String (50)
	Size	Integer
	Price	Decimal	Limited to 2 decimal places
	Shop	Integer	Shops \| ShopID
	Quantity	Integer
	UndoQty	Integer	Saves Quantity for undo optimization
Products	ProdID	Integer
	ProdName	String (50)
	UnitOfMeasure	String (10)
	Category	Integer	Categories \| CatID
Categories	CatID	Integer
Categories	CatName	String (50)
Aisles	Category	Integer	Categories \| CatID
	Shop	Integer	Shops \| ShopID
	Sequence	Decimal
	RectLeft	Integer
	RectTop	Integer
	RectRight	Integer
	RectBottom	Integer
Shops	ShopID	Integer
	ShopName	String (50)
	Address	String (100)
	Phone	String (20)

Download shopping software here. We specialize in free to try grocery shopping software available for download. You can download the best shopping software for supermarkets. Software for your groceries. Download shopping program for supermarket shopping. Free 30-day trial. Print grocery shopping lists using our free to try shopping software. Download the best shopping list software, free trial, to print your groceries list. Our supermarket software prints shopping lists. Supermarket software prints shopping lists. Download supermarket shopping software for grocery lists.

Database fields

See also