MariaDB [ksingh]> describe Users; SELECT * FROM Users; describe Products; SELECT * FROM Products;
+---------------+------------------+------+-----+---------+----------------+
| Field         | Type             | Null | Key | Default | Extra          |
+---------------+------------------+------+-----+---------+----------------+
| user_id       | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| user_uname    | varchar(255)     | YES  |     | NULL    |                |
| user_email    | varchar(255)     | YES  |     | NULL    |                |
| user_password | varchar(255)     | YES  |     | NULL    |                |
| user_fname    | varchar(255)     | YES  |     | NULL    |                |
+---------------+------------------+------+-----+---------+----------------+
5 rows in set (0.00 sec)

+---------+------------+------------------+---------------+------------+
| user_id | user_uname | user_email       | user_password | user_fname |
+---------+------------+------------------+---------------+------------+
|       1 | dmckee     | derrick@csub.edu | cs311         | Derrick    |
|       2 | ksingh     | ksingh@csub.edu  | 123456        | Kuljit     |
|       3 | test       | test@test.com    | testpassword  | testfname  |
+---------+------------+------------------+---------------+------------+
3 rows in set (0.00 sec)

+------------------+---------------------+------+-----+---------+----------------+
| Field            | Type                | Null | Key | Default | Extra          |
+------------------+---------------------+------+-----+---------+----------------+
| prod_id          | int(10) unsigned    | NO   | PRI | NULL    | auto_increment |
| prod_name        | varchar(127)        | YES  |     | NULL    |                |
| prod_img         | varchar(127)        | YES  |     | NULL    |                |
| prod_description | varchar(511)        | YES  |     | NULL    |                |
| prod_price       | decimal(10,2)       | YES  |     | NULL    |                |
| prod_rating      | tinyint(3) unsigned | YES  |     | NULL    |                |
| prod_sku         | char(32)            | YES  |     | NULL    |                |
| prod_stock       | int(10) unsigned    | YES  |     | NULL    |                |
+------------------+---------------------+------+-----+---------+----------------+
8 rows in set (0.00 sec)

+---------+--------------+-----------------+------------------+------------+-------------+----------+------------+
| prod_id | prod_name    | prod_img        | prod_description | prod_price | prod_rating | prod_sku | prod_stock |
+---------+--------------+-----------------+------------------+------------+-------------+----------+------------+
|       1 | Coffee       | coffee.jpg      | COFFEE           |       2.00 |           5 | 12345    |          0 |
|       2 | Tea          | tea.jpg         | TEA              |       1.00 |           2 | 12356    |          2 |
|       3 | Soda         | soda.jpg        | SODA             |       1.75 |           4 | 54321    |         10 |
|       4 | Beer         | beer.jpg        | BEER             |       2.75 |           5 | 23415    |         99 |
|       5 | Energy Drink | energyDrink.jpg | ENERGY DRINK     |       3.00 |           3 | 98765    |          5 |
|       6 | Water        | water.jpg       | WATER            |       0.50 |           1 | 54646    |         35 |
+---------+--------------+-----------------+------------------+------------+-------------+----------+------------+
6 rows in set (0.00 sec)