test
Tables (30)
ACCOUNT_LIMIT_TBL
- al_account_id — INT — NOT NULL
- a_no — INT — NOT NULL
- al_per_transfer_limit — DECIMAL(18,2) — NOT NULL
- al_daily_transfer_limit — DECIMAL(18,2) — NOT NULL
- al_monthly_transfer_limit — DECIMAL(18,2) — NOT NULL
- al_overdraft_limit — DECIMAL(18,2) — NOT NULL
ACCOUNT_STATUS_HISTORY_TBL
- ash_hist_no — VARCHAR(255) — NOT NULL
- a_no — VARCHAR(255) — NOT NULL
- ash_hist_id — INT — NOT NULL
- ash_prev_status — VARCHAR(20)
- ash_new_status — VARCHAR(20) — NOT NULL
- ash_reason_code — VARCHAR(30)
- ash_changed_by — VARCHAR(50)
- ash_changed_at — TIMESTAMP
ACCOUNT_TBL
- a_no — INT — NOT NULL
- c_no — INT — NOT NULL
- a_id — VARCHAR(20) — NOT NULL
- a_account_no — VARCHAR(30) — NOT NULL
- a_app_id — INT
- a_product_code — VARCHAR(30) — NOT NULL
- a_account_type — VARCHAR(20) — NOT NULL
- a_opened_at — TIMESTAMP — NOT NULL
- a_account_pwd — VARCHAR(10) — NOT NULL
- a_closed_at — TIMESTAMP
- a_status — VARCHAR(20) — NOT NULL
- a_balance — DECIMAL(18,2) — NOT NULL
- a_currency — VARCHAR(3) — NOT NULL
- a_nickname — VARCHAR(50)
- a_last_tx_at — TIMESTAMP
- a_created_by — VARCHAR(20) — NOT NULL
- a_updated_at — TIMESTAMP
- a_agree_terms — VARCHAR(1) — NOT NULL
- a_agree_privacy — VARCHAR(1) — NOT NULL
- a_agree_marketing — VARCHAR(1)
- a_rate — DECIMAL(6,4)
ASSET_MANAGEMENT_DATA_TBL
- amd_no — INT — NOT NULL
- amd_age_group — INT
- amd_gender — VARCHAR(10)
- amd_occupation — VARCHAR(25)
- amd_month_income — INT
- amd_total_amount — INT
- Field — VARCHAR(255)
ASSET_MANAGEMENT_TBL
- am_no — INT — NOT NULL
- Key — VARCHAR(255) — NOT NULL
- c_no — INT — NOT NULL
- am_id — VARCHAR(20) — NOT NULL
- am_grade — VARCHAR(100) — NOT NULL
- am_salary — INT — NOT NULL
- am_consumption — INT — NOT NULL
- am_age_group — INT
- am_gender — VARCHAR(10)
- am_occupation — VARCHAR(255)
- am_month_income — INT
- am_target_asset — INT
CUSTOMER_TBL
- c_no — INT — NOT NULL
- c_id — VARCHAR(20) — NOT NULL
- c_user_id — VARCHAR(50) — NOT NULL
- c_password — VARCHAR(100) — NOT NULL
- c_name_kr — VARCHAR(100) — NOT NULL
- c_name_en — VARCHAR(100)
- c_birth_dt — TIMESTAMP
- c_gender_cd — VARCHAR(1)
- c_nationality_cd — VARCHAR(3) — NOT NULL
- c_phone_mobile — VARCHAR(20) — NOT NULL
- c_phone_home — VARCHAR(20)
- c_email — VARCHAR(150) — NOT NULL
- c_rrn_hash — VARCHAR(256)
- c_di_hash — VARCHAR(256)
- c_ci_hash — VARCHAR(256)
- c_auth_level — INT(2) — NOT NULL
- c_risk_grade — VARCHAR(10) — NOT NULL
- c_aml_risk_score — DECIMAL(5, 2)
- c_is_pep — VARCHAR(1) — NOT NULL — 'N','Y'
- c_is_sanction_hit — VARCHAR(1) — NOT NULL — 'N','Y'
- c_status — VARCHAR(20) — NOT NULL
- c_remark — VARCHAR(4000)
- c_created_at — TIMESTAMP(6) — NOT NULL
- c_created_by — VARCHAR(50) — NOT NULL
- c_updated_at — TIMESTAMP(6)
- c_updated_by — VARCHAR(50)
- c_agree_terms — VARCHAR(1) — NOT NULL
- c_agree_privacy — VARCHAR(1) — NOT NULL
- c_agree_marketing — VARCHAR(1)
- c_login_type — VARCHAR(20) — NOT NULL
DEPOSIT_PRODUCT_TBL
- dp_no — INT — NOT NULL
- dp_code — VARCHAR(20) — NOT NULL
- dp_name — VARCHAR(100) — NOT NULL
- dp_description — TEXT — NOT NULL
- dp_type — VARCHAR(20) — NOT NULL
- dp_min_amount — DECIMAL(18,2) — NOT NULL
- dp_max_amount — DECIMAL(18,2) — NOT NULL
- dp_min_months — INT — NOT NULL
- dp_max_months — INT — NOT NULL
- dp_early_termination_rate — DECIMAL(6,4)
- dp_interest_payment_type — VARCHAR(20)
- dp_created_at — TIMESTAMP — NOT NULL
- dp_updated_at — TIMESTAMP
- dp_is_active — VARCHAR(1)
DEPOSIT_TBL
- d_no — INT — NOT NULL
- dp_no — INT — NOT NULL
- c_no — INT — NOT NULL
- a_no — INT — NOT NULL
- d_id — VARCHAR(20) — NOT NULL
- d_account_no — VARCHAR(30) — NOT NULL
- d_join_date — TIMESTAMP — NOT NULL
- d_maturity_date — TIMESTAMP
- d_amount — INT — NOT NULL
- d_interest_rate — DECIMAL(6,4) — NOT NULL
- d_status — VARCHAR(20) — NOT NULL
- d_updated_at — TIMESTAMP
- d_freeze_yn — VARCHAR(1) — NOT NULL
- d_dormant_yn — VARCHAR(1) — NOT NULL
- d_apy — DECIMAL(6,4)
- d_accr_int — DECIMAL(18,2) — NOT NULL
- d_principal_bal — DECIMAL(18,2) — NOT NULL
FOREIGN
- fp_no — INT — NOT NULL
- fp_cur_unit — VARCHAR(20) — NOT NULL
- fp_cur_nm — VARCHAR(50) — NOT NULL
- fp_ttb — DECIMAL(16,6) — NOT NULL
- fp_tts — DECIMAL(16,6) — NOT NULL
- fp_deal_bas_r — DECIMAL(16,6) — NOT NULL
- fp_bkpr — DECIMAL(16,6) — NOT NULL
- fp_yy_efee_r — DECIMAL(9,6) — NOT NULL
- fp_ten_dd_efee_r — DECIMAL(9,6) — NOT NULL
- fp_kftc_deal_bas_r — DECIMAL(16,6) — NOT NULL
- fp_kftc_bkpr — DECIMAL(16,6) — NOT NULL
- fp_dp_protect_yn — VARCHAR(1) — NOT NULL
- fp_io_yn — VARCHAR(1) — NOT NULL
- fp_term_mon — INT
- fp_prod_type — VARCHAR(20) — NOT NULL
- fp_apy — DECIMAL(6,3)
FOREIGN_EXCHANGE_TBL
- fe_no — INT — NOT NULL
- fp_no — INT — NOT NULL
- c_no — INT — NOT NULL
- a_no — INT — NOT NULL
- fe_id — VARCHAR(20) — NOT NULL
- fe_cur_code — INT — NOT NULL
- fe_amt_fc — DECIMAL(18,2) — NOT NULL
- fe_amt_krw — DECIMAL(18,2) — NOT NULL
- fe_rate_applied — DECIMAL(16,6) — NOT NULL
- fe_fee — DECIMAL(18,2) — NOT NULL
- fe_status — VARCHAR(20) — NOT NULL
- fe_ordered_at — TIMESTAMP — NOT NULL
- fe_side — VARCHAR(20) — NOT NULL
- fe_settled_at — TIMESTAMP
- fe_memo — VARCHAR(200)
FOREIGN_HISTORY_TBL
- fh_no — INT — NOT NULL
- c_no — INT — NOT NULL
- a_no — INT — NOT NULL
- fh_event_type — VARCHAR(20) — NOT NULL
- fh_ex_id — VARCHAR(40)
- fh_fx_cur_code — VARCHAR(10)
- fh_amt_krw — DECIMAL(18,2) — NOT NULL
- fh_fx_amt_fc — DECIMAL(18,2)
- fh_fx_rate_applied — DECIMAL(16,6)
- fh_status — VARCHAR(20) — NOT NULL
- fh_ordered_at — TIMESTAMP — NOT NULL
- fh_completed_at — TIMESTAMP
- fh_cancelled_at — TIMESTAMP
- memo — VARCHAR(500)
GOLD_PRODUCT_TBL
- gp_no — INT — NOT NULL
- gp_id — VARCHAR(20) — NOT NULL
- gp_metal_code — VARCHAR(10) — NOT NULL
- gp_weight_g — DECIMAL(10,3) — NOT NULL
- gp_purity — DECIMAL(6,4)
- gp_name — VARCHAR(200) — NOT NULL
- gp_premium_per_g — DECIMAL(18,2)
- gp_active_yn — VARCHAR(1) — NOT NULL
- gp_created_at — TIMESTAMP — NOT NULL
GOLD_TBL
- g_no — INT — NOT NULL
- gp_no — INT — NOT NULL
- c_no — INT — NOT NULL
- g_id — VARCHAR(20) — NOT NULL
- g_quantity — DECIMAL(10, 3) — NOT NULL
- g_price_per_g — DECIMAL(18, 2) — NOT NULL
- g_total_price — DECIMAL(18, 2) — NOT NULL
- g_status — VARCHAR(20) — NOT NULL — '거래상태 (COMPLETE
- CANCELED — 등)''
- g_purchased_at — TIMESTAMP — NOT NULL
INSTALLMENT_PRODUCT_TBL
- ip_no — INT — NOT NULL
- ip_code — VARCHAR(20) — NOT NULL
- ip_name — VARCHAR(100) — NOT NULL
- ip_description — TEXT — NOT NULL
- ip_type — VARCHAR(20) — NOT NULL
- ip_min_months — INT — NOT NULL
- ip_max_months — INT — NOT NULL
- ip_min_monthly_amount — DECIMAL(18,2) — NOT NULL
- ip_max_monthly_amount — DECIMAL(18,2) — NOT NULL
- ip_early_termination_rate — DECIMAL(6,4)
- ip_interest_payment_type — VARCHAR(20) — NOT NULL
- ip_created_at — TIMESTAMP — NOT NULL
- ip_updated_at — TIMESTAMP
- ip_is_active — VARCHAR(1)
INSTALLMENT_TBL
- i_no — INT — NOT NULL
- ip_no — INT — NOT NULL
- c_no — INT — NOT NULL
- a_no — INT — NOT NULL
- i_id — VARCHAR(20) — NOT NULL
- i_account_no — VARCHAR(30) — NOT NULL
- i_join_date — TIMESTAMP — NOT NULL
- i_maturity_date — TIMESTAMP
- i_month — INT — NOT NULL
- i_monthly_amt — INT — NOT NULL
- i_currency — VARCHAR(3) — NOT NULL
- i_interest_rate — DACIMAL(6,4) — NOT NULL
- i_pay_day — INT — NOT NULL
- i_status — VARCHAR(20) — NOT NULL
- i_paid_installments — INT — NOT NULL
- i_principal_paid — INT — NOT NULL
- i_interest_accrued — INT — NOT NULL
- i_bonus_amt — DECIMAL(18,2)
- i_arrears_cnt — INT — NOT NULL
- i_arrears_amt — DECIMAL(18,2) — NOT NULL
- i_updated_at — TIMESTAMP
LOAN_APPLICATION_HISTORY_TBL
- lah_disb_no — INT — NOT NULL
- l_id — VARCHAR(50) — NOT NULL
- lpd_no — INT — NOT NULL
- a_no — INT — NOT NULL
- c_id — INT — NOT NULL
- lah_disb_date — TIMESTAMP
- lah_amount — DECIMAL(18,2) — NOT NULL
- lah_bank_code — VARCHAR(10)
- lah_receive_acc — VARCHAR(30)
- lah_memo — VARCHAR(200)
LOAN_APPLICATION_TBL
- la_no — INT — NOT NULL
- c_id — INT — NOT NULL
- lpd_no — INT — NOT NULL
- la_id — INT — NOT NULL
- la_appl_status — VARCHAR(20) — NOT NULL
- la_appl_amount — DECIMAL(18, 2) — NOT NULL
- la_desired_term — INT — NOT NULL
- la_purpose_code — VARCHAR(30) — 생활자금, 대출갚음, 월세
- la_risk_score — DECIMAL(5, 2)
- la_channel — VARCHAR(20) — NOT NULL
- la_submitted_at — TIMESTAMP
- la_decided_at — TIMESTAMP
- la_decision_reason — VARCHAR(200)
LOAN_DELINQUENCY_TBL
- ld_no — INT — NOT NULL
- l_no — INT — NOT NULL
- lpd_no — INT — NOT NULL
- a_no — INT — NOT NULL
- c_id2 — INT — NOT NULL
- ld_id — VARCHAR(20) — NOT NULL
- ld_schd_id — INT
- ld_calc_date — TIMESTAMP — NOT NULL
- ld_del_rate — DECIMAL(5,3) — NOT NULL
- ld_del_amount — DECIMAL(18,2) — NOT NULL
- ld_waived_yn — VARCHAR(1)
- ld_memo — VARCHAR(200)
LOAN_FINE_TBL
- lf_no — INT — NOT NULL
- l_no — INT — NOT NULL — UNIQUE
- lpd_no — INT — NOT NULL
- lf_id — INT — NOT NULL
- lf_days — INT — NOT NULL
- lf_start_date — TIMESTAMP
- lf_amount — DECIMAL(18, 2) — NOT NULL
- lf_last_calc — TIMESTAMP
LOAN_PAYMENT_TBL
- lp_no — INT — NOT NULL
- l_no — INT — NOT NULL — UNIQUE
- lpd_no — INT — NOT NULL
- a_no — INT — NOT NULL
- c_id — INT — NOT NULL
- lp_id — VARCHAR(20) — NOT NULL — UNIQUE
- lp_amount_received — DECIMAL(18, 2) — NOT NULL
- lp_principal_amt — DECIMAL(18, 2) — NOT NULL
- lp_interest_amt — DECIMAL(18, 2) — NOT NULL
- lp_penalty_amt — DECIMAL(18, 2) — NOT NULL
- lp_status — VARCHAR(20) — NOT NULL
- lp_installment_no — INT
- lp_payment_time — TIMESTAMP — NOT NULL
- lp_created_time — TIMESTAMP — NOT NULL — DEFAULT
- lp_updated_time — TIMESTAMP — NOT NULL — DEFAULT
LOAN_PRODUCT_TBL
- lpd_no — INT — NOT NULL
- lpd_code — VARCHAR(20) — NOT NULL
- lpd_name — VARCHAR(200) — NOT NULL
- lpd_type — VARCHAR(20) — NOT NULL
- lpd_rate_type — VARCHAR(10) — NOT NULL
- lpd_base_rate — VARCHAR(20)
- lpd_prime_rate — DECIMAL(5,3)
- lpd_max_month — INT — NOT NULL
- lpd_repay_method — VARCHAR(20) — NOT NULL
- lpd_grace_month — INT
- lpd_policy_code — VARCHAR(30)
- lpd_status — VARCHAR(1)
- lpd_description — VARCHAR(500)
LOAN_TBL
- l_no — INT — NOT NULL
- la_no — INT — NOT NULL
- lpd_no — INT — NOT NULL
- a_no — INT — NOT NULL
- c_id — INT — NOT NULL
- l_id — VARCHAR(20) — NOT NULL
- l_principal_amount — DECIMAL(18,2) — NOT NULL
- l_currency — VARCHAR(3) — NOT NULL
- l_rate_type — VARCHAR(10) — NOT NULL
- l_interest_rate — DECIMAL(5,3) — NOT NULL
- l_spread_rate — DECIMAL(5,3)
- l_repay_method — VARCHAR(20) — NOT NULL
- l_term_month — INT — NOT NULL
- l_grace_month — INT
- start_date — TIMESTAMP — NOT NULL
- l_maturity_date — TIMESTAMP — NOT NULL
- l_pay_day — INT — NOT NULL
- l_status — VARCHAR(20) — NOT NULL
- l_created_at — TIMESTAMP
- l_closed_at — TIMESTAMP
QNA_TBL
- q_no — INT — NOT NULL
- c_no — INT — NOT NULL
- q_id — VARCHAR(20) — NOT NULL
- q_title — VARCHAR(255) — NOT NULL
- q_content — TEXT — NOT NULL
- q_answer_content — TEXT
- q_status — VARCHAR(10) — NOT NULL
- q_created_at — TIMESTAMP — NOT NULL
- q_answer_created_at — TIMESTAMP
REFRESH_TOKEN
- rt_id — BIGINT — NOT NULL
- c_no — INT — NOT NULL
- rt_hash — VARCHAR(64) — NOT NULL
- device_id — VARCHAR(100)
- issued_at — TIMESTAMP — NOT NULL
- expires_at — TIMESTAMP — NOT NULL
- t_from — VARCHAR(64)
- t_next — VARCHAR(64)
- delete_at — TIMESTAMP
- delete_reason — VARCHAR(100)
- last_used_at — TIMESTAMP
- last_used_ip — VARCHAR(45)
- user_agent — VARCHAR(255)
TRANSFER_HISTORY_TBL
- th_transfer_no — INT — NOT NULL
- a_no — INT — NOT NULL
- th_transfer_id — VARCHAR(30)
- th_amount — INT — NOT NULL
- th_memo — VARCHAR(100)
- th_transfer_at — TIMESTAMP — NOT NULL
- th_other_bank — VARCHAR(100)
- th_other_account — VARCHAR(100)
- th_transfer_type — VARCHAR(30) — NOT NULL
- th_after_balance — INT — NOT NULL
- th_transction_type — VARCHAR(100)
- th_account_out — INT
- th_account_in — INT
TRANSFER_ORDER_TBL
- to_order_id — INT — NOT NULL
- a_no — INT — NOT NULL
- to_bank_code — VARCHAR(10) — NOT NULL
- to_dest_account_no — VARCHAR(30) — NOT NULL
- to_amount — DECIMAL(18,2) — NOT NULL
- to_schedule_type — VARCHAR(10) — NOT NULL
- to_schedule_expr — VARCHAR(100)
- to_start_at — TIMESTAMP
- to_end_at — TIMESTAMP
- to_status — VARCHAR(20) — NOT NULL
- to_memo — VARCHAR(200)
- to_created_at — TIMESTAMP
TRUST_ACCOUNT_TBL
- trust_acc_id — INT — NOT NULL
- customer_id — INT — NOT NULL
- product_id — INT — NOT NULL
- joined_amount — INT — NOT NULL
- joined_date — TIMESTAMP
- maturity_date — TIMESTAMP
- status — VARCHAR(20)
TRUST_PRODUCT_TBL
- product_id — NUMBER — NOT NULL
- product_code — VARCHAR(20) — NOT NULL
- product_name — VARCHAR(200) — NOT NULL
- bank_name — VARCHAR(100) — NOT NULL
- period_month — NUMBER — NOT NULL
- min_amount — NUMBER
- interest_rate — NUMBER(5,2) — NOT NULL
- risk_grade — VARCHAR(20)
- status — VARCHAR(20)
TRUST_TRANSACTION_TBL
- tx_id — INT — NOT NULL
- trust_acc_id — INT — NOT NULL
- tx_date — TIMESTAMP
- tx_type — VARCHAR(20) — NOT NULL
- amount — INT — NOT NULL
- note — VARCHAR(200)
UTILITY_BILL_TBL
- ub_no — INT — NOT NULL
- c_no — INT — NOT NULL
- a_no — INT — NOT NULL
- ub_id — VARCHAR(20) — NOT NULL
- ub_type — VARCHAR(50) — NOT NULL
- ub_customer_num — VARCHAR(50) — NOT NULL
- ub_auto_pay — VARCHAR(1) — NOT NULL
- ub_pay_day — INT
- ub_pay_time — VARCHAR(10)
- ub_next_amount — INT
- ub_regdate — TIMESTAMP