금리특약

테이블 (4)

고객 (USER)

  • 고객번호 (user_id) — INT — 기본 키 — NOT NULL
  • Field (login_id) — VARCHAR(50)
  • Field2 (password) — VARCHAR(20)
  • Field (name) — VARCHAR(20)
  • Field (phone_num) — VARCHAR(20)
  • Field (email) — VARCHAR(20)
  • Field3 (join_date) — TIMESTAMP
  • Field (created_at) — TIMESTAMP
  • Field (updated_dat) — TIMESTAMP
  • Field2 (deleted_at) — TIMESTAMP

대출 (LOAN)

  • id (loan_id) — INT — 기본 키 — NOT NULL
  • 고객번호 (user_id) — INT — 외래 키 → 고객.고객번호 — NOT NULL
  • Field (account) — INT
  • Field (balance) — INT
  • Field (execution_date) — DATE
  • Field2 (expiration_date) — DATE
  • Field3 (interst_type) — VARCHAR(20)
  • Field4 (interest_rate) — DOUBLE
  • Field5 (max_reduction_rate) — DOUBLE
  • Field (created_at) — TIMESTAMP
  • Field2 (updated_at) — TIMESTAMP
  • Field3 (deleted_at) — TIMESTAMP

월별 거래실적 (MONTHLY_TRANSACTION)

  • id (transaction_id) — 기본 키 — NOT NULL
  • 고객번호 (user_id) — INT — 외래 키 → 고객.고객번호 — NOT NULL
  • Field (transaction_year) — DATE
  • Field (transaction_month) — DATE
  • Field2 (card_payment) — INT
  • Field (salary_transfer) — INT
  • Field2 (installment_saving) — INT
  • Field3 (housing_sub) — INT
  • Field (utility_payment) — INT
  • Field (smart_banking) — INT
  • Field2 (isa) — CHAR
  • Field (created_at) — TIMESTAMP
  • Field2 (updated_at) — TIMESTAMP
  • Field (deleted_at) — TIMESTAMP

월별대출원리금 (MONTHLY_PAYMENT)

  • id (payment_id) — INT — 기본 키 — NOT NULL
  • id (loan_id) — INT — 외래 키 → 대출.id — NOT NULL
  • Field (payment_date) — DATE
  • Field (payment) — INT
  • Field (monthly_interest_rate) — DOUBLE
  • Field (created_at) — TIMESTAMP
  • Field2 (updated_at) — TIMESTAMP
  • Field (deleted_at) — TIMESTAMP
  • Field