CRUD

Tables (4)

BOARD

  • 게시물아이디 (board_id) — NOT NULL — Primary key — NOT NULL
  • 내용 (content) — NOT NULL
  • 생성일자 (creatAt) — NOT NULL
  • 수정일자 (modifiedAt) — NOT NULL
  • 멤버아이디 (member_id) — NOT NULL — Foreign key → MEMBER.멤버아이디 — NOT NULL

COMMENT

  • 댓글아이디 (comment_id) — NOT NULL — Primary key — NOT NULL
  • 댓글내용 (reply) — NOT NULL
  • 생성일자 (creatAt) — NOT NULL
  • 수정일자 (modifiedAt) — NOT NULL
  • 멤버아이디 (member_id) — NOT NULL — Foreign key → MEMBER.멤버아이디 — NOT NULL
  • 게시물아이디 (board_id) — NOT NULL — Foreign key → BOARD.게시물아이디 — NOT NULL

LIKE

  • 좋아요아이디 (like_id) — NOT NULL — Primary key — NOT NULL
  • 멤버아이디 (member_id) — NOT NULL — Foreign key → MEMBER.멤버아이디 — NOT NULL
  • 게시물아이디 (board_id) — NOT NULL — Foreign key → BOARD.게시물아이디 — NOT NULL

MEMBER

  • 멤버아이디 (member_id) — NOT NULL — Primary key — NOT NULL
  • 이메일 (email) — NOT NULL
  • 비밀번호 (password) — NOT NULL
  • 생성일자 (creatAt) — NOT NULL
  • 수정일자 (modifiedAt) — NOT NULL
  • 이름 (nickName) — NOT NULL