연습3

테이블 (5)

board

  • board_id — INT — 기본 키 — NOT NULL
  • cate_id — INT — 외래 키 → category.cate_id — NOT NULL
  • board_name — VARCHAR(20) — NOT NULL
  • write_permission — ENUM('admin', 'member') — NOT NULL

category

  • cate_id — INT — 기본 키 — NOT NULL
  • cate_name — VARCHAR(20) — NOT NULL

comment

  • comment_id — INT — 기본 키 — NOT NULL
  • post_id — INT — 외래 키 → post.post_id — NOT NULL
  • id — INT — 외래 키 → user.id — NOT NULL
  • nickname — VARCHAR(50)
  • content — VARCHAR(1000) — NOT NULL
  • created_date — DATETIME — NOT NULL

post

  • post_id — INT — 기본 키 — NOT NULL
  • board_id — INT — 외래 키 → board.board_id — NOT NULL
  • id — INT — 외래 키 → user.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • region — VARCHAR(20)
  • travel_start — DATE
  • travel_end — DATE
  • personnel — INT
  • content — VARCHAR(4000) — NOT NULL
  • nickname — VARCHAR(50)
  • image_path — VARCHAR(255)
  • created_date — DATETIME — NOT NULL
  • views — INT

user

  • id — INT — 기본 키 — NOT NULL
  • user_id — VARCHAR(20) — NOT NULL
  • password — VARCHAR(20) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • nickname — VARCHAR(50)
  • phone_number — VARCHAR(20)
  • email — VARCHAR(50) — NOT NULL
  • role — ENUM('admin', 'member') — NOT NULL