Sample Product Catalog
Sample Product Catalog Database
Welcome to the Sample Product Catalog Database! This database is designed for testing and working with product catalog scenarios in PostgreSQL. Below you'll find a detailed description of the database structure, its purpose, and how to report issues.
Overview
The Sample Product Catalog Database provides a structured way to manage a variety of products, including details such as product names, categories, prices, and stock levels. This is an excellent resource for developers looking to practice SQL queries or build applications that require product catalog functionalities.
Database Structure
- products: Contains product details
- categories: Lists product categories
- suppliers: Contains supplier information
Sample Data
Here’s a glimpse of what the tables might contain:
Products
id | name | category_id | price | stock |
---|---|---|---|---|
1 | Widget A | 1 | 19.99 | 100 |
2 | Widget B | 1 | 24.99 | 50 |
3 | Gadget X | 2 | 15.50 | 200 |
Categories
id | name |
---|---|
1 | Widgets |
2 | Gadgets |
Suppliers
id | name | contact_info |
---|---|---|
1 | Supplier A | supplierA@example.com |
2 | Supplier B | supplierB@example.com |
Usage
To get started, navigate to the Data Explorer