bank
Tables (3)
Account (계좌 테이블)
- Account Number — Num(10) — Primary key — NOT NULL
- User_id — Varchar(20) — Foreign key → Users.User_id — NOT NULL
- Account Password — int(4)
- Current Balance — int(20)
Transaction (거래 내역 테이블)
- Transaction_id — Num(20) — Primary key — NOT NULL
- Account Number — Num(10) — Foreign key → Account.Account Number — NOT NULL
- User_id — Varchar(20) — Foreign key → Account.User_id — NOT NULL
- Type — Varchar(10)
- Amount — Int(30)
- Target Account — Varchar(20)
- Created_at — date
Users (회원 테이블)
- User_id — Varchar(20) — Primary key — NOT NULL
- Password — Int(6)