77rows
14 columns
Schema from the provider contract| Column | Type | Nullable | Key | References |
|---|---|---|---|---|
ProductID | TEXT | yes | — | — |
ProductName | TEXT | yes | — | — |
SupplierID | TEXT | yes | — | — |
CategoryID | TEXT | yes | — | — |
QuantityPerUnit | TEXT | yes | — | — |
UnitPrice | TEXT | yes | — | — |
UnitsInStock | TEXT | yes | — | — |
UnitsOnOrder | TEXT | yes | — | — |
ReorderLevel | TEXT | yes | — | — |
Discontinued | TEXT | yes | — | — |
CategoryName | TEXT | yes | — | — |
CategoryDescription | TEXT | yes | — | — |
SupplierName | TEXT | yes | — | — |
SupplierRegion | TEXT | yes | — | — |
View definition
CREATE VIEW [ProductDetails_V] as
select
p.*,
c.CategoryName, c.Description as [CategoryDescription],
s.CompanyName as [SupplierName], s.Region as [SupplierRegion]
from [Products] p
join [Categories] c on p.CategoryId = c.CategoryId
join [Suppliers] s on s.SupplierId = p.SupplierIdData preview
Sample records
| ProductID | ProductName | SupplierID | CategoryID | QuantityPerUnit | UnitPrice | UnitsInStock |
|---|---|---|---|---|---|---|
| 1 | Chai | 1 | 1 | 10 boxes x 20 bags | 18 | 39 |
| 2 | Chang | 1 | 1 | 24 - 12 oz bottles | 19 | 17 |
| 3 | Aniseed Syrup | 1 | 2 | 12 - 550 ml bottles | 10 | 13 |
| 4 | Chef Anton's Cajun Seasoning | 2 | 2 | 48 - 6 oz jars | 22 | 53 |
| 5 | Chef Anton's Gumbo Mix | 2 | 2 | 36 boxes | 21.35 | 0 |
| 6 | Grandma's Boysenberry Spread | 3 | 2 | 12 - 8 oz jars | 25 | 120 |
| 7 | Uncle Bob's Organic Dried Pears | 3 | 7 | 12 - 1 lb pkgs. | 30 | 15 |
| 8 | Northwoods Cranberry Sauce | 3 | 2 | 12 - 12 oz jars | 40 | 6 |