pre
Tables (8)
answer
- answer_id — bigint — Primary key — NOT NULL — PK
- user_id — bigint — NOT NULL — FK
- question_id — bigint — NOT NULL — FK
- content — text
- created_at — datetime
- updated_at — datetime
comment
- comment_id — bigint — Primary key — NOT NULL — PK
- author_id — bigint — NOT NULL — FK
- answer_id — bigint — NOT NULL — FK
- question_id — bigint — NOT NULL — FK
- content — text
- createdAt — datetime
- updatedAt — datetime
question
- question_id — bigint — Primary key — NOT NULL — PK
- author_id — bigint — NOT NULL — FK
- title — varchar
- content — text
- clicks — bigint
- created_at — datetime
- updated_at — datetime
question_tag
- question_tag_id — bigint — Primary key — NOT NULL — PK
- question_id — bigint — NOT NULL — FK, UNI
- tag_id — bigint — NOT NULL — FK, UNI
- created_at — datetime
- updated_at — datetime
reputation
- reputation_id — bigint — Primary key — NOT NULL — PK
- user_id — bigint — NOT NULL — FK
- vote_id — bigint — NOT NULL — FK
- amount — int
- vote_id (vote_id2) — bigint — Foreign key → vote.vote_id — NOT NULL — PK
tag
- tag_id — bigint — Primary key — NOT NULL — PK
- name — varchar — UNI
- created_at — datetime
- updated_at — datetime
user
- user_id — bigint — Primary key — NOT NULL — PK
- email — varchar — UNI
- password — varchar
- display_name — varchar
- created_at — datetime
- updated_at — datetime
vote
- vote_id — bigint — Primary key — NOT NULL — PK
- user_id — bigint — NOT NULL — FK
- answer_id — bigint — NOT NULL — FK
- question_id — bigint — NOT NULL — FK
- amount — int — -1, 1
- created_at — datetime
- updated_at — datetime
- answer_id (answer_id2) — bigint — Foreign key → answer.answer_id — NOT NULL — PK
- question_id (question_id2) — bigint — Foreign key → question.question_id — NOT NULL — PK
- user_id (user_id2) — bigint — Foreign key → user.user_id — NOT NULL — PK