404wefound
Tables (6)
answer
- answer_id — BIGINT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- question_id (question_id2) — BIGINT — Foreign key → question.question_id — NOT NULL
- user_id (user_id2) — BIGINT — Foreign key → users.user_id — NOT NULL
answer_comment
- answer_comment_id — BIGINT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- answer_id (answer_id2) — BIGINT — Foreign key → answer.answer_id — NOT NULL
- user_id (user_id2) — BIGINT — Foreign key → users.user_id — NOT NULL
comment
- comment_id — BIGINT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at (Field) — TIMESTAMP — NOT NULL
- user_id (user_id2) — BIGINT — Foreign key → users.user_id — NOT NULL
- question_id (question_id2) — BIGINT — Foreign key → question.question_id — NOT NULL
points
- point_id — BIGINT — Primary key — NOT NULL
- point — BIGINT — NOT NULL
- reason — VARCHAR(255)
- created_at — DATETIME — NOT NULL
- user_id (user_id2) — BIGINT — Foreign key → users.user_id — NOT NULL
question
- question_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- user_id (user_id2) — BIGINT — Foreign key → users.user_id — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- role — VARCHAR(255) — NOT NULL
- grade — VARCHAR(255) — NOT NULL
- point — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL