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