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