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