특화프로젝트

테이블 (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