ㅇㅇ
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)