DB_HANAinPLAN_final

Tables (43)

base_entity

  • created_by — VARCHAR(20)
  • updated_by — VARCHAR(20)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

base_time_entity

  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

branch_code

  • branch_code — VARCHAR(20)
  • branch_name — VARCHAR(100) — NOT NULL
  • address — VARCHAR(200) — NOT NULL
  • phone_number — VARCHAR(20)
  • operating_hours — VARCHAR(100)
  • latitude — DECIMAL(10,6)
  • longitude — DECIMAL(10,6)
  • status — VARCHAR(10) — NOT NULL

disease_code

  • disease_code — VARCHAR(20)
  • disease_name — VARCHAR(50) — NOT NULL
  • disease_category — VARCHAR(50) — NOT NULL
  • risk_level — VARCHAR(10)
  • is_insurable — VARCHAR(1) — NOT NULL
  • description — TEXT
  • min_age — INT
  • max_age — INT
  • waiting_period_days — INT
  • renewal_cycle_years — INT
  • applicable_ins_count — INT
  • applicable_ins_type — VARCHAR(50)
  • insurance_comp_count — INT
  • remark — TEXT

hana_accounts

  • account_number — VARCHAR(20)
  • account_type — INT — NOT NULL
  • balance — DECIMAL(15,2)
  • opening_date — DATE
  • customer_ci — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

hana_customers

  • user_id — BIGINT
  • ci — VARCHAR(64) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • gender — VARCHAR(1)
  • birth_date — VARCHAR(8)
  • phone — VARCHAR(20)
  • created_at — TIMESTAMP

hana_financial_products

  • product_id — BIGINT
  • product_code — VARCHAR(20) — NOT NULL
  • product_name — VARCHAR(100) — NOT NULL
  • deposit_type — VARCHAR(50)
  • min_contract_period — INT
  • max_contract_period — INT
  • contract_period_unit — VARCHAR(10)
  • subscription_target — VARCHAR(100)
  • subscription_amount — DECIMAL(15,2)
  • product_category — VARCHAR(50)
  • interest_payment — VARCHAR(100)
  • tax_benefit — VARCHAR(200)
  • partial_withdrawal — VARCHAR(100)
  • cancellation_penalty — VARCHAR(200)
  • description — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

hana_general_insurance

  • product_id — BIGINT
  • product_code — VARCHAR(20) — NOT NULL
  • product_name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50)
  • benefit_name — VARCHAR(100)
  • payment_reason — VARCHAR(200)
  • payment_amount — DECIMAL(15,2)
  • subscription_amount_basic — DECIMAL(15,2)
  • subscription_amount_male — DECIMAL(15,2)
  • subscription_amount_female — DECIMAL(15,2)
  • interest_rate — DECIMAL(5,4)
  • insurance_price_index_male — DECIMAL(5,4)
  • insurance_price_index_female — DECIMAL(5,4)
  • product_features — TEXT
  • surrender_value — DECIMAL(15,2)
  • renewal_cycle — VARCHAR(50)
  • is_universal — VARCHAR(10)
  • sales_channel — VARCHAR(100)
  • special_notes — TEXT
  • representative_number — VARCHAR(20)
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

hana_insurance_subscriptions

  • subscription_id — BIGINT
  • customer_ci — VARCHAR(64) — NOT NULL
  • product_code — VARCHAR(20) — NOT NULL
  • product_type — VARCHAR(20) — NOT NULL
  • policy_number — VARCHAR(30) — NOT NULL
  • subscription_date — DATE — NOT NULL
  • maturity_date — DATE
  • premium_amount — DECIMAL(15,2) — NOT NULL
  • payment_frequency — VARCHAR(20)
  • coverage_amount — DECIMAL(15,2)
  • beneficiary_name — VARCHAR(100)
  • beneficiary_relation — VARCHAR(20)
  • payment_method — VARCHAR(20)
  • payment_account — VARCHAR(50)
  • subscription_status — VARCHAR(20) — NOT NULL
  • risk_assessment — VARCHAR(20)
  • medical_exam_required — BOOLEAN
  • medical_exam_date — DATE
  • medical_exam_result — VARCHAR(20)
  • agent_code — VARCHAR(20)
  • branch_code — VARCHAR(20)
  • special_conditions — VARCHAR(500)
  • exclusions — VARCHAR(500)
  • waiting_period — INT
  • grace_period — INT
  • renewal_option — BOOLEAN
  • automatic_renewal — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

hana_interest_rates

  • interest_rate_id — BIGINT
  • product_code — VARCHAR(20) — NOT NULL
  • interest_type — ENUM('BASIC', 'PREFERENTIAL', 'AFTER_MATURITY', 'EARLY_WITHDRAWAL') — NOT NULL
  • maturity_period — VARCHAR(50)
  • interest_rate — DECIMAL(5,4) — NOT NULL
  • is_irp — BOOLEAN
  • effective_date — DATE — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

hana_pension_insurance

  • product_id — BIGINT
  • product_code — VARCHAR(20) — NOT NULL
  • product_name — VARCHAR(100) — NOT NULL
  • maintenance_period — VARCHAR(50)
  • premium_payment — DECIMAL(15,2)
  • contractor_accumulation_male — DECIMAL(15,2)
  • accumulation_rate_male — DECIMAL(5,4)
  • surrender_value_male — DECIMAL(15,2)
  • contractor_accumulation_female — DECIMAL(15,2)
  • accumulation_rate_female — DECIMAL(5,4)
  • surrender_value_female — DECIMAL(15,2)
  • expected_return_rate_minimum — DECIMAL(5,4)
  • expected_return_rate_current — DECIMAL(5,4)
  • expected_return_rate_average — DECIMAL(5,4)
  • business_expense_ratio — DECIMAL(5,4)
  • risk_coverage — VARCHAR(200)
  • current_announced_rate — DECIMAL(5,4)
  • minimum_guaranteed_rate — VARCHAR(20)
  • subscription_type — VARCHAR(50)
  • is_universal — VARCHAR(10)
  • payment_method — VARCHAR(100)
  • sales_channel — VARCHAR(100)
  • special_notes — TEXT
  • representative_number — VARCHAR(20)
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

hana_product_subscriptions

  • subscription_id — BIGINT
  • customer_ci — VARCHAR(64) — NOT NULL
  • product_code — VARCHAR(20) — NOT NULL
  • account_number — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • subscription_date — DATE — NOT NULL
  • maturity_date — DATE
  • contract_period — INT
  • maturity_period — VARCHAR(50)
  • rate_type — VARCHAR(10)
  • base_rate — DECIMAL(5,4)
  • preferential_rate — DECIMAL(5,4)
  • final_applied_rate — DECIMAL(5,4)
  • preferential_reason — VARCHAR(200)
  • interest_calculation_basis — VARCHAR(50)
  • interest_payment_method — VARCHAR(20)
  • interest_type — VARCHAR(10)
  • contract_principal — DECIMAL(15,2)
  • current_balance — DECIMAL(15,2)
  • unpaid_interest — DECIMAL(15,2)
  • unpaid_tax — DECIMAL(15,2)
  • last_interest_calculation_date — DATE
  • next_interest_payment_date — DATE
  • branch_name — VARCHAR(100)
  • monthly_payment_amount — DECIMAL(15,2)
  • monthly_payment_day — INT
  • total_installments — INT
  • completed_installments — INT
  • missed_installments — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

hana_transactions

  • transaction_id — BIGINT
  • transaction_number — VARCHAR(36) — NOT NULL
  • from_account_number — VARCHAR(20)
  • to_account_number — VARCHAR(20)
  • transaction_type — ENUM('DEPOSIT', 'WITHDRAWAL', 'TRANSFER', 'INTEREST', 'FEE') — NOT NULL
  • amount — DECIMAL(15,2) — NOT NULL
  • balance_after — DECIMAL(15,2) — NOT NULL
  • description — VARCHAR(200)
  • transaction_date — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP

hanhwa_customers

  • customer_id — BIGINT
  • ci — VARCHAR(64) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • gender — VARCHAR(10)
  • birth_date — VARCHAR(8)
  • phone — VARCHAR(20)
  • email — VARCHAR(100)
  • address — VARCHAR(200)
  • occupation — VARCHAR(100)
  • marital_status — VARCHAR(20)
  • customer_type — VARCHAR(20)
  • risk_level — VARCHAR(20)
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

hanhwa_general_insurance

  • product_id — BIGINT
  • product_code — VARCHAR(20) — NOT NULL
  • product_name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50)
  • benefit_name — VARCHAR(100)
  • payment_reason — VARCHAR(200)
  • payment_amount — DECIMAL(15,2)
  • subscription_amount_basic — DECIMAL(15,2)
  • subscription_amount_male — DECIMAL(15,2)
  • subscription_amount_female — DECIMAL(15,2)
  • interest_rate — DECIMAL(5,4)
  • insurance_price_index_male — DECIMAL(5,4)
  • insurance_price_index_female — DECIMAL(5,4)
  • product_features — TEXT
  • surrender_value — DECIMAL(15,2)
  • renewal_cycle — VARCHAR(50)
  • is_universal — VARCHAR(10)
  • sales_channel — VARCHAR(100)
  • special_notes — TEXT
  • representative_number — VARCHAR(20)
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

hanhwa_insurance_subscriptions

  • subscription_id — BIGINT
  • customer_ci — VARCHAR(64) — NOT NULL
  • product_code — VARCHAR(20) — NOT NULL
  • product_type — VARCHAR(20) — NOT NULL
  • policy_number — VARCHAR(30) — NOT NULL
  • subscription_date — DATE — NOT NULL
  • maturity_date — DATE
  • premium_amount — DECIMAL(15,2) — NOT NULL
  • payment_frequency — VARCHAR(20)
  • coverage_amount — DECIMAL(15,2)
  • beneficiary_name — VARCHAR(100)
  • beneficiary_relation — VARCHAR(20)
  • payment_method — VARCHAR(20)
  • payment_account — VARCHAR(50)
  • subscription_status — VARCHAR(20) — NOT NULL
  • risk_assessment — VARCHAR(20)
  • medical_exam_required — BOOLEAN
  • medical_exam_date — DATE
  • medical_exam_result — VARCHAR(20)
  • agent_code — VARCHAR(20)
  • branch_code — VARCHAR(20)
  • special_conditions — VARCHAR(500)
  • exclusions — VARCHAR(500)
  • waiting_period — INT
  • grace_period — INT
  • renewal_option — BOOLEAN
  • automatic_renewal — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

hanhwa_pension_insurance

  • product_id — BIGINT
  • product_code — VARCHAR(20) — NOT NULL
  • product_name — VARCHAR(100) — NOT NULL
  • maintenance_period — VARCHAR(50)
  • premium_payment — DECIMAL(15,2)
  • contractor_accumulation_male — DECIMAL(15,2)
  • accumulation_rate_male — DECIMAL(5,4)
  • surrender_value_male — DECIMAL(15,2)
  • contractor_accumulation_female — DECIMAL(15,2)
  • accumulation_rate_female — DECIMAL(5,4)
  • surrender_value_female — DECIMAL(15,2)
  • expected_return_rate_minimum — DECIMAL(5,4)
  • expected_return_rate_current — DECIMAL(5,4)
  • expected_return_rate_average — DECIMAL(5,4)
  • business_expense_ratio — DECIMAL(5,4)
  • risk_coverage — VARCHAR(200)
  • current_announced_rate — DECIMAL(5,4)
  • minimum_guaranteed_rate — VARCHAR(20)
  • subscription_type — VARCHAR(50)
  • is_universal — VARCHAR(10)
  • payment_method — VARCHAR(100)
  • sales_channel — VARCHAR(100)
  • special_notes — TEXT
  • representative_number — VARCHAR(20)
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

industry_code

  • industry_code — VARCHAR(20)
  • industry_name — VARCHAR(50) — NOT NULL
  • industry_classification — VARCHAR(50) — NOT NULL
  • risk_level — VARCHAR(10) — NOT NULL
  • special_conditions — VARCHAR(20)
  • premium_surcharge_rate — DOUBLE
  • description — TEXT

kookmin_accounts

  • account_number — VARCHAR(20)
  • account_type — INT — NOT NULL
  • balance — DECIMAL(15,2)
  • opening_date — DATE
  • customer_ci — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

kookmin_customers

  • user_id — BIGINT
  • ci — VARCHAR(64) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • gender — VARCHAR(1)
  • birth_date — VARCHAR(8)
  • phone — VARCHAR(20)
  • created_at — TIMESTAMP

kookmin_financial_products

  • product_id — BIGINT
  • product_code — VARCHAR(20) — NOT NULL
  • product_name — VARCHAR(100) — NOT NULL
  • deposit_type — VARCHAR(50)
  • min_contract_period — INT
  • max_contract_period — INT
  • contract_period_unit — VARCHAR(10)
  • subscription_target — VARCHAR(100)
  • subscription_amount — DECIMAL(15,2)
  • product_category — VARCHAR(50)
  • interest_payment — VARCHAR(100)
  • tax_benefit — VARCHAR(200)
  • partial_withdrawal — VARCHAR(100)
  • cancellation_penalty — VARCHAR(200)
  • description — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

kookmin_interest_rates

  • interest_rate_id — BIGINT
  • product_code — VARCHAR(20) — NOT NULL
  • interest_type — ENUM('BASIC', 'PREFERENTIAL', 'AFTER_MATURITY', 'EARLY_WITHDRAWAL') — NOT NULL
  • maturity_period — VARCHAR(50)
  • interest_rate — DECIMAL(5,4) — NOT NULL
  • is_irp — BOOLEAN
  • effective_date — DATE — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

kookmin_product_subscriptions

  • subscription_id — BIGINT
  • customer_ci — VARCHAR(64) — NOT NULL
  • product_code — VARCHAR(20) — NOT NULL
  • account_number — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • subscription_date — DATE — NOT NULL
  • maturity_date — DATE
  • contract_period — INT
  • maturity_period — VARCHAR(50)
  • rate_type — VARCHAR(10)
  • base_rate — DECIMAL(5,4)
  • preferential_rate — DECIMAL(5,4)
  • final_applied_rate — DECIMAL(5,4)
  • preferential_reason — VARCHAR(200)
  • interest_calculation_basis — VARCHAR(50)
  • interest_payment_method — VARCHAR(20)
  • interest_type — VARCHAR(10)
  • contract_principal — DECIMAL(15,2)
  • current_balance — DECIMAL(15,2)
  • unpaid_interest — DECIMAL(15,2)
  • unpaid_tax — DECIMAL(15,2)
  • last_interest_calculation_date — DATE
  • next_interest_payment_date — DATE
  • branch_name — VARCHAR(100)
  • monthly_payment_amount — DECIMAL(15,2)
  • monthly_payment_day — INT
  • total_installments — INT
  • completed_installments — INT
  • missed_installments — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

kookmin_transactions

  • transaction_id — BIGINT
  • transaction_number — VARCHAR(36) — NOT NULL
  • from_account_number — VARCHAR(20)
  • to_account_number — VARCHAR(20)
  • transaction_type — ENUM('DEPOSIT', 'WITHDRAWAL', 'TRANSFER', 'INTEREST', 'FEE') — NOT NULL
  • amount — DECIMAL(15,2) — NOT NULL
  • balance_after — DECIMAL(15,2) — NOT NULL
  • description — VARCHAR(200)
  • transaction_date — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP

samsung_customers

  • customer_id — BIGINT
  • ci — VARCHAR(64) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • gender — VARCHAR(10)
  • birth_date — VARCHAR(8)
  • phone — VARCHAR(20)
  • email — VARCHAR(100)
  • address — VARCHAR(200)
  • occupation — VARCHAR(100)
  • marital_status — VARCHAR(20)
  • customer_type — VARCHAR(20)
  • risk_level — VARCHAR(20)
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

samsung_general_insurance

  • product_id — BIGINT
  • product_code — VARCHAR(20) — NOT NULL
  • product_name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50)
  • benefit_name — VARCHAR(100)
  • payment_reason — VARCHAR(200)
  • payment_amount — DECIMAL(15,2)
  • subscription_amount_basic — DECIMAL(15,2)
  • subscription_amount_male — DECIMAL(15,2)
  • subscription_amount_female — DECIMAL(15,2)
  • interest_rate — DECIMAL(5,4)
  • insurance_price_index_male — DECIMAL(5,4)
  • insurance_price_index_female — DECIMAL(5,4)
  • product_features — TEXT
  • surrender_value — DECIMAL(15,2)
  • renewal_cycle — VARCHAR(50)
  • is_universal — VARCHAR(10)
  • sales_channel — VARCHAR(100)
  • special_notes — TEXT
  • representative_number — VARCHAR(20)
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

samsung_insurance_subscriptions

  • subscription_id — BIGINT
  • customer_ci — VARCHAR(64) — NOT NULL
  • product_code — VARCHAR(20) — NOT NULL
  • product_type — VARCHAR(20) — NOT NULL
  • policy_number — VARCHAR(30) — NOT NULL
  • subscription_date — DATE — NOT NULL
  • maturity_date — DATE
  • premium_amount — DECIMAL(15,2) — NOT NULL
  • payment_frequency — VARCHAR(20)
  • coverage_amount — DECIMAL(15,2)
  • beneficiary_name — VARCHAR(100)
  • beneficiary_relation — VARCHAR(20)
  • payment_method — VARCHAR(20)
  • payment_account — VARCHAR(50)
  • subscription_status — VARCHAR(20) — NOT NULL
  • risk_assessment — VARCHAR(20)
  • medical_exam_required — BOOLEAN
  • medical_exam_date — DATE
  • medical_exam_result — VARCHAR(20)
  • agent_code — VARCHAR(20)
  • branch_code — VARCHAR(20)
  • special_conditions — VARCHAR(500)
  • exclusions — VARCHAR(500)
  • waiting_period — INT
  • grace_period — INT
  • renewal_option — BOOLEAN
  • automatic_renewal — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

samsung_pension_insurance

  • product_id — BIGINT
  • product_code — VARCHAR(20) — NOT NULL
  • product_name — VARCHAR(100) — NOT NULL
  • maintenance_period — VARCHAR(50)
  • premium_payment — DECIMAL(15,2)
  • contractor_accumulation_male — DECIMAL(15,2)
  • accumulation_rate_male — DECIMAL(5,4)
  • surrender_value_male — DECIMAL(15,2)
  • contractor_accumulation_female — DECIMAL(15,2)
  • accumulation_rate_female — DECIMAL(5,4)
  • surrender_value_female — DECIMAL(15,2)
  • expected_return_rate_minimum — DECIMAL(5,4)
  • expected_return_rate_current — DECIMAL(5,4)
  • expected_return_rate_average — DECIMAL(5,4)
  • business_expense_ratio — DECIMAL(5,4)
  • risk_coverage — VARCHAR(200)
  • current_announced_rate — DECIMAL(5,4)
  • minimum_guaranteed_rate — VARCHAR(20)
  • subscription_type — VARCHAR(50)
  • is_universal — VARCHAR(10)
  • payment_method — VARCHAR(100)
  • sales_channel — VARCHAR(100)
  • special_notes — TEXT
  • representative_number — VARCHAR(20)
  • is_active — BOOLEAN
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

shinhan_accounts

  • account_number — VARCHAR(20)
  • account_type — INT — NOT NULL
  • balance — DECIMAL(15,2)
  • opening_date — DATE
  • customer_ci — VARCHAR(100) — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

shinhan_customers

  • user_id — BIGINT
  • ci — VARCHAR(64) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • gender — VARCHAR(1)
  • birth_date — VARCHAR(8)
  • phone — VARCHAR(20)
  • created_at — TIMESTAMP

shinhan_financial_products

  • product_id — BIGINT
  • product_code — VARCHAR(20) — NOT NULL
  • product_name — VARCHAR(100) — NOT NULL
  • deposit_type — VARCHAR(50)
  • min_contract_period — INT
  • max_contract_period — INT
  • contract_period_unit — VARCHAR(10)
  • subscription_target — VARCHAR(100)
  • subscription_amount — DECIMAL(15,2)
  • product_category — VARCHAR(50)
  • interest_payment — VARCHAR(100)
  • tax_benefit — VARCHAR(200)
  • partial_withdrawal — VARCHAR(100)
  • cancellation_penalty — VARCHAR(200)
  • description — TEXT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

shinhan_interest_rates

  • interest_rate_id — BIGINT
  • product_code — VARCHAR(20) — NOT NULL
  • interest_type — ENUM('BASIC', 'PREFERENTIAL', 'AFTER_MATURITY', 'EARLY_WITHDRAWAL') — NOT NULL
  • maturity_period — VARCHAR(50)
  • interest_rate — DECIMAL(5,4) — NOT NULL
  • is_irp — BOOLEAN
  • effective_date — DATE — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

shinhan_product_subscriptions

  • subscription_id — BIGINT
  • customer_ci — VARCHAR(64) — NOT NULL
  • product_code — VARCHAR(20) — NOT NULL
  • account_number — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • subscription_date — DATE — NOT NULL
  • maturity_date — DATE
  • contract_period — INT
  • maturity_period — VARCHAR(50)
  • rate_type — VARCHAR(10)
  • base_rate — DECIMAL(5,4)
  • preferential_rate — DECIMAL(5,4)
  • final_applied_rate — DECIMAL(5,4)
  • preferential_reason — VARCHAR(200)
  • interest_calculation_basis — VARCHAR(50)
  • interest_payment_method — VARCHAR(20)
  • interest_type — VARCHAR(10)
  • contract_principal — DECIMAL(15,2)
  • current_balance — DECIMAL(15,2)
  • unpaid_interest — DECIMAL(15,2)
  • unpaid_tax — DECIMAL(15,2)
  • last_interest_calculation_date — DATE
  • next_interest_payment_date — DATE
  • branch_name — VARCHAR(100)
  • monthly_payment_amount — DECIMAL(15,2)
  • monthly_payment_day — INT
  • total_installments — INT
  • completed_installments — INT
  • missed_installments — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

shinhan_transactions

  • transaction_id — BIGINT
  • transaction_number — VARCHAR(36) — NOT NULL
  • from_account_number — VARCHAR(20)
  • to_account_number — VARCHAR(20)
  • transaction_type — ENUM('DEPOSIT', 'WITHDRAWAL', 'TRANSFER', 'INTEREST', 'FEE') — NOT NULL
  • amount — DECIMAL(15,2) — NOT NULL
  • balance_after — DECIMAL(15,2) — NOT NULL
  • description — VARCHAR(200)
  • transaction_date — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP

tb_banking_account

  • account_id — BIGINT
  • user_id — BIGINT — NOT NULL
  • account_number — VARCHAR(14) — NOT NULL
  • account_name — VARCHAR(50) — NOT NULL
  • account_type — ENUM('CHECKING', 'SAVINGS', 'TIME_DEPOSIT', 'FIXED_DEPOSIT', 'LOAN', 'CREDIT') — NOT NULL
  • account_status — ENUM('ACTIVE', 'INACTIVE', 'SUSPENDED', 'CLOSED', 'FROZEN') — NOT NULL
  • balance — DECIMAL(15,2) — NOT NULL
  • currency_code — VARCHAR(3) — NOT NULL
  • opened_date — TIMESTAMP — NOT NULL
  • expiry_date — TIMESTAMP
  • interest_rate — DECIMAL(5,4)
  • minimum_balance — DECIMAL(15,2)
  • credit_limit — DECIMAL(15,2)
  • description — VARCHAR(200)
  • purpose — VARCHAR(50)
  • monthly_deposit_amount — DECIMAL(15,2)
  • deposit_period — INT
  • interest_payment_method — VARCHAR(10)
  • account_password — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

tb_banking_transaction

  • transaction_id — BIGINT
  • transaction_number — VARCHAR(36) — NOT NULL
  • from_account_id — BIGINT
  • to_account_id — BIGINT
  • transaction_type — ENUM('DEPOSIT', 'WITHDRAWAL', 'TRANSFER', 'AUTO_TRANSFER', 'INTEREST', 'FEE', 'REFUND', 'REVERSAL') — NOT NULL
  • transaction_category — ENUM('SALARY', 'PENSION', 'SAVINGS', 'INVESTMENT', 'LOAN', 'INSURANCE', 'UTILITY', 'SHOPPING', 'FOOD', 'TRANSPORT', 'MEDICAL', 'EDUCATION', 'ENTERTAINMENT', 'OTHER') — NOT NULL
  • amount — DECIMAL(15,2) — NOT NULL
  • balance_after — DECIMAL(15,2) — NOT NULL
  • fee — DECIMAL(15,2)
  • description — VARCHAR(200)
  • counterpart_account_number — VARCHAR(20)
  • counterpart_name — VARCHAR(50)
  • transaction_status — ENUM('PENDING', 'PROCESSING', 'COMPLETED', 'FAILED', 'CANCELLED', 'REVERSED') — NOT NULL
  • transaction_date — TIMESTAMP — NOT NULL
  • processed_date — TIMESTAMP
  • failure_reason — VARCHAR(500)
  • reference_number — VARCHAR(50)
  • memo — VARCHAR(500)
  • created_at — TIMESTAMP — NOT NULL

tb_consult

  • consult_id — VARCHAR(20)
  • consult_type — VARCHAR(10) — NOT NULL
  • reservation_datetime — TIMESTAMP — NOT NULL
  • consult_datetime — TIMESTAMP
  • consult_status — VARCHAR(20) — NOT NULL
  • qr_code — VARCHAR(255)
  • consult_url — VARCHAR(500)
  • detail — TEXT
  • consult_result — VARCHAR(20)
  • branch_code — VARCHAR(20)
  • customer_id — VARCHAR(20) — NOT NULL
  • consultant_id — VARCHAR(20) — NOT NULL

tb_consultant

  • consultant_id — BIGINT
  • employee_id — VARCHAR(20)
  • department — VARCHAR(50)
  • position — VARCHAR(50)
  • branch_code — VARCHAR(10)
  • branch_name — VARCHAR(100)
  • license_type — VARCHAR(50)
  • license_number — VARCHAR(50)
  • license_issue_date — DATE
  • license_expiry_date — DATE
  • specialization — JSON
  • hire_date — DATE
  • work_status — ENUM('ACTIVE', 'INACTIVE', 'ON_LEAVE')
  • max_daily_consultations — INT
  • consultation_rating — DECIMAL(3,2)
  • total_consultations — INT
  • office_phone — VARCHAR(15)
  • extension — VARCHAR(5)
  • work_email — VARCHAR(100)
  • created_date — TIMESTAMP — NOT NULL
  • updated_date — TIMESTAMP

tb_customer

  • customer_id — BIGINT
  • recent_medical_advice — BOOLEAN
  • recent_hospitalization — BOOLEAN
  • major_disease — BOOLEAN
  • long_term_medication — BOOLEAN
  • disability_registered — BOOLEAN
  • insurance_rejection — BOOLEAN
  • industry_code — VARCHAR(10)
  • industry_name — VARCHAR(100)
  • career_years — INT
  • asset_level — ENUM('UNDER_1', 'FROM_1_TO_5', 'FROM_5_TO_10', 'FROM_10_TO_30', 'FROM_30_TO_50', 'OVER_50')
  • created_date — TIMESTAMP — NOT NULL
  • updated_date — TIMESTAMP

tb_financial_products

  • product_id — VARCHAR(20)
  • product_name — VARCHAR(200) — NOT NULL
  • product_type — VARCHAR(20) — NOT NULL
  • provider — VARCHAR(100) — NOT NULL
  • created_date — TIMESTAMP — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • detail — TEXT

tb_user

  • user_id — BIGINT
  • user_type — ENUM('GENERAL', 'COUNSELOR') — NOT NULL
  • user_name — VARCHAR(50) — NOT NULL
  • social_number — VARCHAR(8) — NOT NULL
  • phone_number — VARCHAR(13) — NOT NULL
  • birth_date — DATE — NOT NULL
  • gender — ENUM('M', 'F') — NOT NULL
  • email — VARCHAR(100)
  • password — VARCHAR(255)
  • kakao_id — VARCHAR(100)
  • login_type — ENUM('PASSWORD', 'KAKAO') — NOT NULL
  • is_phone_verified — BOOLEAN
  • is_active — BOOLEAN
  • created_date — TIMESTAMP — NOT NULL
  • updated_date — TIMESTAMP
  • last_login_date — TIMESTAMP

users

  • id — BIGINT
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(20)
  • birth_date — VARCHAR(8)
  • gender — VARCHAR(1)
  • ci — VARCHAR(64)

verification_codes

  • verification_id — BIGINT
  • phone_number — VARCHAR(13) — NOT NULL
  • verification_code — VARCHAR(6) — NOT NULL
  • is_verified — BOOLEAN
  • attempt_count — INT
  • created_at — TIMESTAMP — NOT NULL
  • expires_at — TIMESTAMP — NOT NULL
  • verified_at — TIMESTAMP