ssomemunity
Tables (5)
answer
- answer_id — BIGINT — Primary key — NOT NULL
- content — TEXT — NOT NULL
- question_id — BIGINT — Foreign key → question.question_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
member
- member_id — BIGINT — Primary key — NOT NULL
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255)
- nickname — VARCHAR(30) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_id — VARCHAR(100)
- refresh_token — VARCHAR(500)
- created_at — DATETIME — NOT NULL
question
- question_id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- category — VARCHAR(20) — NOT NULL
- view_count — INT — NOT NULL
- like_count — INT — NOT NULL
- report_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
question_like
- like_id — BIGINT — Primary key — NOT NULL
- question_id — BIGINT — Foreign key → question.question_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- created_at — DATETIME — NOT NULL
report
- report_id — BIGINT — Primary key — NOT NULL
- question_id — BIGINT — Foreign key → question.question_id — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- reason — VARCHAR(200)
- created_at — DATETIME — NOT NULL