Description
Product names, suppliers, prices, and units in stock.
View properties
| name | value |
|---|
| name | ~sq_fProducts |
| created | 11/22/2006 8:19:43 PM |
| modified | 11/22/2006 8:19:43 PM
|
Columns
| column | datatype | length | nulls | comment |
|---|
| ProductID | long | 4 | yes
| Number automatically assigned to new product.
|
| ProductName | text | 40 | no
| |
| SupplierID | long | 4 | yes
| Same entry as in Suppliers table.
|
| CategoryID | long | 4 | yes
| Same entry as in Categories table.
|
| QuantityPerUnit | text | 20 | yes
| (e.g., 24-count case, 1-liter bottle).
|
| UnitPrice | currency | 8 | yes
| |
| UnitsInStock | int | 2 | yes
| |
| UnitsOnOrder | int | 2 | yes
| |
| ReorderLevel | int | 2 | yes
| Minimum units to maintain in stock.
|
| Discontinued | boolean | 1 | yes
| Yes means item is no longer available.
|
Dependency graph
Objects that ~sq_fProducts depends on
Sample rows
| ProductID | ProductName | SupplierID | CategoryID | QuantityPerUnit | UnitPrice | UnitsInStock | UnitsOnOrder | ReorderLevel | Discontinued |
|---|
| 1
| Chai
| 1
| 1
| 10 boxes x 20 bags
| 18
| 39
| 0
| 10
| False
|
| 2
| Chang
| 1
| 1
| 24 - 12 oz bottles
| 19
| 17
| 40
| 25
| False
|
| 3
| Aniseed Syrup
| 1
| 2
| 12 - 550 ml bottles
| 10
| 13
| 70
| 25
| False
|
| 4
| Chef Anton's Cajun Seasoning
| 2
| 2
| 48 - 6 oz jars
| 22
| 53
| 0
| 0
| False
|
| 5
| Chef Anton's Gumbo Mix
| 2
| 2
| 36 boxes
| 21.35
| 0
| 0
| 0
| True
|
| 6
| Grandma's Boysenberry Spread
| 3
| 2
| 12 - 8 oz jars
| 25
| 120
| 0
| 25
| False
|
| 7
| Uncle Bob's Organic Dried Pears
| 3
| 7
| 12 - 1 lb pkgs.
| 30
| 15
| 0
| 10
| False
|
| 8
| Northwoods Cranberry Sauce
| 3
| 2
| 12 - 12 oz jars
| 40
| 6
| 0
| 0
| False
|
| 9
| Mishi Kobe Niku
| 4
| 6
| 18 - 500 g pkgs.
| 97
| 29
| 0
| 0
| True
|
| 10
| Ikura
| 4
| 8
| 12 - 200 ml jars
| 31
| 31
| 0
| 0
| False
|
Code
SELECT DISTINCTROW
*
FROM Products;