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