Blog
Tables (6)
BaseEntity (기본 엔티티)
- createDate (생성 날짜) — DateTime
- modifiedDate (수정 날짜) — DateTime
Board (게시글)
- id (PK) — Long — Primary key — NOT NULL
- member_id (FK) — Long — Foreign key → Member.id — NOT NULL
- title (제목) — String
- content (내용) — String
- count (좋아요 수) — int
Member (회원)
- id (PK) — Long — Primary key — NOT NULL
- username (회원 계정) — String
- password (비밀번호) — String
- email (이메일) — String
MemberRole (회원 권한)
- id (PK) — Long — Primary key — NOT NULL
- member_id (FK) — Long — Foreign key → Member.id — NOT NULL
- role_id (FK2) — Long — Foreign key → Role.id — NOT NULL
Role (권한)
- id (PK) — Long — Primary key — NOT NULL
- role_type (권한 종류) — RoleType
RoleType (권한 종류)
- ADMIN (운영자) — String
- MANAGER (관리자) — String
- USER (사용자) — String