금리특약
테이블 (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