BlogAppication

테이블 (5)

게시판 (board)

  • board_id — bigint — 기본 키 — NOT NULL
  • created_time — datetime(6)
  • last_modified_time — datetime(6)
  • title — varchar(255)
  • content — tinytext
  • member_id (member_id2) — bigint — 외래 키 → 회원.member_id — NOT NULL

대댓글 (re_reply)

  • id — bigint — 기본 키 — NOT NULL
  • created_time — datetime(6)
  • last_modified_time — datetime(6)
  • content — varchar(255)
  • member_id — bigint — 외래 키 → 회원.member_id — NOT NULL
  • reply_id — bigint — 외래 키 → 댓글.reply_id — NOT NULL

댓글 (reply)

  • reply_id — bigint — 기본 키 — NOT NULL
  • is_deleted — bit — NOT NULL
  • like_count — integer — NOT NULL
  • re_reply_count — integer — NOT NULL
  • created_time — datetime(6)
  • last_modified_time — datetime(6)
  • content — varchar(255)
  • board_id — bigint — 외래 키 → 게시판.board_id — NOT NULL
  • member_id — bigint — 외래 키 → 회원.member_id — NOT NULL

좋아요 로그 (reply_like_log)

  • id — bigint — 기본 키 — NOT NULL
  • member_id — bigint — 외래 키 → 회원.member_id — NOT NULL
  • reply_id — bigint — 외래 키 → 댓글.reply_id — NOT NULL

회원 (member)

  • member_id — bigint — 기본 키 — NOT NULL
  • created_time — datetime(6)
  • last_modified_time — datetime(6)
  • account — varchar(255) — NOT NULL
  • email — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • role — enum