board

테이블 (8)

게시글 (article)

  • articleId (Key) — Long — 기본 키 — NOT NULL
  • title (Field) — varchar(100)
  • content (Field2) — varchar(3000)
  • boardId (Field6) — Long
  • writerId (Field7) — Long
  • imageUrl (Field5) — varchar(3000)
  • createdAt (Field4) — LocalDateTime
  • modifiedAt (Field3) — LocalDateTime

게시글_댓글수 (article_comment_count)

  • articleId (Key) — Long — 기본 키 — NOT NULL
  • commentCount (Field) — Long

게시글_좋아요수 (article_like_count)

  • articleId (Key) — Long — 기본 키 — NOT NULL
  • likeCount (Field) — Long

게시판 (board)

  • boardId (Key) — Long — 기본 키 — NOT NULL
  • boardName (Field) — varchar(20)
  • articleCount (Field2) — Long

댓글 (comment)

  • commentId (Key) — Long — 기본 키 — NOT NULL
  • content (Field) — varchar(3000)
  • parentCommentId (Field2) — Long
  • articleId (Field5) — Long
  • writerId (Field6) — Long
  • deleted (Field3) — boolean
  • createdAt (Field4) — LocalDateTime

조회수 (article_view_count)

  • articleId (Key) — Long — 기본 키 — NOT NULL
  • viewCount (Field) — Long

좋아요 (article_like)

  • articleLikeId (Key) — Long — 기본 키 — NOT NULL
  • articleId (Field2) — Long
  • userId (Field3) — Long
  • createdAt (Field) — LocalDateTime

회원 (member)

  • memberId (Key) — Long — 기본 키 — NOT NULL
  • email (Field) — varchar(255)
  • password (Field2) — varchar(255)
  • nickname (Field3) — varchar(20)
  • createdAt (Field4) — LocalDateTime
  • ImageUrl (Field5) — varchar(3000)