kommit
Tables (52)
acceptance_criteria
- criterion_id — BIGINT — Primary key — NOT NULL
- work_item_id — BIGINT — Foreign key → work_items.work_item_id — NOT NULL
- seq — INT — NOT NULL
- sentence — VARCHAR(300) — NOT NULL — 확인 문장 (통과의 유일한 기준)
- is_checked — TINYINT(1) — NOT NULL
- checked_at — DATETIME
attachments
- attachment_id — BIGINT — Primary key — NOT NULL
- target_type — VARCHAR(30) — NOT NULL — chat_message / intake / report / career 등
- target_id — BIGINT — NOT NULL
- uploader_id — BIGINT — Foreign key → users.user_id — NOT NULL
- file_url — VARCHAR(500) — NOT NULL
- file_name — VARCHAR(200)
- created_at — DATETIME — NOT NULL
availability_slots
- slot_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → developer_profiles.user_id — NOT NULL
- slot_date — DATE — NOT NULL
- start_time — TIME — NOT NULL
- status — VARCHAR(20) — NOT NULL — OPEN / CLOSED / BOOKED
- repeat_weekly — TINYINT(1) — NOT NULL — 매주 반복
booking_items
- request_id — BIGINT — Foreign key → consulting_bookings.request_id — NOT NULL
- item_id — BIGINT — Foreign key → summary_items.item_id — NOT NULL
chat_messages
- message_id — BIGINT — Primary key — NOT NULL
- request_id — BIGINT — Foreign key → requests.request_id — NOT NULL
- sender_id — BIGINT — Foreign key → users.user_id — null이면 시스템
- msg_type — VARCHAR(20) — NOT NULL — USER / SYSTEM / AI_BRIEF / SCOPE_NOTICE / SESSION_NOTE
- content — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
cloud_connections
- connection_id — BIGINT — Primary key — NOT NULL
- service_id — BIGINT — Foreign key → services.service_id — NOT NULL
- provider — VARCHAR(20) — NOT NULL — AWS / VERCEL / OPENAI / SUPABASE
- method — VARCHAR(30) — NOT NULL — IAM_ROLE / OAUTH / MEMBER_INVITE / READONLY_INVITE
- scope_desc — VARCHAR(300) — 받은 권한 설명
- status — VARCHAR(20) — NOT NULL — PENDING / CONNECTED / REVOKED
- connected_at — DATETIME
- revoked_at — DATETIME — 작업 종료 자동 폐기 포함
connection_audit_logs
- log_id — BIGINT — Primary key — NOT NULL
- connection_id — BIGINT — Foreign key → cloud_connections.connection_id — NOT NULL
- actor_id — BIGINT — Foreign key → users.user_id
- action — VARCHAR(200) — NOT NULL — 누가 언제 무엇을 했는지
- occurred_at — DATETIME — NOT NULL
consult_intakes
- request_id — BIGINT — Foreign key → consultations.request_id — NOT NULL
- problem_text — TEXT — 무엇이 막혔나
- code_location — VARCHAR(20) — LOCAL_FOLDER / GITHUB / AI_TOOL / UNKNOWN
- ai_brief — TEXT — AI 사전 정리 (개발자에게 먼저 전달)
- submitted_at — DATETIME
consult_summaries
- summary_id — BIGINT — Primary key — NOT NULL
- request_id — BIGINT — Foreign key → consultations.request_id — NOT NULL — 상담 1건당 1개
- ai_draft — TEXT — AI 1차 정리 원문 보존
- diagnosis — TEXT — 개발자 확정 진단
- status — VARCHAR(20) — NOT NULL — AI_DRAFT / REVIEWING / CONFIRMED / AUTO_OPENED
- auto_open_at — DATETIME — 검수 없으면 24시간 뒤 값 없이 공개
- confirmed_at — DATETIME
consultations
- request_id — BIGINT — Foreign key → requests.request_id — NOT NULL
- price — INT — NOT NULL — 0이면 무료 상담
- counted_to_limit — TINYINT(1) — NOT NULL — 하루 건수 소진 여부
- ended_at — DATETIME — 상담 끝내기 시각
consulting_bookings
- request_id — BIGINT — Foreign key → requests.request_id — NOT NULL
- product_id — BIGINT — Foreign key → consulting_products.product_id — NOT NULL — 30분/60분 상품
- summary_id — BIGINT — Foreign key → consult_summaries.summary_id — 출처 요약 (직접 예약이면 null)
- slot_id — BIGINT — Foreign key → availability_slots.slot_id — 예약한 시간 칸
- scheduled_at — DATETIME — NOT NULL
- duration_min — INT — NOT NULL
- price — INT — NOT NULL — 결제 시점 스냅숏
- question_text — TEXT — 미리 보낸 질문
- meeting_url — VARCHAR(500) — 개발자가 올린 링크
- status — VARCHAR(20) — NOT NULL — DRAFT / PAID / DONE / NO_SHOW / CANCELED
- payment_id — BIGINT — Foreign key → payments.payment_id
- followup_until — DATETIME — 종료 후 14일 후속 질문 기한
consulting_products
- product_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → developer_profiles.user_id — NOT NULL
- duration_min — INT — NOT NULL — 30 / 60
- price — INT — NOT NULL
- is_active — TINYINT(1) — NOT NULL
cost_records
- cost_id — BIGINT — Primary key — NOT NULL
- service_id — BIGINT — Foreign key → services.service_id — NOT NULL
- provider — VARCHAR(20) — NOT NULL — AWS / VERCEL / OPENAI / SUPABASE
- cost_date — DATE — NOT NULL
- amount — INT — NOT NULL — 일별 비용 (조회 전용, Komit 결제 아님)
- note — VARCHAR(200) — 이벤트 메모 (기능을 켠 날 등)
dev_orders
- request_id — BIGINT — Foreign key → requests.request_id — NOT NULL
- summary_id — BIGINT — Foreign key → consult_summaries.summary_id — 원천 상담 요약
- start_date — DATE — 의뢰인이 고른 착수일
- expected_end_date — DATE
- start_rate_pct — INT — NOT NULL — 착수 가산율, 0이면 없음
- revision_included — INT — NOT NULL — 승인 시점 스냅숏
- warranty_days — INT — NOT NULL — 승인 시점 스냅숏
- deliverables_desc — VARCHAR(200) — 파일·계정·설명서
- client_note — VARCHAR(300) — 요청 사항 (검수 기준 아님)
- approved_at — DATETIME — 요청서 승인 시각
developer_careers
- career_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → developer_profiles.user_id — NOT NULL
- company — VARCHAR(100) — NOT NULL
- role_desc — VARCHAR(200) — 백엔드 · 주문/정산 서비스 등
- start_ym — VARCHAR(7) — NOT NULL — YYYY-MM
- end_ym — VARCHAR(7) — null이면 현재
- verify_status — VARCHAR(20) — NOT NULL — PENDING / VERIFIED
developer_portfolios
- portfolio_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → developer_profiles.user_id — NOT NULL
- title — VARCHAR(100) — NOT NULL
- url — VARCHAR(500) — null이면 비공개
- description — VARCHAR(300)
- client_consent — TINYINT(1) — NOT NULL — 의뢰인 공개 동의
- sort_order — INT — NOT NULL — 프로필 노출 순서
developer_profiles
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL — 회원 ID (1:1)
- photo_url — VARCHAR(500)
- headline — VARCHAR(100) — 한 줄 소개
- bio — TEXT — 소개 글 (400자)
- grade — VARCHAR(20) — NOT NULL — ROOKIE / JUNIOR / MIDDLE / SENIOR
- field — VARCHAR(50) — 백엔드, 인프라 등
- career_years — INT
- work_start — TIME — 활동 시작 시각
- work_end — TIME — 활동 종료 시각
- works_weekend — TINYINT(1) — NOT NULL
- avg_response_min — INT — 평균 응답(분), 최근 20건 자동 계산
- first_consult_price — INT — NOT NULL — 첫 상담 가격, 0이면 무료
- daily_consult_limit — INT — 무료 상담 하루 건수
- meeting_tool — VARCHAR(50) — Google Meet 등
- revision_included — INT — NOT NULL — 수정 요청 포함 횟수
- warranty_days — INT — NOT NULL — 하자보수 일수
- skill_avg — DECIMAL(2, 1) — 실력 평균 (리뷰 집계 캐시)
- skill_cnt — INT — NOT NULL
- explain_avg — DECIMAL(2, 1) — 설명력 평균 (리뷰 집계 캐시)
- explain_cnt — INT — NOT NULL
- is_public — TINYINT(1) — NOT NULL — 프로필 공개 여부
- grade_verified_at — DATETIME — 등급 증빙 확인일
developer_skills
- user_id — BIGINT — Foreign key → developer_profiles.user_id — NOT NULL
- skill_id — INT — Foreign key → skills.skill_id — NOT NULL
escrow_accounts
- escrow_id — BIGINT — Primary key — NOT NULL
- request_id — BIGINT — Foreign key → dev_orders.request_id — NOT NULL — 개발 요청서당 1개
- payment_id — BIGINT — Foreign key → payments.payment_id — 예치 결제
- deposited_amount — INT — NOT NULL — 예치한 돈
- released_amount — INT — NOT NULL — 지급된 돈
- refunded_amount — INT — NOT NULL — 환불된 돈
- locked_balance — INT — NOT NULL — 아직 잠긴 돈 (불변식: deposited = released + refunded + locked)
- status — VARCHAR(20) — NOT NULL — HELD / SETTLED / CLOSED
escrow_ledger
- entry_id — BIGINT — Primary key — NOT NULL
- escrow_id — BIGINT — Foreign key → escrow_accounts.escrow_id — NOT NULL
- entry_type — VARCHAR(20) — NOT NULL — DEPOSIT / RELEASE / REFUND / NOTICE
- work_item_id — BIGINT — Foreign key → work_items.work_item_id — 통과·환불된 작업
- amount — INT — NOT NULL — 부호 있는 금액, NOTICE는 0
- balance_after — INT — NOT NULL — 잠긴 잔액 스냅숏
- description — VARCHAR(200) — 착수 알림 발송 등
- occurred_at — DATETIME — NOT NULL
faqs
- faq_id — INT — Primary key — NOT NULL
- category — VARCHAR(30) — NOT NULL — 값, 진행, 컨설팅, 계정, 정산, 분쟁
- question — VARCHAR(300) — NOT NULL
- answer — TEXT — NOT NULL
- sort_order — INT — NOT NULL
inquiries
- inquiry_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- category — VARCHAR(30) — 거래, 정산 등
- content — TEXT — NOT NULL
- status — VARCHAR(20) — NOT NULL — OPEN / ANSWERED
- answer — TEXT
- answered_at — DATETIME
invoice_items
- item_id — BIGINT — Primary key — NOT NULL
- invoice_id — BIGINT — Foreign key → subscription_invoices.invoice_id — NOT NULL
- name — VARCHAR(100) — NOT NULL — 범위 초과 대응, 비용 진단 등
- amount — INT — NOT NULL
- approved_at — DATETIME — 의뢰인 승인일
mediations
- mediation_id — BIGINT — Primary key — NOT NULL
- report_id — BIGINT — Foreign key → reports.report_id — NOT NULL
- decision — VARCHAR(20) — NOT NULL — PASS / FULL_REFUND (반씩 없음)
- basis_note — TEXT — 확인 문장 기준 판단 근거
- decided_at — DATETIME — NOT NULL
- appealed — TINYINT(1) — NOT NULL — 외부 분쟁조정 이의
notification_settings
- category — VARCHAR(30) — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- enabled — TINYINT(1) — NOT NULL
- is_locked — TINYINT(1) — NOT NULL — 확인·지급 범주는 끌 수 없음
notifications
- notification_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- category — VARCHAR(30) — NOT NULL — CONFIRM_REQUEST / PAYOUT / BILLING_NOTICE / COST_SPIKE / REPLY / SESSION / MEDIATION
- title — VARCHAR(200) — NOT NULL
- body — VARCHAR(500)
- link_url — VARCHAR(500) — 확인하러 가기 이동 경로
- is_read — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
offer_items
- offer_id — BIGINT — Foreign key → summary_session_offers.offer_id — NOT NULL
- item_id — BIGINT — Foreign key → summary_items.item_id — NOT NULL
payment_methods
- method_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- kind — VARCHAR(20) — NOT NULL — CARD / TRANSFER
- brand — VARCHAR(30) — VISA, 우리카드 등
- masked_no — VARCHAR(30) — 마스킹 번호만 저장 (원문은 PG)
- expiry — VARCHAR(7)
- is_default — TINYINT(1) — NOT NULL
payments
- payment_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- method_id — BIGINT — Foreign key → payment_methods.method_id — 1회성 수단이면 null
- purpose — VARCHAR(20) — NOT NULL — ESCROW / CONSULTING / SUBSCRIPTION
- amount — INT — NOT NULL
- pg_provider — VARCHAR(50) — NOT NULL — 갤럭시아머니트리
- pg_tid — VARCHAR(100) — PG 거래번호
- status — VARCHAR(30) — NOT NULL — PAID / CANCELED / PARTIAL_REFUNDED / REFUNDED
- paid_at — DATETIME
- refunded_at — DATETIME
payout_accounts
- account_id — BIGINT — Primary key — NOT NULL
- developer_id — BIGINT — Foreign key → developer_profiles.user_id — NOT NULL
- bank — VARCHAR(30) — NOT NULL
- masked_no — VARCHAR(30) — NOT NULL
- holder — VARCHAR(50) — NOT NULL
- tax_type — VARCHAR(30) — NOT NULL — PERSONAL_33 (원천징수 3.3%) / BUSINESS_INVOICE (세금계산서)
- is_default — TINYINT(1) — NOT NULL
payouts
- payout_id — BIGINT — Primary key — NOT NULL
- developer_id — BIGINT — Foreign key → developer_profiles.user_id — NOT NULL
- source_type — VARCHAR(20) — NOT NULL — WORK_ITEM / CONSULTING
- source_id — BIGINT — NOT NULL — 작업 또는 예약 ID
- account_id — BIGINT — Foreign key → payout_accounts.account_id
- gross — INT — NOT NULL — 작업 대금
- withholding — INT — NOT NULL — 원천징수 3.3%
- net — INT — NOT NULL — 실입금
- status — VARCHAR(20) — NOT NULL — WAITING / SCHEDULED / PAID / FAILED
- paid_at — DATETIME
recon_issues
- issue_id — BIGINT — Primary key — NOT NULL
- recon_id — BIGINT — Foreign key → settlement_recons.recon_id — NOT NULL
- kind — VARCHAR(30) — NOT NULL — WEBHOOK_MISSING / PAYOUT_FAILED / REFUND_PENDING
- ref_desc — VARCHAR(200)
- resolved_at — DATETIME
report_events
- event_id — BIGINT — Primary key — NOT NULL
- report_id — BIGINT — Foreign key → reports.report_id — NOT NULL
- actor — VARCHAR(20) — NOT NULL — CLIENT / DEVELOPER / KOMIT
- content — TEXT — NOT NULL — 처리 기록 타임라인
- occurred_at — DATETIME — NOT NULL
reports
- report_id — BIGINT — Primary key — NOT NULL
- request_id — BIGINT — Foreign key → requests.request_id — NOT NULL
- reporter_id — BIGINT — Foreign key → users.user_id — NOT NULL
- respondent_id — BIGINT — Foreign key → users.user_id — NOT NULL
- kind — VARCHAR(30) — NOT NULL — DELAY / NO_RESPONSE / NO_SHOW / DIRECT_PAY_DEMAND / NO_CONFIRM / OUT_OF_SCOPE_DEMAND / PASS_WITHHELD / ETC
- work_item_id — BIGINT — Foreign key → work_items.work_item_id — 대상 작업 (건 전체면 null)
- detail — TEXT — 상세 경위 (500자)
- status — VARCHAR(20) — NOT NULL — OPEN / ANSWERED / RESOLVED / MEDIATION / CLOSED
- created_at — DATETIME — NOT NULL
- escalate_at — DATETIME — 접수 + 3일 (무응답 시 조정)
requests
- request_id — BIGINT — Primary key — NOT NULL
- type — VARCHAR(20) — NOT NULL — CONSULT / CONSULTING / DEV
- client_id — BIGINT — Foreign key → users.user_id — NOT NULL — 의뢰인
- developer_id — BIGINT — Foreign key → developer_profiles.user_id — NOT NULL — 개발자
- service_id — BIGINT — Foreign key → services.service_id — 대상 내 서비스
- status — VARCHAR(30) — NOT NULL — 타입별 상태값 (부록 참조)
- created_at — DATETIME — NOT NULL
- closed_at — DATETIME
review_replies
- reply_id — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → reviews.review_id — NOT NULL
- content — TEXT — NOT NULL — 개발자 답글
- created_at — DATETIME — NOT NULL
review_tags
- tag — VARCHAR(50) — Primary key — NOT NULL — 용어를 풀어서 설명 등
- review_id — BIGINT — Foreign key → reviews.review_id — NOT NULL
reviews
- review_id — BIGINT — Primary key — NOT NULL
- request_id — BIGINT — Foreign key → requests.request_id — NOT NULL — 유료 완료 요청당 1건
- reviewer_id — BIGINT — Foreign key → users.user_id — NOT NULL — 의뢰인
- developer_id — BIGINT — Foreign key → developer_profiles.user_id — NOT NULL
- skill_score — INT — 1-5, 개발 완료 건만
- explain_score — INT — NOT NULL — 1-5, 컨설팅·개발 공통
- content — TEXT
- created_at — DATETIME — NOT NULL
- edited_at — DATETIME — 7일 안 1회 수정
revision_requests
- revision_id — BIGINT — Primary key — NOT NULL
- work_item_id — BIGINT — Foreign key → work_items.work_item_id — NOT NULL
- round — INT — NOT NULL — 1..revision_included
- content — TEXT — NOT NULL
- requested_at — DATETIME — NOT NULL
- resolved_at — DATETIME
services
- service_id — BIGINT — Primary key — NOT NULL
- owner_id — BIGINT — Foreign key → users.user_id — NOT NULL — 소유 의뢰인
- name — VARCHAR(100) — NOT NULL — 미미헤어샵 예약 등
- url — VARCHAR(500) — null이면 비공개
- summary_metric — VARCHAR(100) — 핵심 지표 라벨 (예약 38건 등)
- created_at — DATETIME — NOT NULL
settlement_recons
- recon_id — BIGINT — Primary key — NOT NULL
- recon_date — DATE — NOT NULL — 매일 09:00 자동
- book_total — BIGINT — NOT NULL — Komit 장부 합계
- pg_balance — BIGINT — NOT NULL — PG 실제 잔고
- diff — BIGINT — NOT NULL — 1원이라도 나면 지급 배치 정지
- status — VARCHAR(20) — NOT NULL — MATCHED / MISMATCHED
- resolved_note — VARCHAR(300)
skills
- skill_id — INT — Primary key — NOT NULL — 스킬 ID
- name — VARCHAR(50) — NOT NULL — 인터넷에 올리기, DB 연결 등
subscription_invoices
- invoice_id — BIGINT — Primary key — NOT NULL
- subscription_id — BIGINT — Foreign key → subscriptions.subscription_id — NOT NULL
- billing_month — VARCHAR(7) — NOT NULL — YYYY-MM
- base_fee — INT — NOT NULL
- overage_amount — INT — NOT NULL — 범위 초과분
- total — INT — NOT NULL
- payment_id — BIGINT — Foreign key → payments.payment_id — 말일 자동 결제
- status — VARCHAR(20) — NOT NULL — UPCOMING / BILLED / PAID
subscriptions
- subscription_id — BIGINT — Primary key — NOT NULL
- service_id — BIGINT — Foreign key → services.service_id — NOT NULL
- plan_name — VARCHAR(50) — NOT NULL — 스탠다드 등
- monthly_fee — INT — NOT NULL — 월 정액
- status — VARCHAR(20) — NOT NULL — ACTIVE / CANCELED
- started_at — DATETIME — NOT NULL
- canceled_at — DATETIME — 해지 시 위임 자동 해제
summary_items
- item_id — BIGINT — Primary key — NOT NULL
- summary_id — BIGINT — Foreign key → consult_summaries.summary_id — NOT NULL
- seq — INT — NOT NULL — 요약 번호 1..n
- title — VARCHAR(100) — NOT NULL
- detail — TEXT
- task_price_id — BIGINT — Foreign key → task_prices.task_price_id — 기준값 출처 (카탈로그 밖이면 null)
- decision — VARCHAR(20) — NOT NULL — ACCEPT / CONDITIONAL / REJECT
- handling — VARCHAR(20) — NOT NULL — SELF / DEV / CONSULTING / UNPRICED
- price — INT — 이 건 확정가 (스냅숏)
- duration_days — INT
- reason — TEXT — 사유 (의뢰인에게 그대로 노출)
summary_session_offers
- offer_id — BIGINT — Primary key — NOT NULL
- summary_id — BIGINT — Foreign key → consult_summaries.summary_id — NOT NULL
- duration_min — INT — NOT NULL — 30 / 60
- price — INT — NOT NULL
- group_reason — TEXT — 묶은/나눈 이유
summary_start_dates
- date_id — BIGINT — Primary key — NOT NULL
- summary_id — BIGINT — Foreign key → consult_summaries.summary_id — NOT NULL
- start_date — DATE — NOT NULL — 여는 날 (의뢰인은 이 중에서만 선택)
summary_start_options
- option_id — BIGINT — Primary key — NOT NULL
- summary_id — BIGINT — Foreign key → consult_summaries.summary_id — NOT NULL
- kind — VARCHAR(20) — NOT NULL — WEEKDAY / URGENT_24H / WEEKEND
- enabled — TINYINT(1) — NOT NULL — 끈 것은 의뢰인이 못 고름
- rate_pct — INT — NOT NULL — 가산율, 0이면 가산 없음
- note — VARCHAR(300) — 안 받는 사유
surcharges
- surcharge_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → developer_profiles.user_id — NOT NULL
- applies_to — VARCHAR(20) — NOT NULL — CONSULTING / DEV
- name — VARCHAR(100) — NOT NULL — 야간, 주말, 긴급, 수정 초과
- rate_pct — INT — 비율 가산이면 (+30, +50)
- flat_amount — INT — 정액 가산이면 (+50000)
task_prices
- task_price_id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → developer_profiles.user_id — NOT NULL
- name — VARCHAR(100) — NOT NULL — 작업 이름
- price — INT — NOT NULL — 기준값
- duration_days — INT — NOT NULL
- is_active — TINYINT(1) — NOT NULL
users
- user_id — BIGINT — Primary key — NOT NULL — 회원 ID
- kakao_id — VARCHAR(100) — NOT NULL — 카카오 로그인 식별자
- name — VARCHAR(50) — NOT NULL — 이름
- email — VARCHAR(255) — NOT NULL — 메일 (로그인 겸용)
- phone — VARCHAR(20) — 알림톡 수신 번호
- business_reg_no — VARCHAR(20) — 사업자번호 (세금계산서용)
- status — VARCHAR(20) — NOT NULL — ACTIVE / WITHDRAWN
- created_at — DATETIME — NOT NULL
- withdrawn_at — DATETIME
work_items
- work_item_id — BIGINT — Primary key — NOT NULL
- request_id — BIGINT — Foreign key → dev_orders.request_id — NOT NULL
- summary_item_id — BIGINT — Foreign key → summary_items.item_id — 출처 항목 (추가 작업이면 null)
- seq — INT — NOT NULL — 1차 2차 3차
- title — VARCHAR(100) — NOT NULL
- scope_desc — TEXT — 포함 범위
- price — INT — NOT NULL — 확정가 스냅숏
- duration_days — INT — NOT NULL
- status — VARCHAR(30) — NOT NULL — PENDING / IN_PROGRESS / REVIEW_REQUESTED / REVISING / PASSED / REFUNDED / CANCELED
- is_additional — TINYINT(1) — NOT NULL — 추가 작업 여부
- source_message_id — BIGINT — Foreign key → chat_messages.message_id — 추가 작업의 근거 대화
- review_requested_at — DATETIME — 완료 알림 시각
- auto_pass_at — DATETIME — 알림 + 14일 자동 통과
- passed_at — DATETIME