SEBP
Tables (6)
Answer (답)
- answer_id (정답아이디) — VARCHAR — Primary key — NOT NULL
- content (댓글) — VARCHAR
- like_count (좋아요수) — INT
- accepted (승인여부) — Boolean
- created_at (생성날짜) — DATETIME
- user_id (사용자_아이디) — VARCHAR — Foreign key → User.user_id — NOT NULL
- question_id (질문아이디) — VARCHAR — Foreign key → Question.question_id — NOT NULL
Comment (댓글)
- comment_id (댓글아이디) — VARCHAR — Primary key — NOT NULL
- content (댓글) — VARCHAR
- created_at (생성날짜) — DATETIME
- user_id (사용자_아이디) — VARCHAR — Foreign key → User.user_id — NOT NULL
- question_id (질문아이디) — VARCHAR — Foreign key → Question.question_id — NOT NULL
- answer_id (정답아이디) — VARCHAR — Foreign key → Answer.answer_id — NOT NULL
Question (질문)
- question_id (질문아이디) — VARCHAR — Primary key — NOT NULL
- title (제목) — VARCHAR
- content (댓글) — VARCHAR
- category (항목) — ENUM
- view_count (조회수) — INT
- created_at (생성날짜) — DATETIME
- user_id (사용자_아이디) — VARCHAR — Foreign key → User.user_id — NOT NULL
- question_tag_id (질문태그아이디) — VARCHAR — Foreign key → Question_Tag.question_tag_id — NOT NULL
Question_Tag (질문태그)
- question_tag_id (질문태그아이디) — VARCHAR — Primary key — NOT NULL
Tag (태그)
- tag_id (태그아이디) — VARCHAR — Primary key — NOT NULL
- name (이름) — VARCHAR
- question_tag_id (질문태그아이디) — VARCHAR — Foreign key → Question_Tag.question_tag_id — NOT NULL
User (사용자)
- user_id (사용자_아이디) — VARCHAR — Primary key — NOT NULL
- email (이메일) — VARCHAR
- password (비밀번호) — VARCHAR
- nickname (별명) — VARCHAR
- role (역할) — ENUM
- point (점수) — INT
- created_at (생성날짜) — DATETIME