meeteam-new

Tables (18)

big_category

  • big_category_id — BIGINT
  • big_category — VARCHAR(255) — NOT NULL

llm_task

  • id — BIGINT
  • pr_review_job_id — BIGINT — Foreign key → pr_review_job.id — NOT NULL
  • pull_request_file_id — BIGINT — Foreign key → pull_request_file.id
  • task_type — VARCHAR(50) — NOT NULL
  • status — VARCHAR(50) — NOT NULL
  • priority — VARCHAR(20)
  • error_message — TEXT
  • started_at — DATETIME
  • completed_at — DATETIME
  • created_at — DATETIME
  • updated_at — DATETIME

llm_task_result

  • id — BIGINT
  • llm_task_id — BIGINT — Foreign key → llm_task.id — NOT NULL
  • result_type — VARCHAR(50)
  • content — TEXT
  • token_usage — INT
  • chat_message_id — BIGINT
  • created_at — DATETIME
  • updated_at — DATETIME

member

  • member_id — BIGINT
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255)
  • real_name — VARCHAR(255)
  • age — INT
  • gender — VARCHAR(50)
  • birth — DATE
  • introduction — TEXT
  • role — VARCHAR(50) — NOT NULL
  • provider — VARCHAR(50)
  • provider_id — VARCHAR(255)
  • oauth_access_token — VARCHAR(2048)
  • project_experience_count — INT
  • store_file_name — VARCHAR(255)
  • github_url — VARCHAR(255)
  • blog_url — VARCHAR(255)
  • is_participating — BOOLEAN
  • version — BIGINT
  • created_at — DATETIME
  • updated_at — DATETIME

member_skill

  • member_skill_id — BIGINT
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • skill_id — BIGINT — Foreign key → skill.skill_id — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

member_sub_category

  • member_sub_category_id — BIGINT
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • sub_category_id — BIGINT — Foreign key → sub_category.sub_category_id — NOT NULL
  • created_at — DATETIME
  • updated_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 — VARCHAR(50) — NOT NULL
  • error_message — VARCHAR(1000)
  • started_at — DATETIME
  • completed_at — DATETIME
  • created_at — DATETIME
  • updated_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 — VARCHAR(50)
  • recruitment_status — VARCHAR(50)
  • start_date — DATE
  • end_date — DATE
  • like_count — INT
  • is_deleted — BOOLEAN
  • created_at — DATETIME
  • updated_at — DATETIME

project_category_application

  • project_category_application_id — BIGINT
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • sub_category_id — BIGINT — Foreign key → sub_category.sub_category_id — NOT NULL
  • recruitment_count — INT — NOT NULL
  • current_count — INT
  • created_at — DATETIME
  • updated_at — DATETIME

project_like

  • project_like_id — BIGINT
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

project_member

  • project_member_id — BIGINT
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • sub_category_id — BIGINT
  • created_at — DATETIME
  • updated_at — DATETIME

project_member_application

  • project_member_application_id — BIGINT
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • member_id — BIGINT — Foreign key → member.member_id — NOT NULL
  • sub_category_id — BIGINT — NOT NULL
  • introduction — TEXT
  • status — VARCHAR(50)
  • created_at — DATETIME
  • updated_at — DATETIME

project_repo

  • project_repo_id — BIGINT
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • repo_url — VARCHAR(255) — NOT NULL
  • repo_owner — VARCHAR(255)
  • repo_name — VARCHAR(255)
  • installation_id — BIGINT
  • created_at — DATETIME
  • updated_at — DATETIME

project_skill

  • project_skill_id — BIGINT
  • project_id — BIGINT — Foreign key → project.project_id — NOT NULL
  • skill_id — BIGINT — Foreign key → skill.skill_id — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME

pull_request

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

pull_request_file

  • id — BIGINT
  • pull_request_id — BIGINT — Foreign key → pull_request.id — NOT NULL
  • file_name — VARCHAR(255) — NOT NULL
  • status — VARCHAR(50)
  • additions — INT
  • deletions — INT
  • changes — INT
  • patch — TEXT
  • sha — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME

skill

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

sub_category

  • sub_category_id — BIGINT
  • big_category_id — BIGINT — Foreign key → big_category.big_category_id — NOT NULL
  • sub_category — VARCHAR(255) — NOT NULL