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

Model Element Element type
TestGroup.Order Entity
OrderTV Typed View