CRUD

Tables (4)

BaseEntity

  • Field (createdDate) — LocalDateTime
  • Field (lastModified) — LocalDateTime

Board

  • PK (board_id) — Long — Primary key — NOT NULL
  • FK (member_id) — Long — Foreign key → Member.PK — NOT NULL
  • Field (content) — String — NOT NULL
  • Field (title) — String
  • Field (comments) — List<String>

Comment

  • PK (comment_id) — Long — Primary key — NOT NULL
  • FK (board_id) — Long — Foreign key → Board.PK — NOT NULL
  • FK (member_id) — Long — Foreign key → Member.PK — NOT NULL
  • Field (comment) — Strng

Member

  • PK (member_id) — Long — Primary key — NOT NULL
  • Field (username) — String
  • Field (password) — String
  • Field (nickname) — String
  • Field (email) — String
  • Field (role) — Role