test

Tables (7)

diagnoses

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • request_payload — JSON — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • contract_version — VARCHAR(32) — NOT NULL
  • analysis_version — VARCHAR(64)
  • result_summary — JSON
  • error_code — VARCHAR(64)
  • created_at — DATETIME(6) — NOT NULL
  • started_at — DATETIME(6)
  • completed_at — DATETIME(6)
  • updated_at — DATETIME(6) — NOT NULL

github_issue_publications

  • id — BIGINT — Primary key — NOT NULL
  • issue_candidate_id — BIGINT — Foreign key → issue_candidates.id — NOT NULL
  • github_repository_id — BIGINT — NOT NULL
  • request_title — VARCHAR(512) — NOT NULL
  • request_body — MEDIUMTEXT — NOT NULL
  • request_labels — JSON — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • github_issue_id — BIGINT
  • github_issue_number — BIGINT
  • github_issue_url — VARCHAR(2048)
  • published_at — DATETIME(6)
  • error_code — VARCHAR(64)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL

github_oauth_credentials

  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • access_token_ciphertext — VARBINARY(2048) — NOT NULL
  • encryption_key_version — SMALLINT — NOT NULL
  • granted_scopes — VARCHAR(512) — 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
  • choice_order — TINYINT — NOT NULL
  • payload — JSON — NOT NULL

repository_diagnosis_results

  • id — BIGINT — Primary key — NOT NULL
  • diagnosis_id — BIGINT — Foreign key → diagnoses.id — NOT NULL
  • github_repository_id — BIGINT — NOT NULL
  • recommendation_rank — TINYINT — NOT NULL
  • is_private — BOOLEAN — NOT NULL
  • repository_snapshot — JSON — NOT NULL
  • assessment_snapshot — JSON — NOT NULL
  • snapshot_at — DATETIME(6) — NOT NULL

solutions

  • id — BIGINT — Primary key — NOT NULL
  • repository_diagnosis_result_id — BIGINT — Foreign key → repository_diagnosis_results.id — NOT NULL
  • kind — VARCHAR(8) — NOT NULL
  • payload — JSON — 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)
  • bio — VARCHAR(255)
  • created_at — DATETIME(6) — NOT NULL
  • updated_at — DATETIME(6) — NOT NULL
  • last_login_at — DATETIME(6) — NOT NULL