Instgram 🔥📷🤳
Instagram is one of the most popular social media platforms worldwide
@kaggle.bhanupratapbiswas_instgram
Instagram is one of the most popular social media platforms worldwide
@kaggle.bhanupratapbiswas_instgram
CREATE TABLE follows (
"follower" BIGINT,
"followee" BIGINT,
"created_time" VARCHAR,
"is_follower_active" BIGINT,
"followee_acc_status" VARCHAR
);
CREATE TABLE likes (
"user" BIGINT,
"photo" BIGINT,
"created_time" VARCHAR,
"following_or_not" VARCHAR,
"like_type" VARCHAR
);
CREATE TABLE photo_tags (
"photo" BIGINT,
"tag_id" BIGINT,
"user_id" BIGINT
);
CREATE TABLE users (
"id" BIGINT,
"name" VARCHAR,
"created_time" VARCHAR,
"private_public" VARCHAR,
"post_count" BIGINT,
"verified_status" VARCHAR
);
CREATE TABLE tags (
"id" BIGINT,
"tag_text" VARCHAR,
"created_time" VARCHAR,
"location" VARCHAR
);
CREATE TABLE photos (
"id" BIGINT,
"image_link" VARCHAR,
"user_id" BIGINT,
"created_dat" VARCHAR,
"insta_filter_used" VARCHAR,
"photo_type" VARCHAR
);
CREATE TABLE comments (
"id" BIGINT,
"comment" VARCHAR,
"user_id" BIGINT,
"photo_id" BIGINT,
"created_timestamp" VARCHAR,
"posted_date" VARCHAR,
"emoji_used" VARCHAR,
"hashtags_used_count" BIGINT
);
Anyone who has the link will be able to view this.