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