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