database1
Tables (12)
Account
- account_number — Varchar(20) — Primary key — NOT NULL
- balance — Int(10)
Borrower
- customer_id — Varchar(3) — Foreign key → Customer.customer_id — NOT NULL
- loan_number — Varchar(20) — Foreign key → Loan.loan_number — NOT NULL
Branch
- branch_name — Varchar(100) — Primary key — NOT NULL
- branch_city — Varchar(100)
- assets — Int(10)
Customer
- customer_id — Varchar(3) — Primary key — NOT NULL
- customer_name — Varchar(100)
- customer_street — Varchar(100)
- customer_city — Varchar(100)
Employee
- employee_id — Varchar(4) — Primary key — NOT NULL
- employee_name — Varchar(100)
- telephone_number — Varchar(11)
- employee_length — Int(10)
- start_date — Date(8)
Employee_Dependent
- dependent_name — Varchar(100) — Primary key
- employee_id — Varchar(4) — Foreign key → Employee.employee_id — NOT NULL
Loan
- loan_number — Varchar(20) — Primary key — NOT NULL
- amount — Int(10)
Payment
- payment_number — Int(10) — Primary key — NOT NULL
- loan_number — Varchar(20) — Foreign key → Loan.loan_number — NOT NULL
- payment_amount — Int(10)
- payment_date — Date(8)
Untitled (Depositor)
- customer_id — Varchar(3) — Foreign key → Customer.customer_id — NOT NULL
- account_number — Varchar(20) — Foreign key → Account.account_number — NOT NULL
Untitled (Customer_Banker)
- customer_id — Varchar(3) — Foreign key → Customer.customer_id — NOT NULL
- employee_id — Varchar(4) — Foreign key → Employee.employee_id — NOT NULL
Untitled (Manager_Worker)
- employee_id (employee_worker) — Varchar(4) — Foreign key → Employee.employee_id — NOT NULL
- employee_id (employee_manager) — Varchar(4) — Foreign key → Employee.employee_id — NOT NULL
Untitled (Loan_Branch)
- loan_number — Varchar(20) — Foreign key → Loan.loan_number — NOT NULL
- branch_name — Varchar(100) — Foreign key → Branch.branch_name — NOT NULL