ERD

Tables (7)

analysis_result (분석결과)

  • id (분석결과id) — BIGINT — Primary key — NOT NULL
  • repository_id (리포지토리 id) — VARCHAR — Foreign key → repositories.id — NOT NULL
  • summary (개요) — VARCHAR — NOT NULL
  • strengths (장점) — VARCHAR — NOT NULL
  • improvements (개선점) — VARCHAR — NOT NULL
  • createData (분석 날짜) — DATETIME — NOT NULL

comment (댓글)

  • id (댓글id) — BIGINT — Primary key — NOT NULL
  • analysis_result_id (분석결과id) — VARCHAR — Foreign key → analysis_result.id — NOT NULL
  • id (댓글 회원id) — VARCHAR — NOT NULL
  • comment (댓글 내용) — VARCHAR — NOT NULL

language (프로그램 언어)

  • id (언어id) — BIGINT — Primary key — NOT NULL
  • Language (언어) — VARCHAR — NOT NULL

member (회원)

  • id (회원id) — BIGINT — Primary key — NOT NULL
  • email — VARCHAR — NOT NULL
  • password (비밀번호) — VARCHAR — NOT NULL
  • name (이름) — VARCHAR — NOT NULL
  • image_url (사진url) — TEXT
  • github_token (깃헙 로그인 토큰) — VARCHAR

repositories (리포지토리 기본정보)

  • id (리포지토리 id) — VARCHAR — Primary key — NOT NULL
  • user_id (회원id) — VARCHAR — Foreign key → member.id — NOT NULL
  • name (리포지토리명) — VARCHAR — NOT NULL
  • description (리포지토리 설명) — VARCHAR — NOT NULL
  • html_url (리포지토리 url) — VARCHAR — NOT NULL
  • public_repository (분석 공개 여부) — boolean — NOT NULL
  • main_branch (메인 브랜치) — VARCHAR — NOT NULL

repository_language (리포지토리_프로그램 언어)

  • id (분석결과_프로그램_언어id) — BIGINT — Primary key — NOT NULL
  • language_id (언어id) — VARCHAR — Foreign key → language.id — NOT NULL
  • repository_id (리포지토리 id) — BIGINT — Foreign key → repositories.id — NOT NULL

score (점수)

  • id (분석결과id) — BIGINT — Foreign key → analysis_result.id — NOT NULL
  • readme_score (README 점수) — INT
  • test_score (TEST 점수) — INT
  • commit_score (COMMIT 점수) — INT
  • cicd_score (CI/CD 점수) — INT