Board

Tables (3)

Board

  • 게시판아이디 (board_id) — BIGINT — Primary key — NOT NULL
  • 멤버아이디 (member_id) — BIGINT — Foreign key → Member.멤버아이디 — NOT NULL
  • 제목 (title) — VERCHAR
  • 내용 (content) — VERCHAR
  • 해시태그 (hashtag) — VERCHAR
  • 생성일 (created_date) — DATETIME
  • 수정일 (modified_date) — DATETIME

Comment

  • 댓글아이디 (comment_id) — BIGINT — Primary key — NOT NULL
  • 멤버아이디 (member_id) — BIGINT — Foreign key → Member.멤버아이디 — NOT NULL
  • 게시판아이디 (board_id) — BIGINT — Foreign key → Board.게시판아이디 — NOT NULL
  • 댓글내용 (content) — VERCHAR
  • 생성일 (created_date) — DATETIME
  • 수정일 (modified_date) — DATETIME

Member

  • 멤버아이디 (member_id) — BIGINT — Primary key — NOT NULL
  • 이메일 (email) — VERCHAR
  • 비밀번호 (password) — VERCHAR
  • 닉네임 (nickname) — VERCHAR
  • 생성일 (created_date) — DATETIME
  • 수정일 (modified_date) — DATETIME