meeteam-new-3

Tables (23)

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

  • member_id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • real_name — VARCHAR(255)
  • age — INT
  • gender — ENUM('MALE', 'FEMALE')
  • birth — DATE
  • store_file_name — VARCHAR(255)
  • is_participating — BOOLEAN
  • introduction — TEXT
  • role — ENUM('USER', 'OAUTH2_GUEST') — NOT NULL
  • provider — VARCHAR(255)
  • provider_id — VARCHAR(255)
  • oauth_access_token — VARCHAR(2048)
  • project_experience_count — INT
  • github_url — VARCHAR(255)
  • blog_url — VARCHAR(255)
  • version — BIGINT
  • 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

pr_review_job

  • id — BIGINT
  • pull_request_id — BIGINT — Foreign key → pull_request.id — NOT NULL
  • head_sha — VARCHAR(255) — NOT NULL
  • status — ENUM('QUEUED', 'RUNNING', 'SUCCEEDED', 'PARTIAL', 'FAILED') — NOT NULL
  • started_at — DATETIME
  • completed_at — DATETIME
  • error_message — VARCHAR(1000)
  • created_at — DATETIME
  • edited_at — DATETIME

project

  • project_id — BIGINT
  • creator_id — BIGINT — Foreign key → member.member_id
  • project_name — VARCHAR(255)
  • description — TEXT
  • project_category — VARCHAR(50)
  • platform_category — VARCHAR(50)
  • image_url — VARCHAR(255)
  • offline_required — BOOLEAN — NOT NULL
  • status — ENUM('PLANNING', 'IN_PROGRESS', 'COMPLETED')
  • recruitment_status — ENUM('RECRUITING', 'CLOSED')
  • start_date — DATE
  • end_date — DATE
  • is_deleted — BOOLEAN
  • like_count — INT — NOT NULL
  • 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

  • id — BIGINT
  • project_repo_id — BIGINT — Foreign key — NOT NULL
  • pr_number — INT — NOT NULL
  • title — VARCHAR(255)
  • body — TEXT
  • state — VARCHAR(50)
  • is_draft — BOOLEAN
  • is_merged — BOOLEAN
  • closed_at — DATETIME
  • merged_at — DATETIME
  • author_login — VARCHAR(255)
  • base_repo — VARCHAR(255)
  • base_branch — VARCHAR(255)
  • head_repo — VARCHAR(255)
  • head_branch — VARCHAR(255)
  • head_sha — VARCHAR(255)
  • additions — INT
  • deletions — INT
  • changed_files — INT
  • comments_count — INT
  • review_comments_count — INT
  • created_at — DATETIME
  • edited_at — DATETIME

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

  • review_id — BIGINT
  • project_id — BIGINT — Foreign key → project.project_id
  • reviewer_id — BIGINT — Foreign key → member.member_id
  • project_rating — INT — NOT NULL
  • comment — VARCHAR(1000) — ARCHAR(1000

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

uploaded_files

  • id — BIGINT
  • file_name — VARCHAR(255) — NOT NULL
  • original_file_name — VARCHAR(255) — NOT NULL
  • file_url — VARCHAR(1000) — NOT NULL
  • file_type — VARCHAR(255) — NOT NULL
  • file_size — BIGINT — NOT NULL
  • directory — VARCHAR(255) — NOT NULL
  • uploader_id — BIGINT
  • created_at — DATETIME
  • edited_at — DATETIME

webhook_delivery

  • id — BIGINT
  • delivery_id — VARCHAR(255) — NOT NULL
  • event_type — VARCHAR(255) — NOT NULL
  • signature — VARCHAR(255)
  • status — ENUM('RECEIVED', 'PROCESSED', 'DUPLICATE', 'FAILED') — NOT NULL
  • raw_payload — MEDIUMTEXT
  • received_at — DATETIME — NOT NULL
  • processed_at — DATETIME
  • error_message — VARCHAR(255)
  • created_at — DATETIME
  • edited_at — DATETIME