Sybase Adaptive Server Anywhere SNMP Extension Agent Adaptive Server Anywhere sample database

code = fin_code_id

fin_code

codechar(2)<pk>

typechar(10) description char(50)

code = code

fin_data

yearchar(4)<pk>

quarterchar(2)<pk>

codechar(2)<pk,fk> amount numeric(9)

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.

asademo.db

	product
id	integer <pk>
name	char(15)
description	char(30)
size	char(18)
color	char(6)
quantity	integer
unit_price	numeric (15,2)
	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)

		sales_order_items						Employee
	id			integer	<pk,fk>
							emp_id		integer	<pk>
	line_id			smallint	<pk>
							manager_id		integer
	prod_id			integer	<fk>
							emp_fname		char(20)
	quantity			integer
id = prod_id							emp_lname		char(20)
	ship_date			date
							dept_id		integer	<fk>
							street		char(40)
						emp_id = sales_rep	city		char(20)
		id = id					state		char(4)
							zip_code		char(9)
							phone		char(10)
			sales_order				status		char(1)
							ss_number		char(11)
	id			integer	<pk>		salary		numeric(20,3)
	cust_id			integer	<fk>		start_date		date
	order_date			date			termination_date		date
	fin_code_id			char(2)	<fk>		birth_date		date
id = cust_id	region			char(7)			bene_health_ins		char(1)
	sales_rep			integer	<fk>		bene_life_ins		char(1)
							bene_day_care		char(1)
							sex		char(1)

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)

dept_id = dept_id

emp_id = dept_head_id

department

dept_id	integer	<pk>
dept_name	char(40)
dept_head_id	integer	<fk>

xi