outdoor data structure
The outdoor database contains details on outdoor equipment and the categories they are part of. The recipes that use the outdoor dataset are based on you being part of an outdoor equipment store. The following diagram shows the relationship between the many outdoor products to their given category:
products
The products table contains the following details for each product:
|
Field |
Description |
Example |
|---|---|---|
|
|
Identification for the product |
|
|
|
Product's description |
|
|
|
Product's price |
|
|
|
Identification for the category; it references to the categories' data |
|
categories
The categories table contains the following details for each category:
|
Field |
Description |
Example |
|---|---|---|
|
|
Identification for the category |
|
|
|
Category's description |
|
