ㅇㅇ

Tables (6)

Account (Untitled4)

  • PK (account_number) — Primary key — NOT NULL
  • FK (Branch) — Primary key — NOT NULL
  • Field (balance)
  • PK (branch_name) — Foreign key → Branch.PK — NOT NULL

Borrower (Untitled5)

  • PK ((ID, loan_number)) — Primary key — NOT NULL
  • FK (ID → Customer(ID), loan_number → Loan(loan_number)) — Primary key — NOT NULL
  • PK (ID2) — Foreign key → Customer.PK — NOT NULL
  • PK:\ (loan_number2) — Foreign key → Loan.PK:\ — NOT NULL
  • FK (Branch) — Foreign key → Loan.FK — NOT NULL

Branch (Untitled)

  • PK (branch_name) — Primary key — NOT NULL
  • Field (branch_city, assets)
  • PK:\ (loan_number) — Foreign key → Loan.PK:\ — NOT NULL
  • FK (Branch) — Foreign key → Loan.FK — NOT NULL

Customer (Untitled2)

  • PK (ID) — Primary key — NOT NULL
  • Field (customer_name)
  • Field (customer_street)
  • Field2 (customer_city)

Depositor (Untitled6)

  • PK ((ID, account_number)) — Primary key — NOT NULL
  • FK (Key2) — Primary key — NOT NULL
  • PK (ID2) — Foreign key → Customer.PK — NOT NULL
  • PK (account_number2) — Foreign key → Account.PK — NOT NULL
  • FK (Branch) — Foreign key → Account.FK — NOT NULL

Loan (Untitled3)

  • PK:\ (loan_number) — Primary key — NOT NULL
  • FK (Branch) — Primary key — NOT NULL
  • Field (amount)