UMC_Insta
Tables (10)
comment
- comment_id — int — NOT NULL
- user_id — int — NOT NULL
- post_id — int — NOT NULL
- comment_text — text — NOT NULL
- created_at — datetime
comment_heart
- cheart_id — int — NOT NULL
- comment_id — int — NOT NULL
- user_id — int — NOT NULL
comment_reply
- reply_id — int — NOT NULL
- comment_id — int — NOT NULL
- user_id — int — NOT NULL
- post_id — int — NOT NULL
- reply_text — text — NOT NULL
- created_at — datetime
follower_info
- follower_id — int — Primary key — NOT NULL
- user_id — int — Primary key — NOT NULL
- fller_userid — int — NOT NULL
following_info
- following_id — int — Primary key — NOT NULL
- user_id — int — Primary key — NOT NULL
- flling_userid — int — NOT NULL
post
- post_id — int — NOT NULL
- user_id — int — NOT NULL
- post_text — text
- postimg_url — varchar(40)
- postvid_url — varchar(40)
- updated_at — datetime
- created_at — datetime
post_heart
- pheart_id — int — NOT NULL
- post_id — int — NOT NULL
- user_id — int — NOT NULL
story
- story_id — int — NOT NULL
- user_id — int — NOT NULL
- story_text — text
- storyimg_url — varchar(40)
- storyvid_url — varchar(40)
- updated_at — datetime
- created_at — datetime
- oneday — boolean — NOT NULL
user
- user_id — int — NOT NULL
- phone — varchar(15)
- username — varchar(30) — NOT NULL
- email — varchar(40)
- password — varchar(30) — NOT NULL
- created_at — datetime
- userinfo_id — int — NOT NULL
user_info
- userinfo_id — int — NOT NULL
- nickname — varchar(30) — NOT NULL
- fb_link — varchar(40)
- website_url — varchar(40)
- intro_cmnt — tinytext
- profileimg_url — varchar(40)