likelion ERD 과제

테이블 (7)

board

  • id — BIGINT — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — LONGTEXT — NOT NULL
  • writer — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL

board_category

  • id — BIGINT — NOT NULL
  • board_id — BIGINT — 외래 키 → board.id — NOT NULL
  • category_id — BIGINT — 외래 키 → category.id — NOT NULL

board_detail

  • id — BIGINT — NOT NULL
  • board_id — BIGINT — 외래 키 → board.id — NOT NULL
  • view_count — INT — NOT NULL
  • like_count — INT — NOT NULL

board_tag

  • id — BIGINT — NOT NULL
  • board_id — BIGINT — 외래 키 → board.id — NOT NULL
  • tag_id — BIGINT — 외래 키 → tag.id — NOT NULL

category

  • id — BIGINT — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — LONGTEXT

comment

  • id — BIGINT — NOT NULL
  • board_id — BIGINT — 외래 키 → board.id — NOT NULL
  • content — LONGTEXT — NOT NULL
  • writer — VARCHAR(255) — NOT NULL

tag

  • id — BIGINT — NOT NULL
  • name — VARCHAR(255) — NOT NULL