W6-QPort

Tables (4)

Answers

  • Key (answerId) — INT — Primary key — NOT NULL
  • Key (userId) — INT — Foreign key → Users.Key — NOT NULL
  • Key (questionId) — INT — Foreign key → Questions.Key — NOT NULL
  • Field (nickname) — VARCHAR(16) — NOT NULL
  • Field (avatar) — TEXT — NOT NULL
  • Field (content) — TEXT — NOT NULL
  • Field (imgUrl) — TEXT
  • Field (createdAt) — TEXT — NOT NULL
  • Field (updatedAt) — TEXT — NOT NULL

QnaViews

  • Key (id) — INT — Primary key — NOT NULL
  • Key (questionId) — INT — Foreign key → Questions.Key — NOT NULL
  • Field (ip) — TEXT — NOT NULL
  • Field2 (time) — TEXT — NOT NULL
  • Key (userId) — INT — Foreign key → Questions.Key — NOT NULL

Questions

  • Key (questionId) — INT — Primary key — NOT NULL
  • Key (userId) — INT — Foreign key → Users.Key — NOT NULL
  • Field (nickname) — VARCHAR(16) — NOT NULL
  • Field (avatar) — TEXT
  • Field (title) — VARCHAR(32) — NOT NULL
  • Field (content) — TEXT — NOT NULL
  • Field (imgUrl) — TEXT
  • Field (selectedAnswer) — INT — NOT NULL
  • Field (answerCount) — INT — NOT NULL
  • Field (view) — INT — NOT NULL
  • Field (createdAt) — TEXT — NOT NULL
  • Field (updatedAt) — TEXT — NOT NULL

Users

  • Key (userId) — INT — Primary key — NOT NULL
  • Field (email) — VARCHAR(64) — NOT NULL
  • Field (password) — VARCHAR(128) — NOT NULL
  • Field (nickname) — VARCHAR(16) — NOT NULL
  • Field (avatar) — TEXT — NOT NULL
  • Field (selectedAnswer) — INT — NOT NULL
  • Field (createdAt) — TEXT — NOT NULL
  • Field (updatedAt) — TEXT — NOT NULL