AIssue

Tables (10)

chat_bot_conversations (ChatBotConversations)

  • conversation_id (Key) — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • repo_id — BIGINT — Foreign key → repositories.repo_id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at (Field) — TIMESTAMP — NOT NULL

chat_bot_messages (ChatBotMessages)

  • message_id — BIGINT — Primary key — NOT NULL
  • conversation_id (Key) — BIGINT — Foreign key → chat_bot_conversations.conversation_id — NOT NULL
  • sender_type — VARCHAR(10) — NOT NULL
  • content — TEXT — NOT NULL
  • timestamp — TIMESTAMP — NOT NULL

issues (Issues)

  • issue_id — BIGINT — Primary key
  • repo_id — BIGINT — Foreign key → repositories.repo_id
  • github_issue_id — BIGINT — NOT NULL
  • github_issue_number — INT — NOT NULL
  • title — VARCHAR(1000) — NOT NULL
  • body — LONGTEXT
  • author (Field) — VARCHAR(255)
  • state — VARCHAR(20) — NOT NULL
  • score (Field2) — TINYINT — NOT NULL
  • html_url — VARCHAR(500) — NOT NULL
  • summary_gpt — TEXT
  • solution_suggestion_gpt (score_gpt) — TEXT
  • tags_gpt_json — JSON
  • created_at_github — TIMESTAMP — NOT NULL
  • updated_at_github — TIMESTAMP — NOT NULL
  • created_at_db — TIMESTAMP — NOT NULL
  • updated_at_db — TIMESTAMP — NOT NULL

license (Untitled)

  • license_spdx_id (Key) — VARCHAR(50) — Primary key — NOT NULL
  • name (Field) — VARCHAR(255) — NOT NULL
  • description_summary_html (Field2) — TEXT
  • permissions_json (Field3) — JSON
  • conditions_json (Field4) — JSON
  • limitations_json (Field5) — JSON

recommended_code_snippets

  • recommended_id (recommendation_id) — BIGINT — Primary key — NOT NULL
  • issue_id — BIGINT — Foreign key → issues.issue_id
  • file_path (Field) — VARCHAR(2048) — NOT NULL
  • github_url (Field2) — VARCHAR(500)
  • function_name (Field3) — VARCHAR(255)
  • class_name (Field4) — VARCHAR(255)
  • code_snippet (Field5) — MEDIUMTEXT — NOT NULL
  • relevance_score (Field6) — DECIMAL(5, 2) — NOT NULL
  • expanation_gpt (Field7) — TEXT
  • type (Field8) — ENUM — NOT NULL
  • created_at (Field9) — TIMESTAMP — NOT NULL

repositories (Repositories)

  • repo_id — BIGINT — Primary key — NOT NULL
  • github_repo_id — BIGINT — NOT NULL
  • full_name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • html_url — VARCHAR(500) — NOT NULL
  • license_sqdx_id (language) — VARCHAR(50)
  • readme_summary_gpt — TEXT
  • readme_filename (last_analyzed_at) — VARCHAR(100)
  • license_filename (Field) — VARCHAR(100)
  • contributing_filename (Field2) — VARCHAR(100)
  • default_branch (Field3) — VARCHAR(100)
  • license_spdx_id (Key) — VARCHAR(50) — Foreign key → license.license_spdx_id — NOT NULL
  • star (Field4) — BIGINT — NOT NULL
  • fork (Field5) — BIGINT — NOT NULL
  • pr_total_count (Field6) — INT
  • issue_total_count (Field7) — INT
  • last_analyzed_at (Field8) — TIMESTAMP
  • analysis_status (Field9) — ENUM — NOT NULL
  • analysis_progress (Field10) — TINYINT — NOT NULL
  • analysis_current_step (Field11) — VARCHAR(255)
  • analysis_error_message (Field12) — TEXT
  • analysis_started_at (Field13) — TIMESTAMP
  • analysis_completed_at (Field14) — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

repository_languages (Untitled2)

  • repo_id — BIGINT — Foreign key → repositories.repo_id — NOT NULL
  • language_name (Field) — VARCHAR(100) — NOT NULL
  • percentage (Field2) — DECIMAL(5,2) — NOT NULL
  • bytes_count (Field3) — BIGINT — NOT NULL
  • created_at (Field4) — TIMESTAMP — NOT NULL
  • updated_at (Field5) — TIMESTATMP — NOT NULL

user_recent_issues (UserSolvedIssues)

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • issue_id — BIGINT — Foreign key → issues.issue_id
  • viewed_at (solved_at) — TIMESTAMP — NOT NULL

user_tracked_repositories (UserTrackedRepositories)

  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • repo_id — BIGINT — Foreign key → repositories.repo_id — NOT NULL
  • tracked_at (added_at) — TIMESTAMP — NOT NULL
  • last_viewed_at (Field) — TIMESTAMP
  • is_favorite (Field2) — BOOLEAN — NOT NULL

users (Users)

  • user_id — BIGINT — Primary key — NOT NULL
  • github_user_id — BIGINT — NOT NULL
  • username — VARCHAR(255) — NOT NULL
  • avatar_url — VARCHAR(500)
  • email (Field) — VARCHAR(320)
  • refresh_token (Field2) — VARCHAR(500)
  • refresh_token_expires_at (Field3) — TIMESTAMP
  • is_pro_plan (Field4) — BOOLEAN — NOT NULL
  • pro_plan_activated_at (Field5) — TIMESTAMP
  • pro_plan_expires_at (Field6) — TIMESTAMP
  • monthly_repo_analysis_count (Field7) — INT — NOT NULL
  • monthly_ai_message_count (Field8) — INT
  • is_email_notification (Field9) — TINYINT(1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL