wanted

Tables (3)

board (게시판)

  • board_id (게시판ID) — Bigint — Primary key — NOT NULL
  • member_id (회원ID) — Bigint — Foreign key → member.member_id — NOT NULL
  • title (제목) — Varchar
  • content (내용) — Varchar
  • board_deleted (논리적 삭제) — Boolean
  • create_date (생성일) — DateTime
  • modified_date (수정일) — DateTime

member (회원)

  • member_id (회원ID) — Bigint — Primary key — NOT NULL
  • email (이메일) — String
  • password (비밀번호) — String
  • phone (휴대폰 번호) — Int
  • create_date (생성일) — DateTime
  • modified_date (수정일) — DateTime

member_roles (권한)

  • member_id (회원ID) — Bigint — Foreign key → member.member_id — NOT NULL
  • roels (권한) — Varchar