Well done! We'll now discuss the
products table stores information about products sold at the Northwind store. Each product has a unique
product_id and a
product_name. Each product is supplied by a single supplier (
supplier_id) and belongs to a single category (
category_id). Each product also has a certain
discontinued column contains either a
false (available in store) or a
true (discontinued) that reflects the current availability of that product.
Products are organized into categories. The information about categories is stored in the
categories table. Each category has a unique ID and a
category_name. There is also a short
products table contains the
category_id column, you can join it with the
categories table to get more information about the product's category (e.g., the category name).