Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » MobiLink - Getting Started » MobiLink tutorials » Tutorial: Using MobiLink with an Oracle Database 10g


Lesson 1: Designing the schemas

This tutorial assumes that you have installed the Order Entry (OE) and Human Relations (HR) sample schemas. The OE schema is used as the consolidated database. It encapsulates information about employees, orders, customers, and products. For this tutorial, you are primarily interested in the OE schema. However, you must refer to the EMPLOYEES table in the HR schema to get information about each individual salesperson. Here is a brief description of the relevant tables in the OE schema:

Table Description
CUSTOMERS Customers whose information is kept on record.
INVENTORIES How much of each product is stored in each warehouse.
ORDER_ITEMS A list of products included in each order.
ORDERS A record of a sale between a salesperson and a customer on a specific date.
PRODUCT_DESCRIPTIONS Descriptions of each product in different languages.
PRODUCT_INFORMATION A record of each product in the system.
 Designing the remote schema