정승우_board

테이블 (5)

categories

  • Category_Id (category_id) — INT — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL

comments

  • Comment_Id (comment_id) — INT — 기본 키 — NOT NULL
  • content — TEXT — NOT NULL
  • Post_Id (post_id) — INT — 외래 키 → posts.Post_Id — NOT NULL
  • User_Id (user_id) — INT — 외래 키 → users.User_Id — NOT NULL

posts

  • Post_Id (post_id) — INT — 기본 키 — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • content — TEXT — NOT NULL
  • Category_Id (category_id) — INT — 외래 키 → categories.Category_Id — NOT NULL
  • User_Id (user_id) — INT — 외래 키 → users.User_Id — NOT NULL

replies

  • id — INT
  • content — TEXT — NOT NULL
  • Comment_Id (comment_id) — INT — 외래 키 → comments.Comment_Id — NOT NULL
  • User_Id (user_id) — INT — 외래 키 → users.User_Id — NOT NULL

users

  • User_Id (user_id) — INT — 기본 키 — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(50) — NOT NULL
  • password — VARCHAR(255) — NOT NULL