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

SQL Anywhere 12.0.0 (Français) » MobiLink - Getting Started » MobiLink Tutorials » Tutorial: Using MobiLink with an Adaptive Server Enterprise consolidated database


Lesson 1: Design your schemas

This tutorial assumes that the pubs2 sample schema is installed on an Adaptive Server Enterprise server. The Adaptive Server Enterprise server may be installed locally on your computer or accessed remotely using Sybase Open Client.

The pubs2 sample schema is used as the consolidated database schema. It contains information about stores, titles, authors, publishers, and sales. The following table provides a description of each table in the Adaptive Server Enterprise database:

Table Description
au_pix Pictures of the authors.
authors The authors of the various TITLES in the system.
discounts Records of various discounts at particular STORES.
sales Each sale record is one sale made by a particular store.
salesdetail Contains information about the different TITLES that were included in a particular sale.
stores Each store record is one store or branch office in the system.
titleauthor Contains information about which TITLES were written by which AUTHORS.
titles Records of all the different books in the system.
blurbs, publishers, and roysched Contains information that is not needed in this demonstration.
 Designing the remote schema