Orders
Fields
Field name |
Ordinal |
Native type |
Length |
Precision |
Scale |
Is Nullable |
Is PK |
Is FK |
Is Identity |
Is Computed |
Default value |
Default sequence |
OrderID |
1 |
int |
0 |
10 |
0 |
|
Yes |
|
Yes |
|
|
|
CustomerID |
2 |
nchar |
5 |
0 |
0 |
Yes |
|
Yes |
|
|
|
|
EmployeeID |
3 |
int |
0 |
10 |
0 |
Yes |
|
Yes |
|
|
|
|
OrderDate |
4 |
datetime |
0 |
0 |
0 |
Yes |
|
|
|
|
|
|
RequiredDate |
5 |
datetime |
0 |
0 |
0 |
Yes |
|
|
|
|
|
|
ShippedDate |
6 |
datetime |
0 |
0 |
0 |
Yes |
|
|
|
|
|
|
ShipVia |
7 |
int |
0 |
10 |
0 |
Yes |
|
Yes |
|
|
|
|
Freight |
8 |
money |
0 |
19 |
4 |
Yes |
|
|
|
|
0 |
|
ShipName |
9 |
nvarchar |
40 |
0 |
0 |
Yes |
|
|
|
|
|
|
ShipAddress |
10 |
nvarchar |
60 |
0 |
0 |
Yes |
|
|
|
|
|
|
ShipCity |
11 |
nvarchar |
15 |
0 |
0 |
Yes |
|
|
|
|
|
|
ShipRegion |
12 |
nvarchar |
15 |
0 |
0 |
Yes |
|
|
|
|
|
|
ShipPostalCode |
13 |
nvarchar |
10 |
0 |
0 |
Yes |
|
|
|
|
|
|
ShipCountry |
14 |
nvarchar |
15 |
0 |
0 |
Yes |
|
|
|
|
|
|
Foreign key constraints
FK_Orders_Customers
Aspect |
Value |
Primary key table |
dbo.Customers |
Delete rule |
NoAction |
Update rule |
NoAction |
Foreign key field |
Primary key field |
CustomerID |
dbo.Customers.CustomerID |
FK_Orders_Employees
Aspect |
Value |
Primary key table |
dbo.Employees |
Delete rule |
NoAction |
Update rule |
NoAction |
Foreign key field |
Primary key field |
EmployeeID |
dbo.Employees.EmployeeID |
FK_Orders_Shippers
Aspect |
Value |
Primary key table |
dbo.Shippers |
Delete rule |
NoAction |
Update rule |
NoAction |
Foreign key field |
Primary key field |
ShipVia |
dbo.Shippers.ShipperID |
Model elements mapped on this table