-- TABLE USER
DROP TABLE IF EXISTS instagram.user;

CREATE TABLE instagram.user(
	user_id SERIAL PRIMARY KEY,
	user_username VARCHAR(50) UNIQUE,
	user_email VARCHAR(100) UNIQUE,
	user_pass varchar(50),
	user_name varchar(100),
	user_ip varchar(100),
	date_created timestamp DEFAULT current_timestamp,
	date_updated timestamp DEFAULT current_timestamp
);

-- TABLE USER FOLLOWING
DROP TABLE IF EXISTS instagram.user_following;

CREATE TABLE instagram.user_following(
	ufing_id SERIAL PRIMARY KEY,
	user_id int REFERENCES instagram.user(user_id),
	following_id int
);

-- TABLE USER FOLLOWERS
DROP TABLE IF EXISTS instagram.user_followers;

CREATE TABLE instagram.user_followers(
	ufer_id SERIAL PRIMARY KEY,
	user_id int REFERENCES instagram.user(user_id),
	follower_id int
);

-- TABLE POST
-- TABLE COMMENT
DROP TABLE IF EXISTS instagram.comments;

CREATE TABLE instagram.comments(
	com_id SERIAL PRIMARY KEY,
	user_id int REFERENCES instagram.user(user_id),
	post_id int REFERENCES instagram.post(post_id),
	com_text varchar(200),
	date_created timestamp DEFAULT current_timestamp,
	date_updated timestamp DEFAULT current_timestamp
);
-- TABLE LIKES