dbo."Order Details"

Table: 'dbo."Order Details"', 5 fields

Field NameType and SizeDefaultNullable
OrderIDint NOT NULL
ProductIDint NOT NULL
UnitPricemoney(19.4)(0)NOT NULL
Quantitysmallint(1)NOT NULL
Discountreal(0)NOT NULL

Primary key for table 'dbo."Order Details"'

Primary Key NameFields
PK_Order_DetailsOrderID, ProductID

Foreign keys for table 'dbo."Order Details"', 2 items

ForeignPrimary
Order Details.OrderIDOrders.OrderID
Order Details.ProductIDProducts.ProductID

Dependencies for table 'dbo."Order Details"', 10 items

Object NameType
dbo.CK_Discountcheck cns
dbo.CK_Quantitycheck cns
dbo.CK_UnitPricecheck cns
dbo.CustOrderHiststored procedure
dbo.CustOrdersDetailstored procedure
dbo.Invoicesview
dbo.Order Details Extendedview
dbo.Order Subtotalsview
dbo.Product Sales for 1997view
dbo.SalesByCategorystored procedure