1

Tables (4)

Board (my_board)

  • Board Id (board_id) — INT(11) — Primary key — NOT NULL
  • Board Name (board_name) — VARCHAR(255)
  • Created Date (created_date) — CHAR(8)

Member (my_member)

  • Member Id (member_id) — INT(11) — Primary key — NOT NULL
  • Last Name (last_name) — VARCHAR(255)
  • First Name (first_name) — VARCHAR(255)
  • Email (email) — VARCHAR(100)
  • Gender (gender) — CHAR(1)
  • Birthday (birthdat) — CHAR(8)

Post (my_post)

  • Post Id (post_id) — INT(11) — Primary key — NOT NULL
  • Member Id (member_id) — INT(11) — Foreign key → Member.Member Id — NOT NULL
  • Board Id (board_id) — INT(11) — Foreign key → Board.Board Id — NOT NULL
  • Post Name (post_name) — VARCHAR(255)
  • Title (title) — VARCHAR(100)
  • Content (content)

Untitled