PrestackOverflow
Tables (6)
answer
- answer_id — BIGING — Primary key — NOT NULL
- question_id — BIGINT — Foreign key → question.question_id — NOT NULL
- member_id — BiGINT — Foreign key → member.member_id — NOT NULL
- content — VARCHAR
comment
- comment_id — BIGINT — Primary key — NOT NULL
- answer_id — BIGING — Foreign key → answer.answer_id — NOT NULL
- content — VARCHAR
like
- answer_id — BIGING — Foreign key → answer.answer_id — NOT NULL
- member_id — BiGINT — Foreign key → member.member_id — NOT NULL
member
- member_id — BiGINT — Primary key — NOT NULL
- username — VARCHAR
- password — VARCHAR
question
- question_id — BIGINT — Primary key — NOT NULL
- member_id — BiGINT — Foreign key → member.member_id — NOT NULL
- title — VARCHAR
- content — VARCHAR
tag
- tag_id — BIGINT — Primary key — NOT NULL
- question_id — BIGINT — Foreign key → question.question_id — NOT NULL
- tag_name — VARCHAR