UltraLite Database User's Guide
Tutorial: Walking Through a Sample UltraLite Application
Lesson 7: Browse the consolidated database
The following figure shows the tables in the CustDB consolidated database and how they relate to each other.
The tables hold the following information.
ULCustomer A list of customers.
ULProduct A list of products.
ULEmployee A list of sales employees. This table is not present in the UltraLite database.
ULEmpCust A many-to-many relationship between employees and customers. This table is not present in the UltraLite database.
ULOrder A list of orders, including details of the customer who placed the order, the employee who took the order, and the product being ordered.
ULCustomerIDPool A table to maintain unused unique primary key values on the customer table throughout a deployed UltraLite system.
ULOrderIDPool A table to maintain unused unique primary key values on the order table throughout a deployed UltraLite system.
ULIdentifyEmployee This table holds a list of employee ID numbers.