ㅅㄷㄴㅅ
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