board

Tables (3)

comment (댓글)

  • commentId (comment_id) — bigint — Primary key — NOT NULL — AUTO_INCREMENT
  • commentContent (content) — varchar(255) — NOT NULL
  • parentId (parent_id) — bigint — Foreign key → comment.commentId — FK(self)
  • postId (post_id) — bigint — Foreign key → post.postId — NOT NULL — FK(post)
  • authorId (author_id) — bigint — Foreign key → user.userId — NOT NULL — FK(user)

post (게시글)

  • postId (post_id) — bigint — Primary key — NOT NULL — AUTO_INCREMENT
  • postTitle (title) — varchar(50) — NOT NULL
  • postContent (content) — text — NOT NULL
  • category — varchar(10) — NOT NULL
  • bookmarked — boolean — NOT NULL
  • authorId (author_id) — bigint — Foreign key → user.userId — NOT NULL — FK(user)

user (사용자)

  • userId (user_id) — bigint — Primary key — NOT NULL — AUTO_INCREMENT
  • userName (name) — varchar(10) — NOT NULL
  • password — varchar(15) — NOT NULL