2
Tables (11)
comment
- comment_id — int — Primary key — NOT NULL
- content — varchar(200)
- parrent_id — int
- user_id — int — NOT NULL
- post_id — int — NOT NULL
follow
- follow_id — int — Primary key — NOT NULL
- follower_id — int — NOT NULL
- following_id — int — NOT NULL
hashtag
- hashtag_id — int — Primary key — NOT NULL
- hashtag — varchar(30)
image
- image_id — int — Primary key — NOT NULL
- file_name — varchar(200)
- post_id — int — NOT NULL
post
- post_id — int — Primary key — NOT NULL
- content — text
- location — varchar(30)
- user_id — int — NOT NULL
post_hashtag
- post_hashtag_id — int — Primary key — NOT NULL
- post_id — int — NOT NULL
- hashtag_id2 — int — NOT NULL
user
- user_id — int — Primary key — NOT NULL
- email — varchar(50)
- password — varchar(200)
- phone — varchar(11)
- gender — enum
- birth — timestamp
- name — varchar(10) — NOT NULL
- nickname — varchar(10)
- website — varchar(50)
- introduce — varchar(100)
- profile_image — text
user_comment_like
- user_comment_like_id — int — Primary key — NOT NULL
- user_id — int — NOT NULL
- comment_id — int — NOT NULL
user_comment_tag
- user_comment_tag_id — int — Primary key — NOT NULL
- user_id — int — NOT NULL
- comment_id — int — NOT NULL
user_post_like
- user_post_like_id — int — Primary key — NOT NULL
- user_id — int — NOT NULL
- post_id — int — NOT NULL
user_post_tag
- user_post_tag_id — int — Primary key — NOT NULL
- user_id — int — NOT NULL
- post_id — int — NOT NULL