n
Tables (32)
account
- account_id — BIGINT — Primary key — NOT NULL — 계좌ID
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
- account_number — VARCHAR(30) — NOT NULL — 계좌번호(가상)
- account_type — VARCHAR(20) — NOT NULL — 계좌유형(CHECKING:입출금/SAVINGS:예적금/INVESTMENT:투자/LOAN:대출·부채)
- balance — DECIMAL(15, 2) — NOT NULL — 잔액(LOAN은 대출잔액)
- institution_name — VARCHAR(50) — 기관명
- sync_status — VARCHAR(20) — NOT NULL — 동기화상태(WAIT/PROCESSING/SUCCESS/FAIL)
- linked_at — DATETIME — 연동일시
- last_synced_at — DATETIME — 마지막 동기화 시각
auth_log
- log_id — BIGINT — Primary key — NOT NULL — 인증이력ID
- member_id — BIGINT — Foreign key → member.member_id — 회원ID
- event_type — VARCHAR(30) — NOT NULL — 이벤트유형(LOGIN_SUCCESS/LOGIN_FAIL/LOGOUT/TOKEN_REFRESH_FAIL/INVALID_TOKEN)
- success_yn — TINYINT(1) — NOT NULL — 성공여부
- fail_code — VARCHAR(30) — 실패코드
- ip_address — VARCHAR(45) — 요청 IP
- user_agent — VARCHAR(255) — 유저에이전트
- occurred_at — DATETIME — NOT NULL — 발생시각
consumption_summary
- summary_id — BIGINT — Primary key — NOT NULL — 소비집계ID
- diagnosis_id — BIGINT — Foreign key → diagnosis_result.diagnosis_id — NOT NULL — 재무진단ID
- category_code — VARCHAR(20) — NOT NULL — 소비카테고리
- amount — DECIMAL(15, 2) — NOT NULL — 카테고리별 지출금액
- ratio — DECIMAL(5, 2) — NOT NULL — 전체소비 대비 비중(%)
defense_checklist_master
- checklist_master_id — BIGINT — Primary key — NOT NULL — 체크리스트마스터ID
- cause_code — VARCHAR(20) — NOT NULL — 원인코드(ACCIDENT/ILLNESS/ACCOUNT_SUSPENDED/OTHER)
- job_category — VARCHAR(30) — 직종군(사고 원인만 구분)
- item_name — VARCHAR(100) — NOT NULL — 체크리스트 항목명
- sort_order — TINYINT — NOT NULL — 정렬순서
defense_fixed_expense_check
- id — BIGINT — Primary key — NOT NULL — 고정지출점검ID
- defense_id — BIGINT — Foreign key → defense_mode.defense_id — NOT NULL — 방어모드ID
- expense_name — VARCHAR(50) — NOT NULL — 지출항목명
- amount — DECIMAL(15, 2) — NOT NULL — 금액
- cycle — VARCHAR(20) — 납입주기
- next_payment_date — DATE — 다음 이체일
- maintain_status — VARCHAR(20) — NOT NULL — 유지가능상태(NORMAL/DIFFICULT_THIS_MONTH/REVIEW_NEEDED)
defense_mode
- defense_id — BIGINT — Primary key — NOT NULL — 방어모드ID
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
- job_id — BIGINT — Foreign key → job.job_id — NOT NULL — 대상 잡ID
- cause_code — VARCHAR(20) — NOT NULL — 원인코드(ACCIDENT/ILLNESS/ACCOUNT_SUSPENDED/OTHER)
- job_category_snapshot — VARCHAR(30) — 진입시점 직종군 스냅샷
- start_date — DATE — NOT NULL — 근무불가 시작일
- expected_return_date — DATE — NOT NULL — 예상 복귀일
- actual_return_date — DATE — 실제 복귀일
- status — VARCHAR(20) — NOT NULL — 상태(ACTIVE/RESOLVED)
- available_assets_snapshot — DECIMAL(15, 2) — 진입시점 가용자산 스냅샷(diagnosis_result.liquid_assets, 입출금+예적금)
- daily_fixed_cost — DECIMAL(15, 2) — 일평균 고정지출
- d_day — INT — 생존가능일수
- expected_loss_income — DECIMAL(15, 2) — 이번달 예상 손실소득
- free_memo — VARCHAR(500) — 기타 원인 자유메모
- created_at — DATETIME — NOT NULL — 진입일시
- resolved_at — DATETIME — 해제일시
diagnosis_result
- diagnosis_id — BIGINT — Primary key — NOT NULL — 재무진단ID
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
- year_month — CHAR(7) — NOT NULL — 기준연월(YYYY-MM)
- total_income — DECIMAL(15, 2) — NOT NULL — 총소득
- total_expense — DECIMAL(15, 2) — NOT NULL — 총소비
- available_funds — DECIMAL(15, 2) — NOT NULL — 가용자금
- income_regularity_score — DECIMAL(5, 2) — 소득 규칙성 지표
- income_volatility — DECIMAL(5, 2) — 소득 변동성 지표
- income_change_rate — DECIMAL(5, 2) — 전월대비 소득 증감률(%)
- income_change_amount — DECIMAL(15, 2) — 전월대비 소득 증감액
- primary_income_job_id — BIGINT — Foreign key → job.job_id — 주 소득원 잡ID
- fixed_cost_ratio — DECIMAL(5, 2) — 고정비 부담률(%)
- liquid_assets — DECIMAL(15, 2) — 가용자산 = account의 CHECKING+SAVINGS 잔액 합계(투자자산 제외)
- total_financial_assets — DECIMAL(15, 2) — 총 금융자산 = CHECKING+SAVINGS+INVESTMENT 전체 합계
- ai_summary_content — TEXT — AI 총평
- created_at — DATETIME — NOT NULL — 진단 실행일시
fatigue_log
- fatigue_log_id — BIGINT — Primary key — NOT NULL — 피로도기록ID
- work_log_id — BIGINT — Foreign key → work_log.work_log_id — NOT NULL — 근무일지ID
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
- fatigue_date — DATE — NOT NULL — 피로도 기준일
- fatigue_value — TINYINT — NOT NULL — 피로도 값(1~5)
- is_default_value_yn — TINYINT(1) — NOT NULL — 미입력 기본값 적용여부
- created_at — DATETIME — NOT NULL — 등록일시
- updated_at — DATETIME — NOT NULL — 수정일시
fatigue_summary
- summary_id — BIGINT — Primary key — NOT NULL — 누적피로도ID
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
- calc_date — DATE — NOT NULL — 계산 기준일
- cumulative_fatigue — DECIMAL(5, 2) — NOT NULL — 최근7일 가중평균 피로도
- warning_status — VARCHAR(20) — NOT NULL — 경고상태(NORMAL/CAUTION/WARNING)
- created_at — DATETIME — NOT NULL — 계산일시
financial_product
- product_id — BIGINT — Primary key — NOT NULL — 금융상품ID
- product_name — VARCHAR(100) — NOT NULL — 상품명
- product_type — VARCHAR(30) — 상품유형(예금/적금/투자 등)
- interest_rate — DECIMAL(5, 2) — 금리(%)
- min_join_period — INT — 최소 가입기간(개월)
- min_amount — DECIMAL(15, 2) — 최소 가입금액
- join_condition — VARCHAR(255) — 가입조건
- subscriber_only_yn — TINYINT(1) — NOT NULL — 구독자 전용 여부
- created_at — DATETIME — NOT NULL — 등록일시
job
- job_id — BIGINT — Primary key — NOT NULL — 잡ID
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
- platform_id — BIGINT — Foreign key → platform.platform_id — 플랫폼ID
- job_name — VARCHAR(50) — NOT NULL — 잡 이름
- compensation_type — VARCHAR(10) — NOT NULL — 보상방식(HOURLY/PER_CASE)
- wage_amount — DECIMAL(15, 2) — NOT NULL — 시급 또는 건당 금액
- schedule_type — VARCHAR(10) — NOT NULL — 일정유형(REGULAR/IRREGULAR)
- base_fatigue_index — TINYINT — NOT NULL — 기본 피로도(1~5)
- job_category — VARCHAR(30) — 직종군(방어모드 체크리스트 매핑용)
- settlement_cycle — VARCHAR(20) — 정산주기
- settlement_day — VARCHAR(20) — 정산 기준일
- active_yn — TINYINT(1) — NOT NULL — 활성여부
- deactivated_at — DATETIME — 비활성화 시각
- created_at — DATETIME — NOT NULL — 등록일시
- updated_at — DATETIME — NOT NULL — 수정일시
job_income_summary
- summary_id — BIGINT — Primary key — NOT NULL — 잡별소득집계ID
- diagnosis_id — BIGINT — Foreign key → diagnosis_result.diagnosis_id — NOT NULL — 재무진단ID
- job_id — BIGINT — Foreign key → job.job_id — NOT NULL — 잡ID
- job_income_amount — DECIMAL(15, 2) — NOT NULL — 잡별 소득금액
- job_income_ratio — DECIMAL(5, 2) — NOT NULL — 전체소득 대비 비중(%)
job_recurring_rule
- rule_id — BIGINT — Primary key — NOT NULL — 반복규칙ID
- job_id — BIGINT — Foreign key → job.job_id — NOT NULL — 잡ID
- day_of_week — TINYINT — NOT NULL — 요일(0=일~6=토)
- start_time — TIME — NOT NULL — 시작시간
- end_time — TIME — NOT NULL — 종료시간
- apply_start_date — DATE — NOT NULL — 적용 시작일
- apply_end_date — DATE — 적용 종료일
member
- member_id — BIGINT — Primary key — NOT NULL — 회원ID
- email — VARCHAR(255) — 이메일
- nickname — VARCHAR(50) — 닉네임
- name — VARCHAR(50) — 이름
- role — VARCHAR(20) — NOT NULL — 시스템 접근권한(ROLE_USER/ROLE_ADMIN)
- status — VARCHAR(20) — NOT NULL — 회원상태(PENDING/ACTIVE/SUSPENDED/WITHDRAWN)
- notification_agree_yn — TINYINT(1) — NOT NULL — 알림수신 동의여부
- location_agree_yn — TINYINT(1) — NOT NULL — 위치정보 수집 동의여부
- marketing_agree_yn — TINYINT(1) — NOT NULL — 마케팅 수신 동의여부
- onboarding_completed_yn — TINYINT(1) — NOT NULL — 온보딩 완료여부
- last_login_at — DATETIME — 최근 로그인 시각
- withdrawal_reason — VARCHAR(255) — 탈퇴 사유
- withdrawn_at — DATETIME — 탈퇴 시각
- created_at — DATETIME — NOT NULL — 가입일시
- updated_at — DATETIME — NOT NULL — 수정일시
member_oauth
- oauth_id — BIGINT — Primary key — NOT NULL — 소셜연동ID
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
- provider — VARCHAR(20) — NOT NULL — 제공자(KAKAO/GOOGLE/EMAIL)
- provider_user_id — VARCHAR(255) — NOT NULL — 제공자측 사용자 식별자
- connected_at — DATETIME — NOT NULL — 연동일시
notification
- notification_id — BIGINT — Primary key — NOT NULL — 알림ID
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
- source_domain — VARCHAR(30) — 트리거 발생 도메인
- notification_type — VARCHAR(30) — NOT NULL — 알림유형(REPORT_READY/WORK_LOG_REMIND/DEFENSE_ALERT 등)
- channel — VARCHAR(20) — NOT NULL — 발송채널(KAKAO/PUSH)
- template_id — VARCHAR(30) — 템플릿ID
- message_content — VARCHAR(500) — 메시지 내용
- related_report_id — BIGINT — Foreign key → report.report_id — 관련 리포트ID
- status — VARCHAR(20) — NOT NULL — 발송상태(PENDING/SENT/FAILED/RETRY)
- retry_count — TINYINT — NOT NULL — 재시도 횟수
- read_yn — TINYINT(1) — NOT NULL — 읽음 여부
- deleted_yn — TINYINT(1) — NOT NULL — 삭제 여부
- scheduled_at — DATETIME — 발송예정시각
- sent_at — DATETIME — 발송완료시각
- created_at — DATETIME — NOT NULL — 등록일시
notification_trigger
- trigger_id — BIGINT — Primary key — NOT NULL — 알림트리거ID
- trigger_type — VARCHAR(30) — NOT NULL — 트리거유형
- source_domain — VARCHAR(30) — NOT NULL — 발생 도메인
- condition_expression — VARCHAR(255) — 발생조건
- evaluation_cycle — VARCHAR(20) — 평가주기
- active_yn — TINYINT(1) — NOT NULL — 활성여부
payment
- payment_id — BIGINT — Primary key — NOT NULL — 결제ID
- subscription_id — BIGINT — Foreign key → subscription.subscription_id — NOT NULL — 구독ID
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
- merchant_uid — VARCHAR(50) — NOT NULL — 주문번호(중복결제 방지용 UNIQUE)
- customer_uid — VARCHAR(50) — NOT NULL — 빌링키(정기결제용)
- imp_uid — VARCHAR(50) — 포트원 결제고유번호
- amount — DECIMAL(10, 2) — NOT NULL — 결제금액
- payment_method — VARCHAR(20) — 결제수단(CARD/KAKAOPAY)
- payment_status — VARCHAR(20) — NOT NULL — 결제상태(SUCCESS/FAILED/CANCELLED/RETRY)
- is_first_payment_yn — TINYINT(1) — NOT NULL — 최초결제 여부
- scheduled_at — DATETIME — 재결제 예정일시
- retry_count — TINYINT — NOT NULL — 재시도 횟수
- fail_reason_code — VARCHAR(30) — 실패사유코드
- created_at — DATETIME — NOT NULL — 결제일시
payment_webhook_log
- log_id — BIGINT — Primary key — NOT NULL — 웹훅이력ID
- payment_id — BIGINT — Foreign key → payment.payment_id — 결제ID
- imp_uid — VARCHAR(50) — 포트원 결제고유번호
- received_status — VARCHAR(20) — 수신된 결제상태
- received_at — DATETIME — NOT NULL — 수신일시
platform
- platform_id — BIGINT — Primary key — NOT NULL — 플랫폼ID
- platform_name — VARCHAR(50) — NOT NULL — 플랫폼명
- representative_merchant_name — VARCHAR(100) — 대표 입금처명
- settlement_cycle — VARCHAR(20) — 정산주기(DAILY/WEEKLY/MONTHLY)
- settlement_day — VARCHAR(20) — 정산 기준일
- weather_sensitive_yn — TINYINT(1) — NOT NULL — 날씨 영향 여부
- default_job_category — VARCHAR(30) — 기본 직종군(이륜차배달군/차량운행군/비이동사무형군)
- created_at — DATETIME — NOT NULL — 등록일시
recommendation
- recommendation_id — BIGINT — Primary key — NOT NULL — 추천ID
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
- diagnosis_id — BIGINT — Foreign key → diagnosis_result.diagnosis_id — NOT NULL — 재무진단ID
- product_id — BIGINT — Foreign key → financial_product.product_id — NOT NULL — 금융상품ID
- recommend_reason — TEXT — AI 생성 추천사유
- proposed_saving_amount — DECIMAL(15, 2) — 제안 저축액
- expected_return_simple — DECIMAL(15, 2) — 기대수익(단리)
- expected_return_compound — DECIMAL(15, 2) — 기대수익(복리)
- year_month — CHAR(7) — NOT NULL — 기준연월
- created_at — DATETIME — NOT NULL — 생성일시
refresh_token
- token_id — BIGINT — Primary key — NOT NULL — 토큰ID
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
- token_hash — VARCHAR(255) — NOT NULL — 토큰 해시값
- issued_at — DATETIME — NOT NULL — 발급시각
- expired_at — DATETIME — NOT NULL — 만료시각
- revoked_yn — TINYINT(1) — NOT NULL — 폐기여부
report
- report_id — BIGINT — Primary key — NOT NULL — 리포트ID
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
- diagnosis_id — BIGINT — Foreign key → diagnosis_result.diagnosis_id — NOT NULL — 재무진단ID
- year_month — CHAR(7) — NOT NULL — 기준연월
- report_content — TEXT — 리포트 본문(JSON/HTML)
- recommended_product_id — BIGINT — Foreign key → financial_product.product_id — 추천 금융상품ID
- status — VARCHAR(20) — NOT NULL — 상태(GENERATED/SENT_PENDING/SENT/FAILED)
- created_at — DATETIME — NOT NULL — 생성일시
saving_goal
- goal_id — BIGINT — Primary key — NOT NULL — 저축목표ID
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
- year_month — CHAR(7) — NOT NULL — 기준연월(YYYY-MM)
- target_income — DECIMAL(15, 2) — NOT NULL — 목표 소득치
- target_labor_intensity — VARCHAR(10) — NOT NULL — 희망 노동강도(EASY/NORMAL/TIGHT)
- target_fatigue — TINYINT — NOT NULL — 적정 피로도
- achieved_amount — DECIMAL(15, 2) — NOT NULL — 누적 달성 금액
- achievement_rate — DECIMAL(5, 2) — NOT NULL — 목표 달성률(%)
- is_default_applied_yn — TINYINT(1) — NOT NULL — 기본값 적용여부
- growth_mode_paused_yn — TINYINT(1) — NOT NULL — 성장모드 일시정지 여부
- created_at — DATETIME — NOT NULL — 등록일시
- updated_at — DATETIME — NOT NULL — 수정일시
subscription
- subscription_id — BIGINT — Primary key — NOT NULL — 구독ID
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
- plan_code — VARCHAR(20) — Foreign key → subscription_plan.plan_code — NOT NULL — 플랜코드
- status — VARCHAR(20) — NOT NULL — 구독상태(ACTIVE/CANCEL_SCHEDULED/EXPIRED)
- start_date — DATE — NOT NULL — 이용 시작일
- end_date — DATE — NOT NULL — 이용 만료일
- auto_renew_yn — TINYINT(1) — NOT NULL — 자동연장 여부
- cancel_requested_at — DATETIME — 해지신청일시
- created_at — DATETIME — NOT NULL — 등록일시
- updated_at — DATETIME — NOT NULL — 수정일시
subscription_plan
- plan_code — VARCHAR(20) — Primary key — NOT NULL — 플랜코드(FREE/PREMIUM)
- plan_name — VARCHAR(50) — NOT NULL — 플랜명
- price — DECIMAL(10, 2) — NOT NULL — 가격
- billing_cycle — VARCHAR(20) — NOT NULL — 결제주기
subscription_plan_feature
- id — BIGINT — Primary key — NOT NULL — 플랜기능매핑ID
- plan_code — VARCHAR(20) — Foreign key → subscription_plan.plan_code — NOT NULL — 플랜코드
- feature_code — VARCHAR(30) — NOT NULL — 기능코드(AGENT_REPORT/PRODUCT_RECOMMEND/KAKAO_REPORT 등)
- access_yn — TINYINT(1) — NOT NULL — 접근 허용여부
sync_history
- sync_id — BIGINT — Primary key — NOT NULL — 동기화이력ID
- account_id — BIGINT — Foreign key → account.account_id — NOT NULL — 계좌ID
- status — VARCHAR(20) — NOT NULL — 처리상태(WAIT/PROCESSING/SUCCESS/FAIL)
- trigger_type — VARCHAR(20) — NOT NULL — 실행방식(MANUAL/SCHEDULED)
- synced_count — INT — NOT NULL — 처리건수
- started_at — DATETIME — 시작시각
- finished_at — DATETIME — 종료시각
terms_agreement
- agreement_id — BIGINT — Primary key — NOT NULL — 약관동의ID
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
- terms_type — VARCHAR(30) — NOT NULL — 약관유형(SERVICE/PRIVACY/MARKETING/MYDATA)
- terms_version — VARCHAR(20) — NOT NULL — 약관버전
- is_required — TINYINT(1) — NOT NULL — 필수여부
- agreed_yn — TINYINT(1) — NOT NULL — 동의여부
- agreed_at — DATETIME — 동의시각
transaction_history
- transaction_id — BIGINT — Primary key — NOT NULL — 거래ID
- account_id — BIGINT — Foreign key → account.account_id — NOT NULL — 계좌ID
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
- transaction_type — VARCHAR(10) — NOT NULL — 거래유형(DEPOSIT/WITHDRAW)
- amount — DECIMAL(15, 2) — NOT NULL — 거래금액
- balance_after — DECIMAL(15, 2) — NOT NULL — 거래후 잔액
- merchant_name — VARCHAR(100) — 거래처명/입금처명
- transaction_detail — VARCHAR(255) — 거래내용/적요
- transaction_date — DATETIME — NOT NULL — 거래일시
- platform_id — BIGINT — Foreign key → platform.platform_id — 추정/확정 플랫폼ID
- job_id — BIGINT — Foreign key → job.job_id — 연결된 잡ID
- label_status — VARCHAR(20) — NOT NULL — 라벨상태(AUTO_ESTIMATED/APPROVED/CORRECTED/UNCLASSIFIED)
- category_code — VARCHAR(20) — 소비카테고리(식비/교통비/정주비/쇼핑/여가/구독)
- category_confirmed_yn — TINYINT(1) — NOT NULL — 카테고리 사용자 확정여부
- created_at — DATETIME — NOT NULL — 적재일시
work_log
- work_log_id — BIGINT — Primary key — NOT NULL — 근무일지ID
- schedule_id — BIGINT — Foreign key → work_schedule.schedule_id — 근무계획ID(계획외 근무는 NULL)
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
- job_id — BIGINT — Foreign key → job.job_id — NOT NULL — 잡ID
- work_date — DATE — NOT NULL — 근무일
- actual_start_time — DATETIME — NOT NULL — 실제 시작시각
- actual_end_time — DATETIME — NOT NULL — 실제 종료시각
- actual_income — DECIMAL(15, 2) — 실제 소득(재계산 결과)
- confirm_status — VARCHAR(20) — NOT NULL — 확정상태(CONFIRMED/MODIFIED)
- created_at — DATETIME — NOT NULL — 등록일시
- updated_at — DATETIME — NOT NULL — 수정일시
work_schedule
- schedule_id — BIGINT — Primary key — NOT NULL — 근무계획ID
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL — 회원ID
- job_id — BIGINT — Foreign key → job.job_id — NOT NULL — 잡ID
- work_date — DATE — NOT NULL — 근무예정일
- planned_start_time — DATETIME — NOT NULL — 계획 시작시각
- planned_end_time — DATETIME — NOT NULL — 계획 종료시각
- expected_income — DECIMAL(15, 2) — 예상 소득
- expected_fatigue — DECIMAL(5, 2) — 예상 피로도
- weather_condition — VARCHAR(20) — 날씨상태(캐시)
- precipitation_probability — TINYINT — 강수확률(%)
- fatigue_warning_yn — TINYINT(1) — NOT NULL — 적정피로도 초과 경고여부
- is_ai_recommended_yn — TINYINT(1) — NOT NULL — AI추천 근무시간 여부
- status — VARCHAR(20) — NOT NULL — 상태(PLANNED/CONFIRMED/CANCELLED/NO_SHOW)
- created_at — DATETIME — NOT NULL — 등록일시
- updated_at — DATETIME — NOT NULL — 수정일시