DIA

developer interview assistant

Tables (9)

answer (유저 답변)

  • id (Key) — Primary key — NOT NULL
  • answer (답변)
  • ispublic (공개여부) — Boolean

answer_like (유저 답변 좋아요)

  • id (Key) — Primary key — NOT NULL
  • question_id (Field)
  • userId (좋아요 누른 유저)

auth_token (Untitled)

  • id (Key) — Primary key — NOT NULL
  • user_id (유저 id)
  • access (access token)
  • refresh (refresh token)

category (질문 카테고리)

  • id (Key) — Primary key — NOT NULL
  • first_category (1차 분류)
  • second_category (2차 분류)

question (질문)

  • id (Key) — Primary key — NOT NULL
  • question (질문)
  • index_id (카테고리 id)

question_bookmark (질문 북마크)

  • Key — Primary key — NOT NULL
  • user_id (Field)
  • question_id (Field2)

question_view_user (질문 본 유저)

  • Key — Primary key — NOT NULL
  • user_id (유저id)
  • question_id (질문id)

user (유저)

  • id (Key) — Primary key — NOT NULL
  • github_id (깃허브 아이디)
  • from (소셜 로그인 도메인)
  • social_token (소셜 로그인 토큰)

user_index_bookmark ((유저) 카테고리 북마크)

  • id (Key) — Primary key — NOT NULL
  • user_id (유저 id)
  • index_id (카테고리 id)