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