fix kakao1

Tables (5)

comment_likes

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • comment_id — BIGINT — NOT NULL
  • created_at — DATETIME(3) — NOT NULL

comments

  • id — BIGINT
  • post_id — BIGINT — NOT NULL
  • author_id — BIGINT — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL

post_likes

  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • post_id — BIGINT — NOT NULL
  • created_at — DATETIME(3) — NOT NULL

posts

  • id — BIGINT
  • author_id — BIGINT — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — MEDIUMTEXT — NOT NULL
  • image — VARCHAR(255)
  • like_count — BIGINT — NOT NULL
  • view_count — BIGINT — NOT NULL
  • comment_count — BIGINT — NOT NULL
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL

users

  • id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(50) — NOT NULL
  • profile_image — VARCHAR(255)
  • role — ENUM('USER','ADMIN') — NOT NULL
  • status — ENUM('ACTIVE','BANNED','DELETED') — NOT NULL
  • created_at — DATETIME(3) — NOT NULL
  • updated_at — DATETIME(3) — NOT NULL
  • last_login_at — DATETIME(3)