
1-4
The 3700 System Database
Introducing the Database
select * from micros.mi_def
POS Configurator makes it easy for you to access and modify
the tables necessary for programming a database. You don’t
need to know SQL to use POS Configurator.
You do not need to program every table in the database to
configure a 3700 system. POS Configurator gives you access
only to those tables and fields necessary for configuring POS
operations and installed hardware.
Database Tables
A database consists of many tables. Each table in a relational
database holds a specific set of information about a restaurant.
When the system performs a transaction, it accesses the
database tables to obtain the information. For instance, menu
item names reside in the Menu Item Definition table, while
menu item prices reside in the Menu Item Price Definition
table. In the 3700 system, one menu item definition (name) can
be associated with several different prices (Bar, Restaurant, and
Happy Hour). This makes the system flexible.
Comentarios a estos manuales