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)

Database fields

See also