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