meeteam-new-2

Tables (16)

llm_task

  • id — BIGINT
  • pr_review_job_id — BIGINT
  • pull_request_file_id — BIGINT
  • pull_request_file_name — VARCHAR(255)
  • llm_task_result_id — BIGINT
  • task_type — VARCHAR(50) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • priority — VARCHAR(50) — NOT NULL
  • version — BIGINT
  • started_at — DATETIME
  • completed_at — DATETIME
  • error_message — TEXT
  • created_at — DATETIME
  • edited_at — DATETIME

llm_task_result

  • id — BIGINT
  • pr_review_finding_id — BIGINT — Foreign key → pr_review_finding.id
  • result_type — VARCHAR(255) — NOT NULL
  • content — TEXT
  • token_usage — INT
  • created_at — DATETIME
  • edited_at — DATETIME

member_job_position

  • member_job_position_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • job_position — VARCHAR(50) — NOT NULL
  • created_at — DATETIME
  • edited_at — DATETIME

member_skill

  • member_skill_id — BIGINT
  • member_id — BIGINT — NOT NULL
  • skill_id — BIGINT — Foreign key → skill.skill_id — NOT NULL

notification

  • id — BIGINT
  • receiver_id — BIGINT — NOT NULL
  • actor_id — BIGINT
  • application_id — BIGINT
  • project_id — BIGINT
  • type — VARCHAR(50)
  • is_read — BOOLEAN
  • created_at — DATETIME
  • edited_at — DATETIME

pr_review_finding

  • id — BIGINT
  • pr_review_job_id — BIGINT — NOT NULL
  • pull_request_id — BIGINT — NOT NULL
  • file_path — VARCHAR(255) — NOT NULL
  • start_line — INT
  • end_line — INT
  • severity — VARCHAR(50)
  • title — VARCHAR(255)
  • message — TEXT
  • suggested_patch — TEXT
  • shard_id — VARCHAR(64)
  • status — VARCHAR(50)
  • score — INT
  • chat_response — TEXT
  • created_at — DATETIME
  • edited_at — DATETIME

project_application_weekday

  • week_day — VARCHAR(20) — Primary key — NOT NULL
  • project_application_id — BIGINT — Foreign key → project_member_application.project_application_id — NOT NULL

project_like

  • id — BIGINT
  • project_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL

project_member

  • project_member_id — BIGINT
  • project_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • job_position — VARCHAR(50) — NOT NULL
  • created_at — DATETIME
  • edited_at — DATETIME

project_member_application

  • project_application_id — BIGINT
  • project_id — BIGINT — NOT NULL
  • member_id — BIGINT — NOT NULL
  • job_position — VARCHAR(50) — NOT NULL
  • motivation — VARCHAR(800)
  • available_hours_per_week — INT
  • offline_available — BOOLEAN
  • status — VARCHAR(50)
  • created_at — DATETIME
  • edited_at — DATETIME

project_repo

  • id — BIGINT
  • project_id — BIGINT — NOT NULL
  • repo_full_name — VARCHAR(255) — NOT NULL
  • installation_id — BIGINT
  • description — VARCHAR(255)
  • star_count — BIGINT
  • watcher_count — BIGINT
  • pushed_at — DATETIME
  • language — VARCHAR(255)

project_skill

  • project_skill_id — BIGINT
  • project_id — BIGINT — NOT NULL
  • skill_id — BIGINT — Foreign key → skill.skill_id — NOT NULL

pull_request_file

  • id — BIGINT
  • pull_request_id — BIGINT — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • status — VARCHAR(50)
  • additions — INT
  • deletions — INT
  • changes — INT
  • blob_sha — VARCHAR(255)
  • previous_filename — VARCHAR(255)
  • size — INT
  • patch — TEXT
  • patch_key — VARCHAR(255)
  • created_at — DATETIME
  • edited_at — DATETIME

recruitment_state

  • recruitment_state_id — BIGINT
  • project_id — BIGINT — NOT NULL
  • job_position — VARCHAR(50) — NOT NULL
  • recruit_count — INT
  • current_count — INT

review_recommendation

  • review_recommendation_id — BIGINT
  • review_id — BIGINT — NOT NULL
  • reviewee_id — BIGINT — NOT NULL

skill

  • skill_id — BIGINT
  • skill_name — VARCHAR(255) — NOT NULL