Point of Sale system for Lucarelli's Pizza. Mobile Android companion.
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.