Database Reference
In-Depth Information
SHIPMENT
Figure 2-52
Column
Characteristics
for the
MI Database
SHIPMENT Table
Column Name
Type
Key
Required
Remarks
ShipmentID
AutoNumber
Primary Key
Yes
Surrogate Key
ShipperName
Text (35)
No
Yes
ShipperInvoiceNumber
Number
No
Yes
Long Integer
DepartureDate
Date
No
No
ArrivalDate
Date
No
No
InsuredValue
Currency
No
No
Two Decimal Places
Figure 2-53
Column Characteristics
for the MI Database
SHIPMENT_ITEM Table
SHIPMENT_ITEM
Column Name
Type
Key
Required
Remarks
ShipmentID
Number
Primary Key,
Foreign Key
Yes
Long Integer
ShipmentItemID
Number
Primary Key
Yes
Long Integer
ItemID
Number
Foreign Key
Yes
Long Integer
Value
Currency
No
Yes
Two Decimal Places
Figure 2-54
Sample Data for the MI
Database ITEM Table
ItemID
Description
PurchaseDate
Store
City
Quantity
LocalCurrencyAmount
ExchangeRate
1
QE Dining Set
Eastern
Treasures
Manila
2
403405
0.01774
07-Apr-13
2
Willow Serving
Dishes
15-Jul-13
Jade
Antiques
Singapore
75
102
0.5903
3
Large Bureau
Eastern
Sales
Singapore
8
2000
0.5903
17-Jul-13
4
Brass Lamps
Jade
Antiques
Singapore
40
50
0.5903
20-Jul-13
 
Search WWH ::




Custom Search