MariaDB [rphannavong]> 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.00 sec) MariaDB [rphannavong]> describe Likes; +-------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------+------------------+------+-----+---------+-------+ | like_id | int(10) unsigned | YES | | NULL | | | post_userID | int(10) | YES | | NULL | | | post_postID | int(10) unsigned | YES | | NULL | | +-------------+------------------+------+-----+---------+-------+ 3 rows in set (0.00 sec) MariaDB [rphannavong]> describe Posts; +------------------+------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+------------------+------+-----+---------+-------+ | post_id | int(10) unsigned | YES | | NULL | | | post_description | varchar(511) | YES | | NULL | | | post_likes | int(10) unsigned | YES | | NULL | | +------------------+------------------+------+-----+---------+-------+ 3 rows in set (0.00 sec) MariaDB [rphannavong]> SELECT * FROM Users; +---------+------------+---------------+---------------+------------+ | user_id | user_uname | user_email | user_password | user_fname | +---------+------------+---------------+---------------+------------+ | 1 | test | test@test.com | testpassword | testfname | | 2 | rose | rose@rose.com | rosepassword | rosefname | | 3 | d | s | f | f | +---------+------------+---------------+---------------+------------+ 3 rows in set (0.00 sec) MariaDB [rphannavong]> SELECT * FROM Likes; +---------+-------------+-------------+ | like_id | post_userID | post_postID | +---------+-------------+-------------+ | 1 | 1 | 1 | | 2 | 2 | 2 | +---------+-------------+-------------+ 2 rows in set (0.00 sec) MariaDB [rphannavong]> SELECT * FROM Posts; +---------+------------------+------------+ | post_id | post_description | post_likes | +---------+------------------+------------+ | 1 | This is cool! | 2 | | 2 | Amazing! | 0 | +---------+------------------+------------+ 2 rows in set (0.00 sec)