DB_HANAinPLAN_final_final
Tables (23)
deposit_portfolio
- portfolio_id — bigint
- bank_code — varchar(20) — NOT NULL
- bank_name — varchar(50)
- contract_period — int
- created_at — datetime(6)
- customer_ci — varchar(64)
- expected_interest — decimal(15, 2)
- interest_rate — decimal(5, 2)
- irp_account_number — varchar(50)
- maturity_amount — decimal(15, 2)
- maturity_date — date
- maturity_period — varchar(50)
- principal_amount — decimal(15, 2)
- product_code — varchar(50) — NOT NULL
- product_name — varchar(200)
- status — varchar(20)
- subscription_date — date
- subscription_id — bigint
- updated_at — datetime(6)
- user_id — bigint — NOT NULL
disease_code
- disease_code — varchar(20) — NOT NULL
- applicable_ins_count — int
- applicable_ins_type — varchar(50)
- description — text
- disease_category — varchar(50) — NOT NULL
- disease_name — varchar(50) — NOT NULL
- insurance_comp_count — int
- is_insurable — varchar(1) — NOT NULL
- max_age — int
- min_age — int
- remark — text
- renewal_cycle_years — int
- risk_level — varchar(10)
- waiting_period_days — int
fund_class
- child_fund_cd — varchar(16) — NOT NULL
- class_code — varchar(8)
- load_type — varchar(16)
- sale_status — varchar(16) — NOT NULL
- source_url — varchar(512)
- tax_category — varchar(32)
- fund_cd — varchar(16) — NOT NULL
fund_fees
- child_fund_cd — varchar(16) — NOT NULL
- admin_fee_bps — int
- front_load_pct — decimal(5, 2)
- mgmt_fee_bps — int
- sales_fee_bps — int
- total_fee_bps — int
- trustee_fee_bps — int
fund_master
- fund_cd — varchar(16) — NOT NULL
- asset_type — varchar(50)
- created_at — datetime(6) — NOT NULL
- currency — varchar(8) — NOT NULL
- fund_gb — int — NOT NULL
- fund_name — varchar(255) — NOT NULL
- is_active — bit — NOT NULL
- risk_grade — varchar(16)
- synced_at — datetime(6)
- updated_at — datetime(6)
fund_nav
- nav_id — bigint
- child_fund_cd — varchar(16) — NOT NULL
- created_at — datetime(6)
- nav — decimal(15, 4) — NOT NULL
- nav_date — date — NOT NULL
- published_at — datetime(6)
fund_portfolio
- portfolio_id — bigint
- accumulated_fees — decimal(15, 2)
- bank_code — varchar(20) — NOT NULL
- bank_name — varchar(50)
- created_at — datetime(6)
- current_nav — decimal(15, 4)
- current_units — decimal(15, 6) — NOT NULL
- current_value — decimal(15, 2)
- customer_ci — varchar(64) — NOT NULL
- fund_code — varchar(20) — NOT NULL
- fund_name — varchar(100) — NOT NULL
- fund_type — varchar(50) — NOT NULL
- irp_account_number — varchar(50)
- purchase_amount — decimal(15, 2) — NOT NULL
- purchase_date — date — NOT NULL
- purchase_fee — decimal(15, 2)
- purchase_nav — decimal(15, 4) — NOT NULL
- purchase_units — decimal(15, 6) — NOT NULL
- return_rate — decimal(10, 4)
- risk_level — varchar(20) — NOT NULL
- status — varchar(20)
- subscription_id — bigint
- total_return — decimal(15, 2)
- updated_at — datetime(6)
- user_id — bigint — NOT NULL
- child_fund_cd — varchar(16)
- class_code — varchar(8)
fund_rules
- child_fund_cd — varchar(16) — NOT NULL
- allow_sip — bit
- allow_switch — bit
- buy_settle_days — int
- cutoff_time — time(6)
- increment_amount — decimal(15, 2)
- min_additional — decimal(15, 2)
- min_initial_amount — decimal(15, 2)
- nav_publish_time — time(6)
- redeem_settle_days — int
- redemption_fee_days — int
- redemption_fee_rate — decimal(7, 4)
- unit_type — varchar(16)
fund_transactions
- transaction_id — bigint
- amount — decimal(15, 2) — NOT NULL
- balance_units — decimal(15, 6) — NOT NULL
- created_at — datetime(6)
- description — text
- fee — decimal(15, 2)
- fund_code — varchar(20) — NOT NULL
- irp_account_number — varchar(50)
- nav — decimal(15, 4) — NOT NULL
- portfolio_id — bigint — NOT NULL
- settlement_date — date
- transaction_date — datetime(6) — NOT NULL
- transaction_type — varchar(20) — NOT NULL
- units — decimal(15, 6) — NOT NULL
- user_id — bigint — NOT NULL
industry_code
- industry_code — varchar(20) — NOT NULL
- description — text
- industry_classification — varchar(50) — NOT NULL
- industry_name — varchar(50) — NOT NULL
- premium_surcharge_rate — double
- risk_level — varchar(10) — NOT NULL
- special_conditions — varchar(20)
notifications
- id — bigint
- created_at — datetime(6)
- created_date — datetime(6)
- content — text
- is_read — bit
- read_at — datetime(6)
- title — varchar(200) — NOT NULL
- type — enum — NOT NULL
- user_id — bigint — NOT NULL
tb_banking_account
- account_id — bigint
- account_name — varchar(50) — NOT NULL
- account_number — varchar(20) — NOT NULL
- account_password — varchar(255)
- account_status — enum — NOT NULL
- account_type — int — NOT NULL
- balance — decimal(15, 2) — NOT NULL
- created_at — datetime(6)
- credit_limit — decimal(15, 2)
- currency_code — varchar(3) — NOT NULL
- deposit_period — int
- description — varchar(200)
- expiry_date — datetime(6)
- interest_payment_method — varchar(10)
- interest_rate — decimal(5, 4)
- minimum_balance — decimal(15, 2)
- monthly_deposit_amount — decimal(15, 2)
- opened_date — datetime(6) — NOT NULL
- purpose — varchar(50)
- updated_at — datetime(6)
- user_id — bigint — NOT NULL
- customer_ci — varchar(100) — NOT NULL
tb_banking_transaction
- transaction_id — bigint
- amount — decimal(15, 2) — NOT NULL
- balance_after — decimal(15, 2) — NOT NULL
- created_at — datetime(6) — NOT NULL
- description — varchar(200)
- from_account_id — bigint
- memo — varchar(500)
- processed_date — datetime(6)
- reference_number — varchar(50)
- to_account_id — bigint
- transaction_category — enum — NOT NULL
- transaction_date — datetime(6) — NOT NULL
- transaction_number — varchar(36) — NOT NULL
- transaction_status — enum — NOT NULL
- transaction_type — enum — NOT NULL
- transaction_direction — enum — NOT NULL
- from_account_number — varchar(20)
- to_account_number — varchar(20)
tb_consult
- consult_id — varchar(20) — NOT NULL
- branch_code — varchar(20)
- consult_datetime — datetime(6)
- consult_result — varchar(20)
- consult_status — varchar(20) — NOT NULL
- consult_type — varchar(10) — NOT NULL
- consult_url — varchar(500)
- consultant_id — varchar(20) — NOT NULL
- customer_id — varchar(20) — NOT NULL
- detail — text
- qr_code — varchar(255)
- reservation_datetime — datetime(6) — NOT NULL
tb_consultant
- consultant_id — bigint — NOT NULL
- branch_code — varchar(10)
- branch_name — varchar(100)
- consultation_rating — decimal(3, 2)
- created_date — datetime(6) — NOT NULL
- department — varchar(50)
- employee_id — varchar(20)
- extension — varchar(5)
- hire_date — date
- license_expiry_date — date
- license_issue_date — date
- license_number — varchar(50)
- license_type — varchar(50)
- max_daily_consultations — int
- office_phone — varchar(15)
- position — varchar(50)
- specialization — json
- total_consultations — int
- updated_date — datetime(6)
- work_email — varchar(100)
- work_status — enum
- branch_address — varchar(300)
- branch_latitude — decimal(10, 6)
- branch_longitude — decimal(10, 6)
- consultation_status — enum
tb_customer
- customer_id — bigint — NOT NULL
- asset_level — enum
- career_years — int
- created_date — datetime(6) — NOT NULL
- disability_registered — bit
- industry_code — varchar(10)
- industry_name — varchar(100)
- insurance_rejection — bit
- long_term_medication — bit
- major_disease — bit
- recent_hospitalization — bit
- recent_medical_advice — bit
- updated_date — datetime(6)
- has_irp_account — bit
- irp_account_number — varchar(50)
- irp_bank_code — varchar(10)
tb_customer_disease_detail
- detail_id — bigint
- created_date — datetime(6) — NOT NULL
- customer_id — bigint — NOT NULL
- description — text
- disease_category — varchar(100) — NOT NULL
- disease_code — varchar(10) — NOT NULL
- disease_name — varchar(200) — NOT NULL
- is_chronic — bit — NOT NULL
- progress_period — varchar(255) — NOT NULL
- risk_level — varchar(255) — NOT NULL
- severity — varchar(255) — NOT NULL
tb_deposit_product
- deposit_code — varchar(20) — NOT NULL
- bank_code — varchar(10) — NOT NULL
- bank_name — varchar(50) — NOT NULL
- created_at — datetime(6)
- description — text
- name — varchar(100) — NOT NULL
- updated_at — datetime(6)
tb_deposit_subscription
- subscription_id — bigint
- account_number — varchar(20) — NOT NULL
- bank_code — varchar(10) — NOT NULL
- bank_name — varchar(50) — NOT NULL
- contract_period — int
- created_at — datetime(6)
- current_balance — decimal(15, 2) — NOT NULL
- customer_ci — varchar(100) — NOT NULL
- deposit_code — varchar(20) — NOT NULL
- last_interest_calculation_date — date
- maturity_date — date
- next_interest_payment_date — date
- product_type — int — NOT NULL
- rate — decimal(5, 4)
- status — varchar(20) — NOT NULL
- subscription_date — date — NOT NULL
- unpaid_interest — decimal(15, 2)
- updated_at — datetime(6)
- user_id — bigint — NOT NULL
tb_irp_account
- irp_account_id — bigint
- created_at — datetime(6)
- account_number — varchar(50) — NOT NULL
- account_status — varchar(20)
- bank_code — varchar(10) — NOT NULL
- current_balance — decimal(15, 2)
- customer_ci — varchar(64) — NOT NULL
- customer_id — bigint — NOT NULL
- deposit_day — int
- external_account_id — varchar(100)
- external_last_updated — datetime(6)
- initial_deposit — decimal(15, 2)
- investment_style — varchar(30)
- is_auto_deposit — bit
- last_contribution_date — date
- last_sync_date — datetime(6)
- linked_main_account — varchar(50)
- management_fee_rate — decimal(5, 4)
- maturity_date — date
- monthly_deposit — decimal(15, 2)
- open_date — date
- product_code — varchar(20)
- product_name — varchar(100)
- return_rate — decimal(7, 4)
- sync_error_message — varchar(500)
- sync_status — varchar(20)
- total_contribution — decimal(15, 2)
- total_return — decimal(15, 2)
- trust_fee_rate — decimal(5, 4)
- created_date — datetime(6)
tb_schedule
- schedule_id — bigint
- client_id — bigint
- client_name — varchar(50)
- consultant_id — bigint — NOT NULL
- created_at — datetime(6) — NOT NULL
- description — varchar(1000)
- end_time — datetime(6) — NOT NULL
- is_all_day — bit
- location — varchar(200)
- memo — varchar(500)
- schedule_type — enum — NOT NULL
- start_time — datetime(6) — NOT NULL
- status — enum — NOT NULL
- title — varchar(200) — NOT NULL
- updated_at — datetime(6)
tb_user
- user_id — bigint
- birth_date — date — NOT NULL
- created_date — datetime(6) — NOT NULL
- email — varchar(100)
- gender — enum — NOT NULL
- is_active — bit
- is_phone_verified — bit
- kakao_id — varchar(100)
- last_login_date — datetime(6)
- login_type — enum — NOT NULL
- password — varchar(255)
- phone_number — varchar(13) — NOT NULL
- social_number — varchar(13) — NOT NULL
- updated_date — datetime(6)
- user_name — varchar(50) — NOT NULL
- user_type — enum — NOT NULL
- ci — varchar(100)
video_call_rooms
- id — bigint
- created_at — datetime(6)
- updated_at — datetime(6)
- callee_id — bigint — NOT NULL
- callee_session_description — varchar(1000)
- caller_id — bigint — NOT NULL
- caller_session_description — varchar(1000)
- end_time — datetime(6)
- room_id — varchar(255) — NOT NULL
- start_time — datetime(6)
- status — enum — NOT NULL
- created_date — datetime(6)