bankERD

Tables (5)

BANK_CUSTOMERS

  • id — varchar(30)
  • pwd — varchar(50) — NOT NULL
  • name — varchar(30) — NOT NULL
  • phone — varchar(50)
  • register_num — varchar(50)

BANK_MANAGER

  • managerId — varchar(30)
  • managerPwd — varchar(50) — NOT NULL

BANK_P_PRODUCT

  • product_code — number
  • product_name — varchar(50) — NOT NULL
  • product_category — varchar(50) — NOT NULL

bank_account

  • account_number — NUMBER
  • account_pwd — NUMBER — NOT NULL
  • account_holder — varchar(30) — NOT NULL
  • account_nicname — varchar(30)
  • account_id — varchar(30)
  • balance — NUMBER — NOT NULL
  • account_date — DATE

bank_history

  • NO — number(5)
  • acc_no — NUMBER — NOT NULL
  • his_category — varchar(50) — NOT NULL
  • his_amount — NUMBER — NOT NULL
  • his_date — DATE
  • his_name — varchar(50)