Board

Tables (4)

Board (게시판)

  • board_Id (게시판id) — Long — Primary key — NOT NULL
  • username (회원이름) — String — Foreign key → User.username — NOT NULL
  • contents (내용) — String
  • title (제목) — String
  • user (회원) — User

Comment (댓글)

  • comment_Id (댓글id) — Long — Primary key — NOT NULL
  • board_Id (게시판id) — Long — Foreign key → Board.board_Id — NOT NULL
  • writer (댓글작성자) — String — Foreign key → Board.username — NOT NULL
  • text (댓글) — String

Timestamped (작성 날짜)

  • createdAt (작성날짜) — LocalDateTime
  • modifiedAt (수정날짜) — LocalDateTime

User (회원)

  • username (회원이름) — String — Primary key — NOT NULL
  • password (비밀번호) — String
  • role (권한) — UserRoleEnum