Northwind
| Table Name: | Order Details |
| Primary Keys: | OrderID ProductID |
| Field | Type | Defaults | Nulls? |
|---|---|---|---|
| OrderID | int | None | No |
| ProductID | int | None | No |
| UnitPrice | money | (0) | No |
| Quantity | smallint | (1) | No |
| Discount | real | (0) | No |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_Order_Details | Yes | Yes | OrderID ProductID |
| OrderID | No | No | OrderID |
| OrdersOrder_Details | No | No | OrderID |
| ProductID | No | No | ProductID |
| ProductsOrder_Details | No | No | ProductID |
| Check Constraint | Text |
|---|---|
| CK_Discount | ([Discount] >= 0 and [Discount] <= 1) |
| CK_Quantity | ([Quantity] > 0) |
| CK_UnitPrice | ([UnitPrice] >= 0) |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_Order_Details_Orders | OrderID | Orders |
| FK_Order_Details_Products | ProductID | Products |