실행계획분석

테이블 (3)

loan_contracts (대출계약)

  • contract_id (계약ID) — INT — 기본 키 — NOT NULL
  • amount (대출금) — BIGINT
  • status (상태) — ENUM('PENDING','ACTIVE','COMPLETED')
  • contract_date (계약일) — DATE
  • user_id (유저ID) — INT — 외래 키 → users.user_id — NOT NULL
  • product_id (상품ID) — INT — 외래 키 → loan_products.product_id — NOT NULL

loan_products (대출상품)

  • product_id (상품ID) — INT — 기본 키 — NOT NULL
  • product_name (상품명) — VARCHAR(100)
  • interest_rate (금리) — DECIMAL(5,2)
  • category (상품종류) — ENUM('CREDIT','MORTGAGE','CAR')

users (고객)

  • user_id (유저ID) — INT — 기본 키 — NOT NULL
  • name (이름) — VARCHAR(50)
  • credit_score (신용점수) — INT
  • created_at (가입일) — DATETIME