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)