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