db project

테이블 (4)

Copy Of Untitled (reply)

  • Key (reply_id) — INT — 기본 키 — NOT NULL
  • Key (post_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (author_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (importance_id) — INT — 외래 키 → 중요도.Key — NOT NULL
  • Field (created_time) — datetime
  • Field (updated_time) — datetime
  • Field (content) — TEXT
  • Field (view_count) — INT
  • Field (help_count) — INT

Untitled (post)

  • Key (post_id) — INT — 기본 키 — NOT NULL
  • Key (author_id) — INT — 외래 키 → Untitled.Key — NOT NULL
  • Key (importance_id) — INT — 외래 키 → 중요도.Key — NOT NULL
  • Field (created_time) — datetime
  • Field (updated_time) — datetime
  • Field (content) — TEXT
  • Field (title) — TEXT
  • Field (view_count) — INT
  • Field (help_count) — INT

Untitled (users)

  • Key (user_id) — INT — 기본 키 — NOT NULL
  • Field (username) — VARCHAR
  • Field2 (password) — VARCHAR
  • Field (name) — VARCHAR
  • Field (type) — INT
  • Field (birth) — VARCHAR
  • Field (sex) — VARCHAR
  • Field (address) — VARCHAR
  • Field (phone) — VARCHAR

중요도 (importance)

  • Key (importance_id) — INT — 기본 키 — NOT NULL
  • Field (score) — INT
  • Field2 (last_updated) — DateTime