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