Sybase Adaptive Server Anywhere SNMP Extension Agent, User Manual

Page: 11 / 70

The Adaptive Server Anywhere sample database
Many of the examples throughout the documentation use the Adaptive
Server Anywhere sample database.
The sample database is held in a file named asademo.db, and is located in
your SQL Anywhere directory.
The sample database represents a small company. It contains internal
information about the company (employees, departments, and finances) as
well as product information and sales information (sales orders, customers,
and contacts). All information in the database is fictional.
The following figure shows the tables in the sample database and how they
relate to each other.
fin_code
code char(2) <pk>
type char(10)
description char(50)
product
id integer <pk>
name char(15)
description char(30)
size char(18)
color char(6)
quantity integer
unit_price numeric (15,2)
asademo.db
contact
id integer <pk>
last_name char(15)
first_name char(15)
title
char(2)
street char(30)
city char(20)
state char(2)
zip char(5)
phone char(10)
fax char(10)
customer
id integer <pk>
fname char(15)
lname char(20)
address char(35)
city
char(20)
state char(2)
zip char(10)
phone char(20)
company_name char(35)
fin_data
year char(4) <pk>
quarter char(2) <pk>
code char(2) <pk,fk>
amount numeric(9)
sales_order
id integer <pk>
cust_id integer <fk>
order_date date
fin_code_id char(2) <fk>
region
char(7)
sales_rep integer <fk>
sales_order_items
id integer <pk,fk>
line_id smallint <pk>
prod_id integer <fk>
quantity integer
ship_date date
department
dept_id integer <pk>
dept_name char(40)
dept_head_id integer
<fk>
Employee
emp_id integer <pk>
manager_id integer
emp_fname char(20)
emp_lname char(20)
dept_id integer <fk>
street char(40)
city char(20)
state char(4)
zip_code char(9)
phone char(10)
status char(1)
ss_number char(11)
salary numeric(20,3)
start_date date
termination_date date
birth_date date
bene_health_ins char(1)
bene_life_ins char(1)
bene_day_care char(1)
sex char(1)
id = prod_id
id = cust_id
id = id
emp_id = sales_rep
emp_id = dept_head_id
code = fin_code_id
dept_id = dept_id
code = code
xi