dbo."Order Details"

Field Name	Type and Size	Default	Nullable
OrderID	int		NOT NULL
ProductID	int		NOT NULL
UnitPrice	money(19.4)	(0)	NOT NULL
Quantity	smallint	(1)	NOT NULL
Discount	real	(0)	NOT NULL

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

Primary Key Name	Fields
PK_Order_Details	OrderID, ProductID

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

Foreign	Primary
Order Details.OrderID	Orders.OrderID
Order Details.ProductID	Products.ProductID

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

Object Name	Type
dbo.CK_Discount	check cns
dbo.CK_Quantity	check cns
dbo.CK_UnitPrice	check cns
dbo.CustOrderHist	stored procedure
dbo.CustOrdersDetail	stored procedure
dbo.Invoices	view
dbo.Order Details Extended	view
dbo.Order Subtotals	view
dbo.Product Sales for 1997	view
dbo.SalesByCategory	stored procedure