db 쉅

테이블 (6)

account (계좌)

  • account_number (Key) — 기본 키 — NOT NULL
  • branch_name (Key2) — 외래 키 → branch.branch_name — NOT NULL
  • balance (Field)

borrower (대출자)

  • loan_number (Key1) — 외래 키 → loan.loan_number — NOT NULL
  • ID (Key2) — 외래 키 → customer.ID — NOT NULL

branch (지점)

  • branch_name (Key) — 기본 키 — NOT NULL
  • branch_city (Field)
  • assets (Field2)

customer (고객)

  • ID (Key) — 기본 키 — NOT NULL
  • customer_name (Field)
  • customer_street (Field2)
  • customer_city (Field3)

depositor (예금자)

  • account_number (Key) — 외래 키 → account.account_number — NOT NULL
  • ID (Key3) — 외래 키 → customer.ID — NOT NULL

loan (대출)

  • loan_number (Key) — 기본 키 — NOT NULL
  • branch_name (Key2) — 외래 키 → branch.branch_name — NOT NULL
  • amount (Field)