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