bank
Tables (6)
account (5)
- account_number (Key) — Primary key — NOT NULL
- Branch_name (Foreign key) — Foreign key → branch.Branch_name — NOT NULL
- balance (Field2)
borrower (4)
- Id (Foreign key) — Foreign key → customer.Id — NOT NULL
- loan_number (Foreign key2) — Foreign key → loan.loan_number
branch (1)
- Branch_name (Key) — Primary key — NOT NULL
- branch_city (Field)
- asset (Field2)
customer (2)
- Id (Key) — Primary key — NOT NULL
- customer_name (Field)
- customer_street (Field2)
- customer_city (Field3)
depositor (6)
- account_number (Foreign key) — Foreign key → account.account_number — NOT NULL
- Id (Foreign key2) — Foreign key → customer.Id — NOT NULL
loan (3)
- loan_number (key) — Primary key
- Branch_name (Foreign key) — Foreign key → branch.Branch_name — NOT NULL
- amount (Field3)