popo

Tables (6)

comment

  • comment_id — int — Primary key — NOT NULL
  • email — varchar(50) — Foreign key → user.email
  • post_id — int — Foreign key → post.post_id — NOT NULL
  • nickname — varchar(50) — Foreign key → user.nickname — NOT NULL
  • content — varchar(300)
  • created_at — datetime
  • modified_at — datetime

notice

  • ntice_id — int — Primary key — NOT NULL
  • title — varchar(100)
  • content — varchar(5000)
  • created_at
  • modified_at

post

  • post_id — int — Primary key — NOT NULL
  • email — varchar(50) — Foreign key → user.email
  • nickname — varchar(50) — Foreign key → user.nickname — NOT NULL
  • content — varchar(300)
  • image_url — varchar(800)
  • category — varchar(50)
  • created_at — datetime
  • modified_at — datetime
  • like_count — int

user

  • email — varchar(50) — Primary key
  • nickname — varchar(50) — Primary key — NOT NULL
  • password — varchar(200)
  • phone — varchar(11)
  • introduce — varchar(200)
  • gender — enum
  • profile_image — varchar(200)
  • role — enum
  • visit_count — int
  • post_count — int
  • follower_count — int
  • following_count — int

user_follow

  • follow_id — int — Primary key — NOT NULL
  • follower — varchar(50) — Foreign key — NOT NULL — 팔로우를 신청한 user_id
  • email — varchar(50) — Foreign key → user.email
  • is_follow — tinyint — NOT NULL

user_post_like

  • post_like_id — int — Primary key — NOT NULL
  • post_id — int — Foreign key → post.post_id — NOT NULL
  • email — varchar(50) — Foreign key → user.email
  • is_liked — tinyint — NOT NULL