404wefound_3
Tables (8)
answer_comments
- answer_comment_id — BIGINT — Primary key
- user_id — BIGINT — Foreign key → users.user_id
- answer_id — BIGINT — Foreign key → answers.answer_id
- content — TEXT
- created_at — DATETIME
- updated_at — DATETIME
answer_liked_users
- answer_id — BIGINT — Foreign key → answers.answer_id
- user_id (liked_users) — BIGINT — Foreign key → users.user_id
answers
- answer_id — BIGINT — Primary key
- user_id — BIGINT — Foreign key → users.user_id
- question_id — BIGINT — Foreign key → questions.question_id
- content — TEXT
- created_at — DATETIME
- updated_at — DATETIME
comments
- comment_id — BIGINT — Primary key
- user_id — BIGINT — Foreign key → users.user_id
- question_id — BIGINT — Foreign key → questions.question_id
- content — TEXT — NOT NULL
- create_at — DATETIME
points
- point_id — BIGINT — Primary key
- user_id — BIGINT — Foreign key → users.user_id
- point — BIGINT
- reason — VARCHAR(255)
- created_at — DATETIME
premium_questions
- premium_question_id — BIGINT — Primary key
- user_id — BIGINT — Foreign key → users.user_id
- title — VARCHAR(255)
- content — TEXT
- created_at — DATETIME
- updated_at — DATETIME
questions
- question_id — BIGINT — Primary key
- user_id — BIGINT — Foreign key → users.user_id
- title — VARCHAR(255)
- content — TEXT
- created_at — DATETIME
- updated_at — DATETIME
users
- user_id — BIGINT — Primary key
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(255) — NOT NULL
- role — VARCHAR(255) — NOT NULL
- grade — VARCHAR(255)
- point — BIGINT
- create_at — DATETIME
- update_at — DATETIME