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