Database Diagram Post User id INT Comment text VARCHAR(280) Pid INT Fid INT creation_date DATETIME # text VARCHAR(280) name VARCHAR(128) likes INT creation_date DATETIME email VARCHAR(320) author _id INT likes INT username VARCHAR(128) Indexes post_id INT password VARCHAR(32) author_id INT city VARCHAR(45) Community Indexes country VARCHAR(45) Pid INT time_zone VARCHAR(45) name VARCHAR(32) ip_address VARCHAR(45) # followers INT date_of_birth DATE description VARCHAR(128) job VARCHAR(45) creation_date DATETIME phone_number VARCHAR(45) Indexes Indexes Friendship Community_has_User I friend_a_id INT Community_id INT I friend_b_id INT User_id INT creation_date DATETIME Indexes Indexes