포트폴리오

테이블 (5)

Board

  • board_id — Long — 기본 키 — NOT NULL
  • member_id — Long — 외래 키 → Member.member_id — NOT NULL
  • title — String
  • content — String
  • category — Category
  • likeCount — int — NOT NULL

Comment

  • Key — 기본 키 — NOT NULL
  • member_id — Long — 외래 키 → Member.member_id — NOT NULL
  • board_id — Long — 외래 키 → Board.board_id — NOT NULL
  • content — String
  • commenter — Member
  • likeCount — int — NOT NULL

Like

  • id — Long — 기본 키 — NOT NULL
  • member_id — Long — 외래 키 → Member.member_id — NOT NULL
  • board_id — Long — 외래 키 → Board.board_id — NOT NULL
  • member_id (member_id2) — Long — 외래 키 → Board.member_id — NOT NULL

Member

  • member_id — Long — 기본 키 — NOT NULL
  • username — String

Reply

  • id — Long — 기본 키 — NOT NULL
  • Key — 외래 키 → Comment.Key — NOT NULL
  • member_id — Long — 외래 키 → Comment.member_id — NOT NULL
  • content — String
  • Field2