|
Name
|
Data Type
|
Size(Precision,Scale)
|
Nulls
|
|
ShipName
|
nvarchar
|
40
|
|
|
ShipAddress
|
nvarchar
|
60
|
|
|
ShipCity
|
nvarchar
|
15
|
|
|
ShipRegion
|
nvarchar
|
15
|
|
|
ShipPostalCode
|
nvarchar
|
10
|
|
|
ShipCountry
|
nvarchar
|
15
|
|
|
CustomerID
|
nchar
|
5
|
|
|
CustomerName
|
nvarchar
|
40
|
|
|
Address
|
nvarchar
|
60
|
|
|
City
|
nvarchar
|
15
|
|
|
Region
|
nvarchar
|
15
|
|
|
PostalCode
|
nvarchar
|
10
|
|
|
Country
|
nvarchar
|
15
|
|
|
Salesperson
|
nvarchar
|
31
|
|
|
OrderID
|
int
|
0
|
|
|
OrderDate
|
datetime
|
0
|
|
|
RequiredDate
|
datetime
|
0
|
|
|
ShippedDate
|
datetime
|
0
|
|
|
ShipperName
|
nvarchar
|
40
|
|
|
ProductID
|
int
|
0
|
|
|
ProductName
|
nvarchar
|
40
|
|
|
UnitPrice
|
money
|
0
|
|
|
Quantity
|
smallint
|
0
|
|
|
Discount
|
real
|
0
|
|
|
ExtendedPrice
|
money
|
0
|
|
|
Freight
|
money
|
0
|
|
|