Download Informix Guide to SQL: Reference

The orders Table
Tech Review Draft Tech Review Draft Tech Review Draft Tech Review Draft Tech Review Draft Tech Review Draft Tech Review Draft Tech
The zipcode column in Figure A-1 is indexed and allows duplicate values.
Figure A-1
The customer Table
Column
Name
customer_num
fname
lname
company
address1
address2
city
state
zipcode
phone
Data
Type
SERIAL(101)
CHAR(15)
CHAR(15)
CHAR(20)
CHAR(20)
CHAR(20)
CHAR(15)
CHAR(18)
CHAR(2)
CHAR(5)
Description
system-generated customer number
first name of store representative
last name of store representative
name of store
first line of store address
second line of store address
city
state (foreign key to state table)
zipcode
telephone number
The orders Table
The orders table contains information about orders placed by the customers
of the distributor. Figure A-2 shows the columns of the orders table.
Figure A-2
The orders Table
Column
Name
order_num
order_date
customer_num
Data
Type
ship_instruct
backlog
CHAR(40)
CHAR(1)
po_num
ship_date
ship_weight
ship_charge
paid_date
CHAR(10)
DATE
DECIMAL(8,2)
MONEY(6)
DATE
SERIAL(1001)
DATE
INTEGER
Description
system-generated order number
date order entered
customer number (foreign key to customer
table)
special shipping instructions
indicates order cannot be filled because the item
is backlogged:
y = yes
n = no
customer purchase order number
shipping date
shipping weight
shipping charge
date order paid
The stores7 Database
A-3