멘토링 과제

테이블 (5)

USER

  • ID — INT UNSIGNED — 기본 키 — NOT NULL
  • ACCOUNT_ID — VACHAR(12)
  • PASSWORD — VACHAR(20)
  • NICKNAME — VACHAR(24)
  • MAIL — VACHAR(320)
  • WRITTEN_TIME — TIMESTAMP
  • UPDATE_TIME — TIMESTAMP
  • DEL_REQ_TIME — TIMESTAMP

게시물 (POST)

  • ID — BIGINT UNSIGNED — 기본 키 — NOT NULL
  • TITLE — VARCHAR
  • CONTENT — TEXT
  • WRITTEN_TIME — TIMESTAMP
  • UPDATE_TIME — TIMESTAMP
  • NON_MEM_NICK — VHARCHAR(24)
  • NON_MEM_PW — VHARCHAR(20)
  • WRITTEN_USER_ID — INT UNSIGNED — 외래 키 → USER.ID — NOT NULL
  • BOARD_ID — SMALL_INT — 외래 키 → 게시판.ID — NOT NULL

게시판 (BOARD)

  • ID — SMALL_INT — 기본 키 — NOT NULL
  • NAME — VARCHAR(40)
  • DESCRIPTION — VARCHAR(255)

댓글 (REPLY)

  • ID — BIGINT UNSIGNED — 기본 키 — NOT NULL
  • CONTENT — VARCHAR(255)
  • WRITTEN_TIME — TIMESTAMP
  • UPDATE_TIME — TIMESTAMP
  • NON_MEM_NICK — VARCHAR(24)
  • NON_MEM_PW — VARCHAR(20)
  • POST_ID — BIGINT UNSIGNED — 외래 키 → 게시물.ID — NOT NULL
  • WRITTEN_USER_ID — INT UNSIGNED — 외래 키 → USER.ID — NOT NULL

이미지 (IMAGE)

  • ID — 기본 키 — NOT NULL
  • PATH — VACHAR(300)
  • POST_ID — BIGINT UNSIGNED — 외래 키 → 게시물.ID — NOT NULL