Northwind
| Table Name: | Products |
| Primary Keys: | ProductID |
| Field | Type | Defaults | Nulls? |
|---|---|---|---|
| ProductID | int | None | No |
| ProductName | nvarchar (40) | None | No |
| SupplierID | int | None | Yes |
| CategoryID | int | None | Yes |
| QuantityPerUnit | nvarchar (20) | None | Yes |
| UnitPrice | money | (0) | Yes |
| UnitsInStock | smallint | (0) | Yes |
| UnitsOnOrder | smallint | (0) | Yes |
| ReorderLevel | smallint | (0) | Yes |
| Discontinued | bit | (0) | No |
| Index | Clustered? | Unique? | Fields |
|---|---|---|---|
| PK_Products | Yes | Yes | ProductID |
| CategoriesProducts | No | No | CategoryID |
| CategoryID | No | No | CategoryID |
| ProductName | No | No | ProductName |
| SupplierID | No | No | SupplierID |
| SuppliersProducts | No | No | SupplierID |
| Check Constraint | Text |
|---|---|
| CK_Products_UnitPrice | ([UnitPrice] >= 0) |
| CK_ReorderLevel | ([ReorderLevel] >= 0) |
| CK_UnitsInStock | ([UnitsInStock] >= 0) |
| CK_UnitsOnOrder | ([UnitsOnOrder] >= 0) |
| Internal Foreign Key Constraint | Affected Field | Source Table |
|---|---|---|
| FK_Products_Categories | CategoryID | Categories |
| FK_Products_Suppliers | SupplierID | Suppliers |
| Primary Key as Foreign Key Constraint | Affected Table | Affected Field |
|---|---|---|
| FK_Order_Details_Products | Order Details | ProductID |