loan_and_deposit
Tables (10)
collateral_master
- collateral_id — NUMBER — Primary key — NOT NULL
- appraisal_value — NUMBER(15,2) — NOT NULL
- appraisal_date — DATE
credit_loan_detail
- loan_id — NUMBER — Foreign key → loan_account.loan_id — NOT NULL
- credit_score_snapshot — NUMBER
- dsr_at_approval — NUMBER(5,2)
customer
- customer_id — NUMBER — Primary key — NOT NULL
- customer_name — VARCHAR2(100) — NOT NULL
deposit_account
- account_id — NUMBER — Primary key — NOT NULL
- customer_id — NUMBER — Foreign key → customer.customer_id — NOT NULL
- product_code — VARCHAR2(10) — Foreign key → product_master.product_code — NOT NULL
- open_date — DATE — NOT NULL
- balance — NUMBER(15,2) — NOT NULL
- account_status — VARCHAR2(10) — NOT NULL
- interest_rate — NUMBER(5,4) — NOT NULL
installment_saving_detail
- account_id — NUMBER — Foreign key → deposit_account.account_id — NOT NULL
- contract_amount — NUMBER(15,2)
- installment_round — NUMBER — NOT NULL
- free_deposit_yn — CHAR(1) — NOT NULL
loan_account
- loan_id — NUMBER — Primary key — NOT NULL
- customer_id — NUMBER — Foreign key → customer.customer_id — NOT NULL
- product_code — VARCHAR2(10) — Foreign key → product_master.product_code — NOT NULL
- principal_amount — NUMBER(15,2) — NOT NULL
- disbursement_date — DATE — NOT NULL
- maturity_date — DATE — NOT NULL
- repayment_method — VARCHAR2(10) — NOT NULL
- interest_rate — NUMBER(5,4) — NOT NULL
- loan_status — VARCHAR2(10) — NOT NULL
mortgage_loan_detail
- loan_id — NUMBER — Foreign key → loan_account.loan_id — NOT NULL
- collateral_id — NUMBER — Foreign key → collateral_master.collateral_id — NOT NULL
- appraisal_value — NUMBER(15,2)
- ltv_ratio — NUMBER(5,2)
product_master
- product_code — VARCHAR2(10) — Primary key — NOT NULL
- product_name — VARCHAR2(100) — NOT NULL
- product_type — VARCHAR2(10) — NOT NULL
repayment_schedule
- round_no — NUMBER — Primary key — NOT NULL
- loan_id — NUMBER — Foreign key → loan_account.loan_id — NOT NULL
- due_date — DATE
- principal_amount — NUMBER(15,2)
- interest_amount — NUMBER(15,2)
- paid_yn — CHAR(1) — NOT NULL
time_deposit_detail
- account_id — NUMBER — Foreign key → deposit_account.account_id — NOT NULL
- maturity_date — DATE — NOT NULL
- auto_renewal_yn — CHAR(1) — NOT NULL
- early_termination_rate — NUMBER(5,4)