도담
테이블 (47)
account
- account_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- bank_code — VARCHAR(20) — NOT NULL
- bank_name — VARCHAR(100) — NOT NULL
- account_no — VARCHAR(100) — NOT NULL
- account_name — VARCHAR(100) — NOT NULL
- account_type — VARCHAR(30) — NOT NULL
- balance — BIGINT — NOT NULL
- last_transaction_date — DATE
- currency — VARCHAR(10) — NOT NULL
- updated_at — DATETIME — NOT NULL
auth_session
- session_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- refresh_token_hash — VARCHAR(255) — NOT NULL
- expires_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
- last_accessed_at — DATETIME
- revoked_at — DATETIME
card
- card_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- withdrawal_account_id — BIGINT — 외래 키 → account.account_id — NOT NULL
- card_no — VARCHAR(100) — NOT NULL
- issuer_name — VARCHAR(100) — NOT NULL
- card_name — VARCHAR(150) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- baseline_performance — BIGINT
- max_benefit_limit — BIGINT
- annual_fee — BIGINT
- expiry_month — CHAR(7)
- withdrawal_day — INT
- updated_at — DATETIME
card_benefit
- card_benefit_id — BIGINT — 기본 키 — NOT NULL
- card_id — BIGINT — 외래 키 → card.card_id — NOT NULL
- category — VARCHAR(50) — NOT NULL
- discount_rate — DECIMAL(10,4)
- limit_amount — BIGINT
- description — VARCHAR(500) — NOT NULL
card_billing_statement
- billing_month — CHAR(7) — 기본 키 — NOT NULL
- card_id — BIGINT — 외래 키 → card.card_id — NOT NULL
- billing_date — DATE — NOT NULL
- total_balance — BIGINT — NOT NULL
- status — VARCHAR(30) — NOT NULL
- payment_date — DATE
cashflow_daily_balance
- daily_balance_id — BIGINT — 기본 키 — NOT NULL
- forecast_id — BIGINT — 외래 키 → cashflow_forecast.forecast_id — NOT NULL
- balance_date — DATE — NOT NULL
- expected_balance — BIGINT — NOT NULL
cashflow_event
- event_id — BIGINT — 기본 키 — NOT NULL
- forecast_id — BIGINT — 외래 키 → cashflow_forecast.forecast_id — NOT NULL
- event_date — DATE — NOT NULL
- type — VARCHAR(50) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- amount — BIGINT — NOT NULL
- source_type — VARCHAR(30)
- source_id — VARCHAR(100)
cashflow_forecast
- forecast_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- base_date — DATE — NOT NULL
- horizon_days — INT — NOT NULL
- status — VARCHAR(30) — NOT NULL
- current_balance — BIGINT
- available_today — BIGINT
- minimum_balance — BIGINT
- risk_date — DATE
- created_at — DATETIME — NOT NULL
cashflow_risk
- risk_id — BIGINT — 기본 키 — NOT NULL
- forecast_id — BIGINT — 외래 키 → cashflow_forecast.forecast_id — NOT NULL
- risk_date — DATE
- type — VARCHAR(50) — NOT NULL
- severity — VARCHAR(30) — NOT NULL
- message — VARCHAR(500)
- expected_balance — BIGINT
daily_report
- report_id — BIGINT — 외래 키 → report.report_id — NOT NULL
- report_date — DATE — NOT NULL
- summary — TEXT
- available_today — BIGINT — NOT NULL
- upcoming_events — JSON
- risks — JSON
- recommendations — JSON
deposit_saving
- saving_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- withdrawal_account_id — BIGINT — 외래 키 → account.account_id — NOT NULL
- type — VARCHAR(20) — NOT NULL
- account_no — VARCHAR(100) — NOT NULL
- account_name — VARCHAR(150) — NOT NULL
- balance — BIGINT — NOT NULL
- interest_rate — DECIMAL(10,4) — NOT NULL
- opening_date — DATE — NOT NULL
- expiry_date — DATE
- status — VARCHAR(30) — NOT NULL
diagnosis
- diagnosis_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- goal_id — BIGINT — 외래 키 → goal.goal_id
- issue_count — INT — NOT NULL
- high_severity_count — INT — NOT NULL
- overall_status — VARCHAR(30)
- created_at — DATETIME — NOT NULL
diagnosis_issue
- issue_id — BIGINT — 기본 키 — NOT NULL
- diagnosis_id — BIGINT — 외래 키 → diagnosis.diagnosis_id — NOT NULL
- domain — VARCHAR(50) — NOT NULL
- type — VARCHAR(50) — NOT NULL
- severity — VARCHAR(30) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- current_value — JSON
- benchmark_value — JSON
- evidence — JSON
- detected_at — DATETIME — NOT NULL
finance_connection
- connection_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- member_email — VARCHAR(255)
- status — VARCHAR(30) — NOT NULL
- connected_at — DATETIME
- disconnected_at — DATETIME
- last_synced_at — DATETIME
finance_sync
- sync_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- scope — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- progress — INT
- started_at — DATETIME — NOT NULL
- completed_at — DATETIME
financial_company
- company_id — BIGINT — 기본 키 — NOT NULL
- company_code — VARCHAR(30) — NOT NULL
- company_name — VARCHAR(150) — NOT NULL
- sector — VARCHAR(50)
financial_product
- product_id — BIGINT — 기본 키 — NOT NULL
- company_id — BIGINT — 외래 키 → financial_company.company_id — NOT NULL
- product_type — VARCHAR(30) — NOT NULL
- product_name — VARCHAR(255) — NOT NULL
- join_way — VARCHAR(255)
- saving_type — VARCHAR(30)
- loan_type — VARCHAR(30)
- special_condition — TEXT
- join_member — TEXT
- min_rate — DECIMAL(10,4)
- max_rate — DECIMAL(10,4)
- max_limit — BIGINT
- baseline_performance — BIGINT
- max_benefit_limit — BIGINT
- description — TEXT
- benefits — JSON
- synced_at — DATETIME — NOT NULL
financial_product_option
- product_option_id — BIGINT — 기본 키 — NOT NULL
- product_id — BIGINT — 외래 키 → financial_product.product_id — NOT NULL
- term — INT
- rate — DECIMAL(10,4)
- preferred_rate — DECIMAL(10,4)
- rate_type — VARCHAR(30)
- min_rate — DECIMAL(10,4)
- max_rate — DECIMAL(10,4)
- repayment_type — VARCHAR(30)
- limit_amount — BIGINT
financial_profile
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- monthly_income — BIGINT
- annual_income — BIGINT
- payday — INT
- fixed_expense — BIGINT
- emergency_fund_target — BIGINT
- updated_at — DATETIME — NOT NULL
goal
- goal_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- name — VARCHAR(150) — NOT NULL
- type — VARCHAR(20) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- current_amount — BIGINT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
goal_account
- goal_id — BIGINT — 외래 키 → goal.goal_id — NOT NULL
- account_id — BIGINT — 외래 키 → account.account_id — NOT NULL
- contribution_amount — BIGINT
goal_history
- goal_history_id — BIGINT — 기본 키 — NOT NULL
- goal_id — BIGINT — 외래 키 → goal.goal_id — NOT NULL
- recorded_date — DATE — NOT NULL
- current_amount — BIGINT — NOT NULL
- progress_rate — DECIMAL(10,4)
- forecast_date — DATE
- event — VARCHAR(255)
- created_at — DATETIME — NOT NULL
improvement_action
- action_id — BIGINT — 기본 키 — NOT NULL
- recommendation_id — BIGINT — 외래 키 → recommendation.recommendation_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- before_snapshot — JSON
- after_snapshot — JSON
- started_at — DATETIME
- completed_at — DATETIME
installment
- installment_id — BIGINT — 기본 키 — NOT NULL
- card_id — BIGINT — 외래 키 → card.card_id — NOT NULL
- merchant_name — VARCHAR(255) — NOT NULL
- total_amount — BIGINT — NOT NULL
- months — INT — NOT NULL
- remaining_principal — BIGINT
- remaining_months — INT — NOT NULL
- monthly_amount — BIGINT — NOT NULL
- fee_rate — DECIMAL(10,4)
- status — VARCHAR(30) — NOT NULL
loan
- loan_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- withdrawal_account_id — BIGINT — 외래 키 → account.account_id — NOT NULL
- account_no — VARCHAR(100) — NOT NULL
- account_name — VARCHAR(150) — NOT NULL
- loan_type — VARCHAR(30) — NOT NULL
- repayment_type — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- loan_period — INT
- start_date — DATE
- maturity_date — DATE
- balance — BIGINT — NOT NULL
- interest_rate — DECIMAL(10,4) — NOT NULL
loan_repayment
- loan_repayment_id — BIGINT — 기본 키 — NOT NULL
- loan_id — BIGINT — 외래 키 → loan.loan_id — NOT NULL
- repayment_date — DATE — NOT NULL
- amount — BIGINT — NOT NULL
- principal — BIGINT
- interest — BIGINT
- status — VARCHAR(30) — NOT NULL
- failure_reason — VARCHAR(500)
minus_account
- minus_account_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- account_no — VARCHAR(100) — NOT NULL
- limit_amount — BIGINT — NOT NULL
- used_amount — BIGINT — NOT NULL
- available_amount — BIGINT — NOT NULL
- interest_rate — DECIMAL(10,4) — NOT NULL
- accrued_interest — BIGINT — NOT NULL
- next_interest_date — DATE
- maturity_date — DATE
- status — VARCHAR(30) — NOT NULL
- overdue_days — INT — NOT NULL
monthly_report
- report_id — BIGINT — 외래 키 → report.report_id — NOT NULL
- year_month — CHAR(7) — NOT NULL
- financial_summary — JSON
- spending_summary — JSON
- goal_summary — JSON
- improvement_summary — JSON
- upcoming_summary — JSON
- llm_comment — TEXT
notification
- notification_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- type — VARCHAR(50) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- message — TEXT — NOT NULL
- is_read — TINYINT(1) — NOT NULL
- created_at — DATETIME — NOT NULL
- read_at — DATETIME
pattern_analysis
- analysis_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- status — VARCHAR(30) — NOT NULL
- lookback_months — INT — NOT NULL
- data_point_count — INT — NOT NULL
- spending_regularity — DECIMAL(10,4)
- saving_consistency — DECIMAL(10,4)
- fixed_expense_ratio — DECIMAL(10,4)
- variable_expense_ratio — DECIMAL(10,4)
- discretionary_spending_ratio — DECIMAL(10,4)
- debt_burden — DECIMAL(10,4)
- cashflow_stability — DECIMAL(10,4)
- liquidity_level — VARCHAR(30)
- analyzed_at — DATETIME — NOT NULL
product_sync_history
- sync_id — BIGINT — 기본 키 — NOT NULL
- sync_type — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- fetched_count — INT
- inserted_count — INT
- updated_count — INT
- failed_count — INT
- started_at — DATETIME — NOT NULL
- completed_at — DATETIME
recommendation
- recommendation_id — BIGINT — 기본 키 — NOT NULL
- diagnosis_id — BIGINT — 외래 키 → diagnosis.diagnosis_id — NOT NULL
- goal_id — BIGINT — 외래 키 → goal.goal_id
- domain — VARCHAR(50) — NOT NULL
- type — VARCHAR(50) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT — NOT NULL
- priority — INT — NOT NULL
- status — VARCHAR(30) — NOT NULL
- monthly_cost_saving — BIGINT
- annual_cost_saving — BIGINT
- interest_saving — BIGINT
- risk_reduction — VARCHAR(100)
- current_forecast_date — DATE
- improved_forecast_date — DATE
- advanced_days — INT
- contribution_amount — BIGINT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
recommendation_history
- recommendation_history_id — BIGINT — 기본 키 — NOT NULL
- recommendation_id — BIGINT — 외래 키 → recommendation.recommendation_id — NOT NULL
- status — VARCHAR(30) — NOT NULL
- reason — VARCHAR(500)
- memo — VARCHAR(500)
- changed_at — DATETIME — NOT NULL
recommendation_reason
- reason_id — BIGINT — 기본 키 — NOT NULL
- recommendation_id — BIGINT — 외래 키 → recommendation.recommendation_id — NOT NULL
- code — VARCHAR(50)
- description — TEXT — NOT NULL
- evidence — JSON
report
- report_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- type — VARCHAR(20) — NOT NULL
- period — VARCHAR(20) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- created_at — DATETIME — NOT NULL
saving_goal
- goal_id — BIGINT — 외래 키 → goal.goal_id — NOT NULL
- target_amount — BIGINT — NOT NULL
- target_date — DATE — NOT NULL
savings_payment
- savings_payment_id — BIGINT — 기본 키 — NOT NULL
- deposit_saving_id — BIGINT — 외래 키 → deposit_saving.saving_id — NOT NULL
- payment_date — DATE — NOT NULL
- amount — BIGINT — NOT NULL
- installment_number — INT
- status — VARCHAR(30) — NOT NULL
simulation
- simulation_id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- type — VARCHAR(50) — NOT NULL
- title — VARCHAR(255)
- summary — VARCHAR(500)
- request_snapshot — JSON
- before_snapshot — JSON — NOT NULL
- after_snapshot — JSON — NOT NULL
- comparison — JSON
- cashflow_impact — JSON
- created_at — DATETIME — NOT NULL
- deleted_at — DATETIME
simulation_goal_impact
- simulation_id — BIGINT — 외래 키 → simulation.simulation_id — NOT NULL
- goal_id — BIGINT — 외래 키 → goal.goal_id
- before_forecast_date — DATE
- after_forecast_date — DATE
- difference_days — INT — NOT NULL
simulation_scenario
- scenario_id — BIGINT — 기본 키 — NOT NULL
- simulation_id — BIGINT — 외래 키 → simulation.simulation_id — NOT NULL
- sequence_no — INT — NOT NULL
- scenario_type — VARCHAR(50) — NOT NULL
- parameters — JSON — NOT NULL
spending_goal
- goal_id — BIGINT — 외래 키 → goal.goal_id — NOT NULL
- monthly_budget — BIGINT — NOT NULL
subscription
- subscription_id — VARCHAR(100) — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- card_id — BIGINT — 외래 키 → card.card_id
- name — VARCHAR(150) — NOT NULL
- payment_amount — BIGINT — NOT NULL
- billing_cycle — VARCHAR(30) — NOT NULL
- payment_day — INT
- next_payment_date — DATE
- end_date — DATE
- status — VARCHAR(30) — NOT NULL
- category — VARCHAR(50)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
- canceled_at — DATETIME
subscription_payment_history
- payment_history_id — BIGINT — 기본 키 — NOT NULL
- subscription_id — VARCHAR(100) — 외래 키 → subscription.subscription_id — NOT NULL
- payment_date — DATE — NOT NULL
- payment_amount — BIGINT — NOT NULL
- result_code — VARCHAR(50)
- retry_count — INT — NOT NULL
- result_message — VARCHAR(500)
transaction
- transaction_id — VARCHAR(100) — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- account_id — BIGINT — 외래 키 → account.account_id
- category_id — BIGINT — 외래 키 → transaction_category.category_id
- transaction_date — DATE — NOT NULL
- transaction_time — TIME
- transaction_type — VARCHAR(30) — NOT NULL
- amount — BIGINT — NOT NULL
- balance_after — BIGINT
- merchant_name — VARCHAR(255)
- payment_method — VARCHAR(30)
- summary — VARCHAR(255)
- memo — VARCHAR(500)
- hidden — TINYINT(1) — NOT NULL
- source_type — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME
transaction_category
- category_id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- active — TINYINT(1) — NOT NULL
user
- user_id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
user_setting
- user_id — BIGINT — 외래 키 → user.user_id — NOT NULL
- notification_enabled — TINYINT(1) — NOT NULL
- daily_briefing_enabled — TINYINT(1) — NOT NULL
- monthly_report_enabled — TINYINT(1) — NOT NULL
- updated_at — DATETIME — NOT NULL