DB
Tables (6)
Account (Untitled)
- account_number (Key) — varchar — Primary key — NOT NULL
- branch_name (Field3) — varchar — NOT NULL
- open_date (Field2) — date
- balance (Field) — decimal(15,2)
Borrower (Untitled4)
- customer_id (Key) — int — Primary key — NOT NULL
- since_date (Field2) — date
Branch (Untitled2)
- branch_name (Key) — varchar — Primary key — NOT NULL
- branch_city (Field) — varchar
- assets (Field2) — decimal(15,2)
Customer (Untitled5)
- customer_id (Key) — varchar — Primary key — NOT NULL
- customer_name (Field) — varchar
- address (Field2) — varchar
- phone (Field3) — varchar
Depositor (Untitled6)
- customer_id (Key) — int — Primary key — NOT NULL
- account_number (Key2) — int — Primary key — NOT NULL
- role (Field2) — varchar
- since_date (Field3) — date
Loan (Untitled3)
- loan_number (Key) — int — Primary key — NOT NULL
- amount (Field2) — decimal(15,2)
- start_date (Field3) — date