썸뮤니티
테이블 (3)
answer
- answer_id — BIGINT — 기본 키 — NOT NULL
- content — TEXT — NOT NULL
- question_id — BIGINT — 외래 키 → question.question_id — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
member
- member_id — BIGINT — 기본 키 — NOT NULL
- username — VARCHAR(50) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(30) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- role — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
question
- question_id — BIGINT — 기본 키 — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- member_id — BIGINT — 외래 키 → member.member_id — NOT NULL
- view_count — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME