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