In this episode, we jump right into building out our products database table. We start by thinking through what kind of information belongs in a product—like its title, a unique slug, a (nullable) description, and most importantly, the price. There's a quick explainer on why we store prices as integers (think 100 pennies = £1), rather than floats or decimals, to avoid precision issues (nobody wants weird math messing up their prices!).
We also add a way to make a product 'live' (or mark it as not live) by including a nullable date field, making the whole thing flexible enough for a simple admin panel later on.
After creating the migration and running it, we check out the products table in the database and add a sample product. By the end of the episode, you've got a basic product ready to go—just enough to display on a page, which is exactly what we'll start working on in the next episode!