BE

Tables (4)

Board (게시판)

  • BoardId (게시판 식별키) — Primary key — NOT NULL
  • BoardName (게시판 이름)

Comments (댓글)

  • CommentId (댓글 식별키) — Primary key — NOT NULL
  • Content (내용)
  • UserId (유저 식별키) — Foreign key → User.UserId — NOT NULL
  • PostId (글 식별키) — Foreign key → Post.PostId — NOT NULL

Post (글)

  • PostId (글 식별키) — Primary key — NOT NULL
  • Content (내용)
  • UserId (유저 식별키) — Foreign key → User.UserId — NOT NULL
  • BoardId (게시판 식별키) — Foreign key → Board.BoardId — NOT NULL

User (유저)

  • UserId (유저 식별키) — Primary key — NOT NULL
  • UserName (유저 이름)