MariaDB [kgregory]> describe Users;
+---------------+------------------+------+-----+---------+----------------+
| 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.01 sec)

MariaDB [kgregory]> SELECT * FROM Users;
+---------+------------+---------------+---------------+------------+
| user_id | user_uname | user_email    | user_password | user_fname |
+---------+------------+---------------+---------------+------------+
|       1 | test       | test@test.com | testpassword  | testfname  |
|       2 | user       | user@user.com | userpassword  | userfname  |
+---------+------------+---------------+---------------+------------+
2 rows in set (0.00 sec)

MariaDB [kgregory]> describe Products;
+------------------+---------------------+------+-----+---------+----------------+
| 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.01 sec)

MariaDB [kgregory]> SELECT * FROM Products;
+---------+-----------+-------------+---------------------------------+------------+-------------+----------+------------+
| prod_id | prod_name | prod_img    | prod_description                | prod_price | prod_rating | prod_sku | prod_stock |
+---------+-----------+-------------+---------------------------------+------------+-------------+----------+------------+
|       1 | Tower     | tower.jpg   | CM Stormtrooper FUll Tower      |     180.34 |           5 | JF453LJ  |          1 |
|       2 | Monitor   | monitor.jpg | Asus 24" Full HD Gaming Monitor |     279.99 |           4 | VG248QE  |          4 |
|       3 | GPU       | gpu.jpg     | Asus Radeon HD 7990             |     424.24 |           1 | EOA2347  |          0 |
|       4 | CPU       | cpu.jpg     | Intel Core i7-7700              |     374.99 |           2 | LAI41KS  |          7 |
|       5 | PSU       | psu.jpg     | EVGA 850G2 Power Supply         |     180.41 |           4 | 3J44LQ0  |          2 |
|       6 | Memory    | memory.jpg  | Corsair Vengeance 16GB DDR4     |     139.99 |           3 | NVB2NN3  |          5 |
+---------+-----------+-------------+---------------------------------+------------+-------------+----------+------------+
6 rows in set (0.00 sec)