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