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