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