ㅅㄷㄴㅅ

Tables (33)

business_calendar

  • cal_id — BIGSERIAL
  • cal_date — VARCHAR(8) — NOT NULL
  • business_day_yn — CHAR(1) — NOT NULL
  • holiday_type_cd — VARCHAR(50)
  • holiday_name — VARCHAR(100)
  • base_country_cd — VARCHAR(10)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

collateral

  • col_id — BIGSERIAL
  • appl_id — BIGINT — Foreign key → loan_application.appl_id — NOT NULL
  • col_type_cd — VARCHAR(50) — NOT NULL
  • col_status_cd — VARCHAR(50) — NOT NULL
  • col_no — VARCHAR(30) — NOT NULL
  • col_name — VARCHAR(200)
  • col_address — VARCHAR(500)
  • col_registry_no — VARCHAR(100)
  • declared_value — BIGINT
  • currency_cd — VARCHAR(10) — NOT NULL
  • ownership_type_cd — VARCHAR(50)
  • senior_lien_yn — CHAR(1) — NOT NULL
  • senior_lien_amount — BIGINT
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

collateral_evaluation

  • ceval_col_id — BIGSERIAL
  • col_id — BIGINT — Foreign key → collateral.col_id — NOT NULL
  • eval_method_cd — VARCHAR(50) — NOT NULL
  • eval_agency_cd — VARCHAR(50)
  • appraised_value — BIGINT — NOT NULL
  • applied_value — BIGINT — NOT NULL
  • eval_status_cd — VARCHAR(50) — NOT NULL
  • eval_report_url — VARCHAR(500)
  • eval_report_hash — VARCHAR(128)
  • evaluated_at — TIMESTAMPTZ
  • applied_start_date — VARCHAR(8)
  • applied_end_date — VARCHAR(8)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

credit_consent

  • csnt_id — BIGSERIAL
  • appl_id — BIGINT — Foreign key → loan_application.appl_id — NOT NULL
  • customer_id — BIGINT — NOT NULL
  • consent_type_cd — VARCHAR(50) — NOT NULL
  • consent_scope_cd — VARCHAR(50) — NOT NULL
  • consent_target_cd — VARCHAR(50) — NOT NULL
  • consent_yn — CHAR(1) — NOT NULL
  • consented_at — TIMESTAMPTZ — NOT NULL
  • consent_method_cd — VARCHAR(50)
  • consent_token — VARCHAR(100)
  • signed_doc_url — VARCHAR(500)
  • signed_doc_hash — VARCHAR(128)
  • client_ip — VARCHAR(64)
  • device — VARCHAR(200)
  • retention_until — VARCHAR(8)
  • withdrawn_yn — CHAR(1) — NOT NULL
  • withdrawn_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

credit_evaluation

  • ceval_id — BIGSERIAL
  • appl_id — BIGINT — Foreign key → loan_application.appl_id — NOT NULL
  • customer_id — BIGINT — NOT NULL
  • ceval_engine — VARCHAR(50) — NOT NULL
  • ceval_engine_version — VARCHAR(50)
  • ceval_grade — VARCHAR(10)
  • ceval_score — INT
  • pd_bps — INT
  • ceval_decision_cd — VARCHAR(50) — NOT NULL
  • eval_limit_amount — BIGINT
  • eval_rate_bps — INT
  • ceval_status_cd — VARCHAR(50) — NOT NULL
  • ceval_factors — JSONB
  • evaluated_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

credit_info_report

  • crpt_id — BIGSERIAL
  • cntr_id — BIGINT — Foreign key → loan_contract.cntr_id — NOT NULL
  • customer_id — BIGINT — NOT NULL
  • crpt_type_cd — VARCHAR(50) — NOT NULL
  • crpt_agency_cd — VARCHAR(50) — NOT NULL
  • crpt_status_cd — VARCHAR(50) — NOT NULL
  • report_target_cd — VARCHAR(50) — NOT NULL
  • report_reason_cd — VARCHAR(50)
  • report_payload — JSONB
  • external_tx_no — VARCHAR(100)
  • reported_at — TIMESTAMPTZ
  • ack_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

delinquency

  • dlq_id — BIGSERIAL
  • cntr_id — BIGINT — Foreign key → loan_contract.cntr_id — NOT NULL
  • dlq_status_cd — VARCHAR(50) — NOT NULL
  • dlq_start_date — VARCHAR(8) — NOT NULL
  • dlq_end_date — VARCHAR(8)
  • dlq_days — INT — NOT NULL
  • dlq_principal_amt — BIGINT — NOT NULL
  • dlq_interest_amt — BIGINT — NOT NULL
  • dlq_total_amt — BIGINT — NOT NULL
  • overdue_rate_bps — INT — NOT NULL
  • dlq_stage_cd — VARCHAR(50) — NOT NULL
  • resolved_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

delinquency_daily_snapshot

  • dlqs_id — BIGSERIAL
  • dlq_id — BIGINT — Foreign key → delinquency.dlq_id — NOT NULL
  • cntr_id — BIGINT — Foreign key → loan_contract.cntr_id — NOT NULL
  • snapshot_date — VARCHAR(8) — NOT NULL
  • dlq_days — INT — NOT NULL
  • dlq_principal_amt — BIGINT — NOT NULL
  • dlq_interest_amt — BIGINT — NOT NULL
  • dlq_total_amt — BIGINT — NOT NULL
  • overdue_rate_bps — INT — NOT NULL
  • dlq_stage_cd — VARCHAR(50) — NOT NULL
  • snapshotted_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL

dsr_calculation

  • dsr_id — BIGSERIAL
  • appl_id — BIGINT — Foreign key → loan_application.appl_id — NOT NULL
  • customer_id — BIGINT — NOT NULL
  • annual_income_amt — BIGINT — NOT NULL
  • existing_principal_total — BIGINT — NOT NULL
  • existing_annual_repay_amt — BIGINT — NOT NULL
  • new_annual_repay_amt — BIGINT — NOT NULL
  • total_annual_repay_amt — BIGINT — NOT NULL
  • dsr_ratio_bps — INT — NOT NULL
  • dsr_limit_bps — INT — NOT NULL
  • dsr_status_cd — VARCHAR(50) — NOT NULL
  • dsr_reg_type_cd — VARCHAR(50)
  • calculated_at — TIMESTAMPTZ — NOT NULL
  • calc_engine_version — VARCHAR(50)
  • dsr_detail — JSONB
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

guarantee_insurance

  • gins_id — BIGSERIAL
  • cntr_id — BIGINT — Foreign key → loan_contract.cntr_id — NOT NULL
  • gins_agency_cd — VARCHAR(50) — NOT NULL
  • gins_policy_no — VARCHAR(50) — NOT NULL
  • guarantee_amount — BIGINT — NOT NULL
  • guarantee_ratio_bps — INT — NOT NULL
  • premium_amount — BIGINT — NOT NULL
  • gins_status_cd — VARCHAR(50) — NOT NULL
  • gins_start_date — VARCHAR(8) — NOT NULL
  • gins_end_date — VARCHAR(8) — NOT NULL
  • gins_doc_url — VARCHAR(500)
  • gins_doc_hash — VARCHAR(128)
  • issued_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

guarantor_agreement

  • gagr_id — BIGSERIAL
  • appl_id — BIGINT — Foreign key → loan_application.appl_id — NOT NULL
  • gmst_id — BIGINT — Foreign key → guarantor_master.gmst_id — NOT NULL
  • gagr_type_cd — VARCHAR(50) — NOT NULL
  • guarantee_amount — BIGINT — NOT NULL
  • guarantee_ratio_bps — INT
  • gagr_status_cd — VARCHAR(50) — NOT NULL
  • consented_at — TIMESTAMPTZ
  • signed_doc_url — VARCHAR(500)
  • signed_doc_hash — VARCHAR(128)
  • client_ip — VARCHAR(64)
  • device — VARCHAR(200)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

guarantor_master

  • gmst_id — BIGSERIAL
  • guarantor_name_enc — BYTEA — NOT NULL
  • guarantor_name_masked — VARCHAR(50)
  • guarantor_ci_hash — VARCHAR(128) — NOT NULL
  • relation_type_cd — VARCHAR(50)
  • mobile_no_enc — BYTEA
  • mobile_no_masked — VARCHAR(20)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

interest_accrual

  • iacc_id — BIGSERIAL
  • cntr_id — BIGINT — Foreign key → loan_contract.cntr_id — NOT NULL
  • accrual_date — VARCHAR(8) — NOT NULL
  • principal_balance — BIGINT — NOT NULL
  • applied_rate_bps — INT — NOT NULL
  • day_count_basis_cd — VARCHAR(50) — NOT NULL
  • daily_interest_amt — BIGINT — NOT NULL
  • cumulative_interest_amt — BIGINT — NOT NULL
  • iacc_status_cd — VARCHAR(50) — NOT NULL
  • accrued_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL

loan_application

  • appl_id — BIGSERIAL
  • appl_no — VARCHAR(30) — NOT NULL
  • customer_id — BIGINT — NOT NULL
  • prod_id — BIGINT — Foreign key → loan_product.prod_id — NOT NULL
  • channel_cd — VARCHAR(50) — NOT NULL
  • requested_amount — BIGINT — NOT NULL
  • requested_period_mo — INT — NOT NULL
  • loan_purpose_cd — VARCHAR(50)
  • repayment_method_cd — VARCHAR(50) — NOT NULL
  • estimated_income_amt — BIGINT
  • employment_type_cd — VARCHAR(50)
  • appl_status_cd — VARCHAR(50) — NOT NULL
  • applied_at — TIMESTAMPTZ — NOT NULL
  • client_ip — VARCHAR(64)
  • device — VARCHAR(200)
  • idempotency_key — VARCHAR(100)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

loan_certificate

  • cert_id — BIGSERIAL
  • cntr_id — BIGINT — Foreign key → loan_contract.cntr_id — NOT NULL
  • customer_id — BIGINT — NOT NULL
  • cert_type_cd — VARCHAR(50) — NOT NULL
  • cert_no — VARCHAR(50) — NOT NULL
  • cert_status_cd — VARCHAR(50) — NOT NULL
  • cert_purpose_cd — VARCHAR(50)
  • cert_doc_url — VARCHAR(500)
  • cert_doc_hash — VARCHAR(128)
  • issue_channel_cd — VARCHAR(50)
  • issued_at — TIMESTAMPTZ
  • retention_until — VARCHAR(8)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

loan_closure

  • clos_id — BIGSERIAL
  • cntr_id — BIGINT — Foreign key → loan_contract.cntr_id — NOT NULL
  • clos_type_cd — VARCHAR(50) — NOT NULL
  • clos_reason_cd — VARCHAR(50)
  • clos_status_cd — VARCHAR(50) — NOT NULL
  • final_principal_amt — BIGINT — NOT NULL
  • final_interest_amt — BIGINT — NOT NULL
  • final_fee_amt — BIGINT — NOT NULL
  • prepayment_fee_amt — BIGINT — NOT NULL
  • total_settled_amt — BIGINT — NOT NULL
  • clos_date — VARCHAR(8) — NOT NULL
  • closed_at — TIMESTAMPTZ
  • clos_doc_url — VARCHAR(500)
  • clos_doc_hash — VARCHAR(128)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

loan_contract

  • cntr_id — BIGSERIAL
  • cntr_no — VARCHAR(30) — NOT NULL
  • contract_id — BIGINT
  • appl_id — BIGINT — Foreign key → loan_application.appl_id — NOT NULL
  • rev_id — BIGINT — Foreign key → loan_review.rev_id
  • customer_id — BIGINT — NOT NULL
  • prod_id — BIGINT — Foreign key → loan_product.prod_id — NOT NULL
  • contracted_amount — BIGINT — NOT NULL
  • currency_cd — VARCHAR(10) — NOT NULL
  • contracted_period_mo — INT — NOT NULL
  • total_rate_bps — INT — NOT NULL
  • base_rate_bps — INT — NOT NULL
  • spread_bps — INT — NOT NULL
  • preferential_rate_bps — INT — NOT NULL
  • rate_type_cd — VARCHAR(50) — NOT NULL
  • repayment_method_cd — VARCHAR(50) — NOT NULL
  • cntr_status_cd — VARCHAR(50) — NOT NULL
  • cntr_start_date — VARCHAR(8) — NOT NULL
  • cntr_end_date — VARCHAR(8) — NOT NULL
  • cntr_doc_url — VARCHAR(500)
  • cntr_doc_hash — VARCHAR(128)
  • signed_at — TIMESTAMPTZ
  • client_ip — VARCHAR(64)
  • device — VARCHAR(200)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

loan_document

  • doc_id — BIGSERIAL
  • appl_id — BIGINT — Foreign key → loan_application.appl_id — NOT NULL
  • doc_type_cd — VARCHAR(50) — NOT NULL
  • doc_status_cd — VARCHAR(50) — NOT NULL
  • doc_source_cd — VARCHAR(50)
  • doc_name — VARCHAR(200)
  • doc_url — VARCHAR(500)
  • doc_hash — VARCHAR(128)
  • mime_type — VARCHAR(100)
  • file_size_bytes — BIGINT
  • submitted_at — TIMESTAMPTZ
  • verified_at — TIMESTAMPTZ
  • verify_result_cd — VARCHAR(50)
  • retention_until — VARCHAR(8)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

loan_document_ocr

  • ocr_id — BIGSERIAL
  • doc_id — BIGINT — Foreign key → loan_document.doc_id — NOT NULL
  • ocr_engine — VARCHAR(50) — NOT NULL
  • ocr_engine_version — VARCHAR(50)
  • ocr_status_cd — VARCHAR(50) — NOT NULL
  • ocr_confidence — DECIMAL(5,4)
  • extracted_fields — JSONB
  • extracted_text — TEXT
  • ocr_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

loan_execution

  • exec_id — BIGSERIAL
  • cntr_id — BIGINT — Foreign key → loan_contract.cntr_id — NOT NULL
  • transaction_id — BIGINT
  • executed_amount — BIGINT — NOT NULL
  • currency_cd — VARCHAR(10) — NOT NULL
  • exec_status_cd — VARCHAR(50) — NOT NULL
  • disbursement_bank_cd — VARCHAR(10)
  • disbursement_account_enc — BYTEA
  • disbursement_account_masked — VARCHAR(50)
  • executed_at — TIMESTAMPTZ
  • value_date — VARCHAR(8)
  • fee_amount — BIGINT — NOT NULL
  • idempotency_key — VARCHAR(100)
  • journal_entry_no — VARCHAR(50)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

loan_identity_verification

  • idv_id — BIGSERIAL
  • appl_id — BIGINT — Foreign key → loan_application.appl_id — NOT NULL
  • customer_id — BIGINT — NOT NULL
  • idv_method_cd — VARCHAR(50) — NOT NULL
  • idv_status_cd — VARCHAR(50) — NOT NULL
  • idv_result_cd — VARCHAR(50)
  • idv_target_cd — VARCHAR(50) — NOT NULL
  • ci_hash — VARCHAR(128)
  • di_hash — VARCHAR(128)
  • mobile_no_enc — BYTEA
  • mobile_no_masked — VARCHAR(20)
  • verified_at — TIMESTAMPTZ
  • client_ip — VARCHAR(64)
  • device — VARCHAR(200)
  • external_tx_no — VARCHAR(100)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

loan_prescreening

  • presc_id — BIGSERIAL
  • appl_id — BIGINT — Foreign key → loan_application.appl_id — NOT NULL
  • presc_result_cd — VARCHAR(50) — NOT NULL
  • estimated_limit_amt — BIGINT
  • estimated_rate_bps — INT
  • estimated_grade — VARCHAR(10)
  • estimated_score — INT
  • reject_reason_cd — VARCHAR(50)
  • presc_remark — VARCHAR(500)
  • prescreened_at — TIMESTAMPTZ — NOT NULL
  • presc_engine_version — VARCHAR(50)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

loan_product

  • prod_id — BIGSERIAL
  • product_id — BIGINT
  • prod_cd — VARCHAR(30) — NOT NULL
  • prod_name — VARCHAR(200) — NOT NULL
  • loan_type_cd — VARCHAR(50) — NOT NULL
  • target_customer_cd — VARCHAR(50)
  • repayment_method_cd — VARCHAR(50) — NOT NULL
  • rate_type_cd — VARCHAR(50) — NOT NULL
  • base_rate_bps — INT — NOT NULL
  • min_rate_bps — INT
  • max_rate_bps — INT
  • min_amount — BIGINT — NOT NULL
  • max_amount — BIGINT — NOT NULL
  • min_period_mo — INT — NOT NULL
  • max_period_mo — INT — NOT NULL
  • collateral_required_yn — CHAR(1) — NOT NULL
  • guarantor_required_yn — CHAR(1) — NOT NULL
  • sale_start_date — VARCHAR(8)
  • sale_end_date — VARCHAR(8)
  • prod_status_cd — VARCHAR(50) — NOT NULL
  • prod_terms_url — VARCHAR(500)
  • prod_terms_hash — VARCHAR(128)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

loan_review

  • rev_id — BIGSERIAL
  • appl_id — BIGINT — Foreign key → loan_application.appl_id — NOT NULL
  • rev_type_cd — VARCHAR(50) — NOT NULL
  • rev_status_cd — VARCHAR(50) — NOT NULL
  • rev_decision_cd — VARCHAR(50)
  • approved_amount — BIGINT
  • approved_rate_bps — INT
  • approved_period_mo — INT
  • reject_reason_cd — VARCHAR(50)
  • rev_remark — VARCHAR(500)
  • reviewer_id — BIGINT
  • reviewed_at — TIMESTAMPTZ
  • approved_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

ltv_calculation

  • ltv_id — BIGSERIAL
  • appl_id — BIGINT — Foreign key → loan_application.appl_id — NOT NULL
  • col_id — BIGINT — Foreign key → collateral.col_id — NOT NULL
  • applied_col_value — BIGINT — NOT NULL
  • senior_lien_amount — BIGINT
  • requested_amount — BIGINT — NOT NULL
  • ltv_ratio_bps — INT — NOT NULL
  • ltv_limit_bps — INT — NOT NULL
  • max_loan_amount — BIGINT — NOT NULL
  • ltv_status_cd — VARCHAR(50) — NOT NULL
  • calculated_at — TIMESTAMPTZ — NOT NULL
  • calc_engine_version — VARCHAR(50)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

maturity

  • mat_id — BIGSERIAL
  • cntr_id — BIGINT — Foreign key → loan_contract.cntr_id — NOT NULL
  • original_maturity_date — VARCHAR(8) — NOT NULL
  • current_maturity_date — VARCHAR(8) — NOT NULL
  • mat_status_cd — VARCHAR(50) — NOT NULL
  • extension_type_cd — VARCHAR(50)
  • extension_count — INT — NOT NULL
  • last_extended_date — VARCHAR(8)
  • extended_period_mo — INT
  • notice_status_cd — VARCHAR(50)
  • last_notice_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

preferential_rate_policy

  • policy_id — BIGSERIAL
  • prod_id — BIGINT — Foreign key → loan_product.prod_id — NOT NULL
  • policy_name — VARCHAR(200) — NOT NULL
  • condition_cd — VARCHAR(50) — NOT NULL
  • preferential_rate_bps — INT — NOT NULL
  • max_stack_bps — INT
  • active_yn — CHAR(1) — NOT NULL
  • effective_start_date — VARCHAR(8)
  • effective_end_date — VARCHAR(8)
  • policy_remark — VARCHAR(500)
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

rate_change_history

  • rchg_id — BIGSERIAL
  • cntr_id — BIGINT — Foreign key → loan_contract.cntr_id — NOT NULL
  • rate_change_reason_cd — VARCHAR(50) — NOT NULL
  • previous_rate_bps — INT — NOT NULL
  • new_rate_bps — INT — NOT NULL
  • base_rate_bps — INT — NOT NULL
  • spread_bps — INT — NOT NULL
  • preferential_rate_bps — INT — NOT NULL
  • applied_start_date — VARCHAR(8) — NOT NULL
  • applied_end_date — VARCHAR(8)
  • changed_at — TIMESTAMPTZ — NOT NULL
  • changed_by — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL

repayment_account

  • racct_id — BIGSERIAL
  • cntr_id — BIGINT — Foreign key → loan_contract.cntr_id — NOT NULL
  • account_id — BIGINT
  • account_no_masked — VARCHAR(50)
  • account_no_enc — BYTEA
  • bank_cd — VARCHAR(10) — NOT NULL
  • holder_name_masked — VARCHAR(50)
  • racct_status_cd — VARCHAR(50) — NOT NULL
  • auto_debit_yn — CHAR(1) — NOT NULL
  • debit_day — INT
  • verified_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

repayment_schedule

  • rsch_id — BIGSERIAL
  • cntr_id — BIGINT — Foreign key → loan_contract.cntr_id — NOT NULL
  • installment_no — INT — NOT NULL
  • due_date — VARCHAR(8) — NOT NULL
  • scheduled_principal — BIGINT — NOT NULL
  • scheduled_interest — BIGINT — NOT NULL
  • scheduled_total — BIGINT — NOT NULL
  • remaining_balance — BIGINT — NOT NULL
  • applied_rate_bps — INT — NOT NULL
  • rsch_status_cd — VARCHAR(50) — NOT NULL
  • rsch_version_cd — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

repayment_transaction

  • rtx_id — BIGSERIAL
  • cntr_id — BIGINT — Foreign key → loan_contract.cntr_id — NOT NULL
  • rsch_id — BIGINT — Foreign key → repayment_schedule.rsch_id
  • transaction_id — BIGINT
  • rtx_type_cd — VARCHAR(50) — NOT NULL
  • total_amount — BIGINT — NOT NULL
  • principal_amount — BIGINT — NOT NULL
  • interest_amount — BIGINT — NOT NULL
  • overdue_interest_amount — BIGINT — NOT NULL
  • fee_amount — BIGINT — NOT NULL
  • currency_cd — VARCHAR(10) — NOT NULL
  • channel_cd — VARCHAR(50) — NOT NULL
  • rtx_status_cd — VARCHAR(50) — NOT NULL
  • paid_at — TIMESTAMPTZ
  • value_date — VARCHAR(8)
  • balance_after — BIGINT
  • idempotency_key — VARCHAR(100)
  • reversal_yn — CHAR(1) — NOT NULL
  • reversal_target_rtx_id — BIGINT — Foreign key → repayment_transaction.rtx_id
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • updated_by — BIGINT — NOT NULL
  • deleted_at — TIMESTAMPTZ
  • deleted_by — BIGINT
  • version — INT — NOT NULL

review_check_log

  • rchk_id — BIGSERIAL
  • rev_id — BIGINT — Foreign key → loan_review.rev_id — NOT NULL
  • check_item_cd — VARCHAR(50) — NOT NULL
  • check_result_cd — VARCHAR(50) — NOT NULL
  • check_remark — VARCHAR(500)
  • checker_id — BIGINT
  • checked_at — TIMESTAMPTZ — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL

status_history

  • sthist_id — BIGSERIAL
  • target_domain_cd — VARCHAR(30) — NOT NULL
  • target_table_cd — VARCHAR(50) — NOT NULL
  • target_id — BIGINT — NOT NULL
  • before_status_cd — VARCHAR(50)
  • after_status_cd — VARCHAR(50) — NOT NULL
  • change_reason_cd — VARCHAR(50)
  • change_remark — VARCHAR(500)
  • changed_at — TIMESTAMPTZ — NOT NULL
  • changed_by — BIGINT — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • created_by — BIGINT — NOT NULL