게시판 만들기

테이블 (3)

Untitled (user)

  • user_id — int — 기본 키 — NOT NULL
  • Field (username) — String
  • Field (password) — String
  • Field (email) — String
  • Field (created_date) — DateTime
  • Field (modified_date) — DateTime
  • Field

Untitled (board)

  • Key (board_id) — int — 기본 키 — NOT NULL
  • user_id (user_id2) — int — 외래 키 → Untitled.user_id — NOT NULL
  • Key2 (title) — String — NOT NULL
  • Field (content) — String
  • Field (created_date) — DateTime
  • Field (modified_date) — DateTime
  • Field (created_by) — int
  • Field (updated_by) — int

comment

  • Key (comment_id) — int — 기본 키 — NOT NULL
  • user_id — int — 외래 키 → Untitled.user_id — NOT NULL
  • Key (board_id2) — int — 외래 키 → Untitled.Key — NOT NULL
  • Field (content) — String
  • Field (created_date) — DateTime
  • Field (modified_date) — DateTime
  • Field (created_by) — int
  • Field2 (updated_by) — int