Order Details

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
ProductID 2 int 0 10 0 Yes Yes
UnitPrice 3 money 0 19 4 0
Quantity 4 smallint 0 5 0 1
Discount 5 real 0 24 0 0

Foreign key constraints

FK_Order_Details_Orders

Aspect Value
Primary key table dbo.Orders
Delete rule Cascade
Update rule NoAction
Foreign key field Primary key field
OrderID dbo.Orders.OrderID

FK_Order_Details_Products

Aspect Value
Primary key table dbo.Products
Delete rule NoAction
Update rule NoAction
Foreign key field Primary key field
ProductID dbo.Products.ProductID

Model elements mapped on this table

Model Element Element type
TestGroup.OrderDetails Entity
TCTester Entity