| Physical name | Order Details | |
| Logical name | Order Details | |
| Attributes | 5 | |
| Description | ||
| PK | Physical name | Datatype | FK Ref. |
| OrderID | INT | Orders.OrderID [FK_OrdDet_Ord] |
| ProductID | INT | Product.ProductID [FK_OrdDet_Prod] |
| UnitPrice | MONEY | ||
| Quantity | SMALLINT | ||
| Discount | REAL |
| Indexes | |||
| ProductID | ProductID | ASC | |
| ProductsOrder_Details | ProductID | ASC | |
| OrderID | OrderID | ASC | |
| OrdersOrder_Details | OrderID | ASC | |
| References | Referenced by |
|
Orders [FK_OrdDet_Ord]
Product [FK_OrdDet_Prod] |