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