CRUD

Tables (4)

Comment (댓글)

  • 댓글ID (commentID) — LONG — Primary key — NOT NULL
  • 댓글내용 (context) — STRING — NOT NULL
  • 게시글ID (postId) — LONG — Foreign key → Post.게시글ID — NOT NULL
  • 유저ID (userID) — LONG — Foreign key → User.유저ID — NOT NULL

Like (좋아요)

  • 좋아요ID (likeID) — LONG — Primary key — NOT NULL
  • 유저ID (userID) — LONG — Foreign key → User.유저ID — NOT NULL
  • 게시글ID (postId) — LONG — Foreign key → Post.게시글ID — NOT NULL

Post (게시글)

  • 게시글ID (postId) — LONG — Primary key — NOT NULL
  • 제목 (title) — STRING — NOT NULL
  • 내용 (context) — STRING — NOT NULL
  • 유저ID (userID) — LONG — Foreign key → User.유저ID — NOT NULL

User (유저)

  • 유저ID (userID) — LONG — Primary key — NOT NULL
  • 로그인아이디 (userName) — STRING — NOT NULL
  • 비밀번호 (password) — STRING — NOT NULL
  • 별명 (nickname) — STRING — NOT NULL