Shinhan DS

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 — NOT NULL
  • product_code — VARCHAR2(10) — 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 — NOT NULL
  • product_code — VARCHAR2(10) — 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 — 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)