게시판

테이블 (3)

Post

  • id — BIGINT — 기본 키 — NOT NULL
  • title — varchar
  • content — varchar
  • created date (created_date) — DATETIME
  • modified date (modified_date) — DATETIME
  • removed date (removed_dat3e) — DATETIME
  • id (user_id) — BIGINT — 외래 키 → User.id — NOT NULL

Untitled (Comment)

  • Key (id) — BIGINT — 기본 키 — NOT NULL
  • Field (content) — varchar
  • Field (created_date) — DATETIME
  • Field (modified_date) — DATETIME
  • Field (removed_date) — DATETIME
  • Field
  • id (post_id) — BIGINT — 외래 키 → Post.id — NOT NULL
  • id (user_id) — BIGINT — 외래 키 → User.id — NOT NULL

User

  • id — BIGINT — 기본 키 — NOT NULL
  • user id (user_id) — varchar
  • password — varchar
  • created date (created_date) — DATETIME
  • modified date (modified_date) — DATETIME
  • removed date (removed_dat3e) — DATETIME
  • role — varchar