main16
Tables (9)
Copy Of vote (report)
- 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 (likeCnt) — int — -1, 1
- created_at — datetime
- updated_at — datetime
- question_id (article_id) — bigint — Foreign key → question.question_id — NOT NULL — PK
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 (article)
- question_id (article_id) — bigint — Primary key — NOT NULL — PK
- author_id — bigint — NOT NULL — FK
- title — varchar
- content — text
- clicks (views) — 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
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
- nickName — 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 (likeCnt) — int — -1, 1
- created_at — datetime
- updated_at — datetime
- question_id (article_id) — bigint — Foreign key → question.question_id — NOT NULL — PK