meeteam-new-4
Tables (23)
llm_task
- id — BIGINT
- pr_review_job_id — BIGINT — Foreign key → pr_review_job.id
- pull_request_file_id — BIGINT
- pull_request_file_name — VARCHAR(255)
- llm_task_result_id — BIGINT — Foreign key → llm_task_result.id
- task_type — ENUM('ORCHESTRATION', 'FILE_REVIEW', 'PR_SUMMARY', 'CODE_EXPLANATION') — NOT NULL
- status — ENUM('CREATED', 'QUEUED', 'RUNNING', 'COMPLETED', 'FAILED') — NOT NULL
- priority — ENUM('LOW', 'NORMAL', 'HIGH', 'CRITICAL') — 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 — LONGTEXT
- 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 — Foreign key → member.member_id
- job_position — ENUM('PRODUCT_MANAGER', 'GRAPHIC_DESIGN', 'UI_UX_DESIGN', 'MOTION_DESIGN', 'WEB_FRONTEND', 'IOS', 'ANDROID', 'CROSS_PLATFORM', 'WEB_SERVER', 'AI', 'ETC') — NOT NULL
- created_at — DATETIME
- edited_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
notification
- id — BIGINT
- receiver_id — BIGINT — Foreign key → member.member_id — NOT NULL
- actor_id — BIGINT
- application_id — BIGINT
- project_id — BIGINT — Foreign key → project.project_id
- type — VARCHAR(50)
- is_read — BOOLEAN
- created_at — DATETIME
- edited_at — DATETIME
pr_review_finding
- id — BIGINT
- pr_review_job_id — BIGINT — Foreign key → pr_review_job.id — NOT NULL
- pull_request_id — BIGINT — Foreign key → pull_request.id — NOT NULL
- file_path — VARCHAR(255) — NOT NULL
- start_line — INT
- end_line — INT
- severity — ENUM('NOTICE', 'WARNING', 'FAILURE')
- title — VARCHAR(255)
- message — TEXT
- suggested_patch — TEXT
- shard_id — VARCHAR(64)
- status — ENUM('OPEN', 'RESOLVED', 'IGNORED')
- score — INT
- chat_response — LONGTEXT
- 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
- project_application_id — BIGINT — Foreign key → project_member_application.project_application_id — NOT NULL
- week_day — ENUM('MONDAY', 'TUESDAY', 'WEDNESDAY', 'THURSDAY', 'FRIDAY', 'SATURDAY', 'SUNDAY')
project_like
- id — BIGINT
- project_id — BIGINT — Foreign key → project.project_id
- member_id — BIGINT — Foreign key → member.member_id
project_member
- project_member_id — BIGINT
- project_id — BIGINT — Foreign key → project.project_id
- member_id — BIGINT — Foreign key → member.member_id
- job_position — ENUM('PRODUCT_MANAGER', 'GRAPHIC_DESIGN', 'UI_UX_DESIGN', 'MOTION_DESIGN', 'WEB_FRONTEND', 'IOS', 'ANDROID', 'CROSS_PLATFORM', 'WEB_SERVER', 'AI', 'ETC') — NOT NULL
- created_at — DATETIME
- edited_at — DATETIME
project_member_application
- project_application_id — BIGINT
- project_id — BIGINT — Foreign key → project.project_id
- member_id — BIGINT — Foreign key → member.member_id
- job_position — ENUM('PRODUCT_MANAGER', 'GRAPHIC_DESIGN', 'UI_UX_DESIGN', 'MOTION_DESIGN', 'WEB_FRONTEND', 'IOS', 'ANDROID', 'CROSS_PLATFORM', 'WEB_SERVER', 'AI', 'ETC') — NOT NULL
- motivation — VARCHAR(800)
- available_hours_per_week — INT
- offline_available — BOOLEAN
- status — ENUM('PENDING', 'ACCEPTED', 'REJECTED')
- created_at — DATETIME
- edited_at — DATETIME
project_repo
- id — BIGINT
- project_id — BIGINT — Foreign key → project.project_id — 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 — Foreign key → project.project_id — NOT NULL
- skill_id — BIGINT — Foreign key → skill.skill_id — NOT NULL
pull_request
- id — BIGINT
- project_repo_id — BIGINT — Foreign key → project_repo.id — 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 — Foreign key → pull_request.id — 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 — Foreign key → project.project_id
- job_position — ENUM('PRODUCT_MANAGER', 'GRAPHIC_DESIGN', 'UI_UX_DESIGN', 'MOTION_DESIGN', 'WEB_FRONTEND', 'IOS', 'ANDROID', 'CROSS_PLATFORM', 'WEB_SERVER', 'AI', 'ETC') — 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 — Foreign key → review.review_id
- reviewee_id — BIGINT — Foreign key → member.member_id
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