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)