hw

Tables (7)

ACCOUNT

  • Acct_no — VARCHAR(20)
  • Balance — DECIMAL(15, 2) — NOT NULL
  • Type — VARCHAR(50)
  • Branch_no — VARCHAR(20)

ACCOUNT_CUSTOMER

  • Acct_no — VARCHAR(20)
  • Ssn — VARCHAR(20)

BANK

  • Code — VARCHAR(20)
  • Name — VARCHAR(255) — NOT NULL
  • Addr — VARCHAR(255)

BANK_BRANCH

  • Branch_no — VARCHAR(20)
  • Addr — VARCHAR(255)
  • Bank_code — VARCHAR(20)

CUSTOMER

  • Ssn — VARCHAR(20)
  • Name — VARCHAR(255) — NOT NULL
  • Phone — VARCHAR(50)
  • Addr — VARCHAR(255)

LOAN

  • Loan_no — VARCHAR(20)
  • Amount — DECIMAL(15, 2) — NOT NULL
  • Type — VARCHAR(50)
  • Branch_no — VARCHAR(20)

LOAN_CUSTOMER

  • Loan_no — VARCHAR(20)
  • Ssn — VARCHAR(20)