PizzaPOS

Point of Sale system for Lucarelli's Pizza. Mobile Android companion.

Database

Pizza POS uses SQLite database engine for storing orders.

Database Structure:

There are two tables in the Orders database:

Create Table Orders (
	order_num int,
	open_date text,
	is_open int -- Effectively boolean
);

Create Table Items (
	order_num int,
	itemName text,
	price double,
	comments text,
	extras text
);

The DBHelper class conducts all database operations and including database methods and queries. The Order class contains getters and setters for the Orders table. The Item class contains getters and setters for the Item table.