Board

Tables (6)

Board (게시판)

  • Id (board_Id) — Long — Primary key — NOT NULL
  • contents (내용) — String
  • title (제목) — String
  • Id (user_id) — Long — Foreign key → User.Id — NOT NULL

Comment (댓글)

  • id (comment_id) — Long — Primary key — NOT NULL
  • text (댓글내용) — String
  • Id (board_Id) — Long — Foreign key → Board.Id — NOT NULL
  • Id (user_id) — Long — Foreign key → User.Id — NOT NULL

Likes (좋아요)

  • id (likes_id) — Long — Primary key — NOT NULL
  • like (좋아요갯수) — Long
  • Id (board_Id) — Long — Foreign key → Board.Id — NOT NULL
  • id (comment_id) — Long — Foreign key → Comment.id — NOT NULL

Timestamped (시간)

  • createdAt (작성시간) — LocalDateTime
  • modifiedAt (수정시간) — LocalDateTime

User (회원)

  • Id (user_id) — Long — Primary key — NOT NULL
  • username (유저이름) — String
  • password (비밀번호) — String
  • user (일반유저) — String — Foreign key → UserRoleEnum.user — NOT NULL
  • admin (관리자) — String — Foreign key → UserRoleEnum.admin — NOT NULL

UserRoleEnum (권한)

  • user (일반유저) — String — Primary key — NOT NULL
  • admin (관리자) — String — Primary key — NOT NULL