ERD
테이블 (3)
로그인
- user_id (Key2) — varchar — 기본 키 — NOT NULL
- password (Field) — varchar
분석 데이터 (분석 데이터)
- user_name (Key2) — varchar — 기본 키 — NOT NULL
- selection time (Key3) — double — 기본 키 — NOT NULL
- repo_name (Key4) — varchar — 기본 키 — NOT NULL
- user_id (Key22) — varchar — 외래 키 → 로그인.user_id — NOT NULL
- frameworks (Field) — varchar
- main_lang (Field2) — varchar
- total_pr (Field3) — int
- user_pr (Field4) — int
- pr_per (Field5) — double
- total_issues (Field6) — int
- user_issues (Field7) — int
- issue_per (Field8) — double
- total_commits (Field9) — int
- user_commits (Field10) — int
- user_commit_percentage (Field11) — double
- merged_prs (Field12) — int
- merged_prs_percentage (Field13) — double
- total_lines (Field14) — int
- comment_lines (Field15) — int
- file_count (Field16) — int
- total_comment_percentage (Field17) — double
- average_comment_percentage (Field18) — double
- duplicates (Field19) — double
- duplicate_percentage (Field20) — double
평가 데이터
- user_name (Key2) — varchar — 기본 키 — NOT NULL
- selection_time (Key3) — double — 기본 키 — NOT NULL
- repo_name (Key4) — varchar — 기본 키 — NOT NULL
- user_id (Key222) — varchar — 외래 키 → 분석 데이터.user_id — NOT NULL
- code_smell_grade (Field) — char
- code_reliability_grade (Field2) — char
- duplicate_grade (Field3) — char
- liar_code_grade (Field4) — char
- commit_utilization_grade (Field5) — char — NOT NULL
- pr_utilization_grade (Field6) — char
- issue_utilization_grade (Field7) — char