HP NonStop SQL/MP

SQL/MP Sample Database
HP NonStop SQL/MP Programming Manual for C—429847-008
A-2
Figure A-1 shows the names of columns and tables and the relations between the
tables in the sample database.
Figure A-1. SQL/MP Sample Database Relations
custnum
custname
street
city
state
postcode
credit
errors_date
errors_time
errors_id
errors_sql
errors_text 1
errors_text 2
ordernum
partnum
unit_price
qty_ordered
EMPLOYEE Table CUSTOMER Table ERRORS Table
DEPT Table ORDERS Table SUPPLIER Table
JOB Table
ODETAIL Table
PARTLOC Table *
PERSNL
Subvolume
SALES
Subvolume
INVENT
Subvolume
empnum
first_name
last_name
deptnum
jobcode
salary
suppnum
suppname
street
city
state
postcode
ordernum
order_date
deliv_date
salesrep
custnum
deptnum
deptname
manager
rptdept
location
jobcode
jobdesc
PARTSUPP Table
partnum
suppnum
partcost
qty_received
loc_code
partnum
qty_on_hand
PARTS Table
partnum
partdesc
price
qty_available
Legend
The PARTLOC table can
be partitioned by the
value of LOC_CODE.
*
One to one
One to many
SUPPKANJ Table
suppnum
suppname_kanji
suppname_katakana
suppname_english
street
city
state
postcode
VST007.vsd