bank
Tables (4)
bankBranch (branch_t)
- branchname (manyname) — varchar2(30) — Primary key — NOT NULL
- city (build) — varchar2(30) — NOT NULL
- money (mon) — varchar2(30) — NOT NULL
- english branch (en) — varchar2(30) — NOT NULL
- setup branch (set) — varchar2(30) — NOT NULL
- phone (ph) — varchar2(30) — NOT NULL
customer (cus_t)
- cusnumber (Key) — number(30) — Primary key — NOT NULL
- cusname (name) — varchar2(30) — NOT NULL
- cusadd (add) — varchar2(30) — NOT NULL
- cusbirth (birth) — varchar2(30) — NOT NULL
saving (saving_t)
- saving number (Key) — number(30) — Primary key — NOT NULL
- count nb (numb) — number(30) — Foreign key → savingAccout.count nb — NOT NULL
- cusnumber (Key2) — number(30) — Foreign key → customer.cusnumber — NOT NULL
savingAccout (save_t)
- count nb (numb) — number(30) — Primary key — NOT NULL
- in money (input) — varchar2(30) — NOT NULL
- out money (output) — varchar2(30) — NOT NULL
- branchname (manyname) — varchar2(30) — Foreign key → bankBranch.branchname — NOT NULL