Table Order Details

Figure A.9. Schema for Table Order Details.

Index Name	Fields	Clustered	Primary Key
PK_Order_Details	OrderID+ProductID	Y	Y
OrderID	OrderID	N	N
OrdersOrder_Details	OrderID	N	N
ProductID	ProductID	N	N
ProductsOrder_Details	ProductID	N	N

Foreign Key Name	Key Field	Related Table	Related Field
FK_Order_Details_Orders	OrderID	Orders	OrderID
FK_Order_Details_Products	ProductID	Products	ProductID