database
Tables (6)
Account (Untitled2)
- PK (account_number) — Primary key — NOT NULL
- FK (Branch) — Primary key — NOT NULL
- Field (balance)
- PK (branch_name)
- PK (branch_name2) — Foreign key → branch.PK — NOT NULL
Borrower (Untitled3)
- PK ((ID,loan_number) — Primary key — NOT NULL
- FK (ID > Customer(ID),loan_number>Loan(loan_number)) — Primary key — NOT NULL
- PK:\ (loan_number3) — Foreign key → Loan.PK:\ — NOT NULL
- FK (Branch2) — Foreign key → Loan.FK — NOT NULL
Customer (Untitled6)
- PK (ID) — Primary key — NOT NULL
- PK ((ID,loan_number) — Foreign key → Borrower.PK — NOT NULL
- FK (ID > Customer(ID),loan_number>Loan(loan_number)) — Foreign key → Borrower.FK — NOT NULL
Depositor (Untitled5)
- PK (ID, account_number) — Primary key — NOT NULL
- FK (Key2) — Primary key — NOT NULL
- PK (account_number2) — Foreign key → Account.PK — NOT NULL
- FK (Branch) — Foreign key → Account.FK — NOT NULL
- PK (ID2) — Foreign key → Customer.PK — NOT NULL
Loan (Untitled4)
- PK:\ (loan_number) — Primary key — NOT NULL
- FK (Branch) — Primary key — NOT NULL
- Field (amount)
- PK (branch_name) — Foreign key → branch.PK — NOT NULL
branch (Untitled)
- PK (branch_name) — Primary key — NOT NULL
- Field (branch_city,assets)
- PK (loan_number)
- FK (Branch)