kl;

Tables (6)

diagnoses

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • job_description — MEDIUMTEXT — NOT NULL
  • diagnosis_summary — MEDIUMTEXT — NOT NULL
  • scoring_version — VARCHAR(64) — NOT NULL
  • prompt_version — VARCHAR(64) — NOT NULL
  • llm_model — VARCHAR(128) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

diagnosis_repositories

  • id — BIGINT — Primary key — NOT NULL
  • diagnosis_id — BIGINT — Foreign key → diagnoses.id — NOT NULL
  • github_repository_id — BIGINT — NOT NULL
  • owner_login — VARCHAR(255) — NOT NULL
  • repository_name — VARCHAR(255) — NOT NULL
  • repository_description — MEDIUMTEXT
  • html_url — VARCHAR(2048) — NOT NULL
  • default_branch — VARCHAR(255) — NOT NULL
  • head_sha — VARCHAR(64)
  • github_pushed_at — DATETIME(6)
  • snapshot_at — DATETIME(6) — NOT NULL
  • recommendation_rank — TINYINT — NOT NULL
  • score — DECIMAL(5, 2) — NOT NULL
  • diagnosis_label — VARCHAR(50) — NOT NULL
  • direction — VARCHAR(16) — NOT NULL
  • recommendation_reason — MEDIUMTEXT — NOT NULL
  • metrics_json — JSON — NOT NULL
  • score_breakdown_json — JSON — NOT NULL
  • evidence_json — JSON — NOT NULL

github_oauth_credentials

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • access_token_envelope — VARBINARY(1024) — NOT NULL
  • encryption_key_version — SMALLINT — NOT NULL
  • granted_scopes — VARCHAR(255) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

issue_candidates

  • id — BIGINT — Primary key — NOT NULL
  • solution_id — BIGINT — Foreign key → solutions.id — NOT NULL
  • position — TINYINT — NOT NULL
  • title — VARCHAR(512) — NOT NULL
  • body — MEDIUMTEXT — NOT NULL
  • labels_json — JSON — NOT NULL
  • steps_json — JSON — NOT NULL
  • publication_status — VARCHAR(16) — NOT NULL
  • publish_started_at — DATETIME(6)
  • github_issue_id — BIGINT
  • github_issue_number — BIGINT
  • github_issue_url — VARCHAR(2048)
  • published_at — DATETIME(6)
  • last_publish_error_code — VARCHAR(64)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

solutions

  • id — BIGINT — Primary key — NOT NULL
  • diagnosis_repository_id — BIGINT — Foreign key → diagnosis_repositories.id — NOT NULL
  • solution_kind — VARCHAR(16) — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • description — MEDIUMTEXT — NOT NULL
  • rationale — MEDIUMTEXT — NOT NULL
  • created_at — DATETIME(6) — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • github_user_id — BIGINT — NOT NULL
  • github_login — VARCHAR(255) — NOT NULL
  • display_name — VARCHAR(255)
  • avatar_url — VARCHAR(2048)
  • last_login_at — DATETIME(6) — NOT NULL
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL