2NE1

Tables (10)

ANSWERS (답변정보)

  • answer_id (답변식별자) — Primary key
  • question_id (질문식별자) — Foreign key → QUESTIONS.question_id
  • user_id (회원식별자) — Foreign key → USERS.user_id
  • contents (답변내용) — 500
  • likes_count (추천수)
  • unlikes_count (비추천수)
  • choose_YN (채택여부)
  • image_url (이미지경로) — 255
  • created_at (생성일)
  • modified_at (수정일)

ANSWER_COMMENTS (답변댓글정보)

  • comment_id (댓글식별자) — Primary key
  • answer_id (답변식별자) — Foreign key → ANSWERS.answer_id
  • user_id (회원식별자) — Foreign key → USERS.user_id
  • comments (댓글) — 255
  • created_at (생성일)
  • modified_at (수정일)

ANSWER_LIKES (답변좋아요정보)

  • answer_id (답변식별자) — Foreign key → ANSWERS.answer_id
  • user_id (회원식별자) — Foreign key → USERS.user_id
  • like_YN (추천여부)
  • unlike_YN (비추천여부)

BOOKMARKS (북마크정보)

  • bookmark_id (북마크식별자) — Primary key
  • question_id (질문식별자) — Foreign key → QUESTIONS.question_id
  • user_id (회원식별자) — Foreign key → USERS.user_id
  • answer_id (답변식별자) — Foreign key → ANSWERS.answer_id

QUESTIONS (질문정보)

  • question_id (질문식별자) — Primary key
  • user_id (회원식별자) — Foreign key → USERS.user_id
  • title (제목) — 255
  • contents (질문내용) — 500
  • answer_YN (답변여부)
  • views (조회수)
  • likes_count (추천수)
  • unlikes_count (비추천수)
  • image_url (이미지경로) — 255
  • created_at (생성일)
  • modified_at (수정일)

QUESTION_COMMENTS (질문댓글정보)

  • comment_id (댓글식별자) — Primary key
  • question_id (질문식별자) — Foreign key → QUESTIONS.question_id
  • user_id (회원식별자) — Foreign key → USERS.user_id
  • comments (댓글) — 255
  • created_at (생성일)
  • modified_at (수정일)

QUESTION_LIKES (질문좋아요정보)

  • question_id (질문식별자) — Foreign key → QUESTIONS.question_id
  • user_id (회원식별자) — Foreign key → USERS.user_id
  • like_YN (추천여부)
  • unlike_YN (비추천여부)

REFRESH_TOKEN (토큰정보)

  • refresh_token_id (토큰식별자) — Primary key
  • refresh_token (리프레시토큰) — 255
  • token_email (이메일토큰) — 255

TAGS (태그정보)

  • tag_id (태그식별자) — Primary key
  • title (제목) — 255
  • comments (설명) — 500
  • tag_count (사용횟수)
  • latest (최근사용일)
  • question_id (질문식별자) — Foreign key → QUESTIONS.question_id

USERS (회원정보)

  • user_id (회원식별자) — Primary key
  • email (이메일) — 255
  • password (비밀번호) — 255
  • nickname (닉네임) — 255
  • created_at (생성일)
  • modified_at (수정일)
  • refresh_token (토큰정보) — 1000