There are 5 sets of tables.
We followed self-explanatory names for tables and their fields.
- Menu and Food Master database
- Restaurant & Terminal Configuration
- Ticket and Cash drawer management
- Transaction and Payment Records
- Daily Activity and transaction logs
Manually Accessing Database
For database modelling we use RazorSQL (Thanks RazorSQL for providing us a complementary copy). If you are a developer you may sneak peek database tables in the following steps