gss

Tables (7)

answer_ranking (대답 기록 로그)

  • id (대답로그id) — biginteger — Primary key — NOT NULL
  • question_id (Field)
  • pull_request_id (Field2)
  • user_id (Field3)
  • updated_at (Field4)

answers (대답)

  • id (대답 id) — biginteger — Primary key — NOT NULL
  • question_id (질문id) — biginteger — Foreign key → questions.id — NOT NULL
  • content (대답 내용) — TEXT — NOT NULL
  • created_at (생성 시각) — DATETIME — NOT NULL
  • updated_at (업데이트 시각) — DATETIME — NOT NULL

github_token (깃허브 토큰)

  • id (소설계정 id) — biginteger — Primary key — NOT NULL
  • user_id (회원 id) — biginteger — Foreign key → users.id — NOT NULL
  • token (깃허브 토큰) — VARCHAR(20) — NOT NULL

pull_requests (PR)

  • id (PR id) — biginteger — Primary key — NOT NULL
  • repository_id (레포id) — biginteger — Foreign key → repositories.id — NOT NULL
  • user_id (회원 id) — biginteger — Foreign key → repositories.user_id — NOT NULL
  • title (pr title) — VARCHAR(255) — NOT NULL
  • description (pr 설명) — TEXT — NOT NULL
  • summary (pr 요약) — TEXT — NOT NULL
  • github_pull_request_id (깃허브 PR id) — biginteger — NOT NULL
  • record_status (기록 상태) — VARCHAR(20) — NOT NULL
  • merged_at (머지된 시각) — DATETIME
  • created_at (생성 시각) — DATETIME — NOT NULL

questions (질문)

  • id (질문id) — biginteger — Primary key — NOT NULL
  • pull_request_id (PR id) — biginteger — Foreign key → pull_requests.id — NOT NULL
  • content (질문 내용) — VARCHAR(255) — NOT NULL
  • is_answered (대답 여부) — tinyint — NOT NULL
  • created_at (생성 시각) — DATETIME — NOT NULL
  • category (Field) — VARCHAR(255) — NOT NULL

repositories (레포지토리)

  • id (레포id) — biginteger — Primary key — NOT NULL
  • user_id (회원 id) — biginteger — Foreign key → users.id — NOT NULL
  • name (레포이름) — VARCHAR(255) — NOT NULL
  • url (레포지토리 url) — VARCHAR(255) — NOT NULL
  • github_repository_id (깃허브_레포지토리_id) — biginteger — NOT NULL
  • created_at (생성일자) — DATETIME — NOT NULL
  • Field (깃헙 소유자 이름)

users (회원)

  • id (회원 id) — biginteger — Primary key — NOT NULL
  • nickname (닉네임) — varchar(255) — NOT NULL
  • profile_image_url (프로필 이미지 url) — varchar(255) — NOT NULL
  • provider_id (소셜id) — VARCHAR(255) — NOT NULL