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)