bankhcon
Tables (3)
Account (계좌)
- ID (id) — INT — Primary key — NOT NULL
- userId (유저아이디) — INT — Foreign key → User.ID — NOT NULL
- money (잔액) — INT
User (사용자)
- ID (id) — INT — Primary key — NOT NULL
- email (이메일) — VARCHAR2(255)
- name (이름) — VARCHAR2(255)
- password (비밀번호) — VARCHAR2(255)
tradeHistory (거래내역)
- ID (거래내역id) — INT — Primary key — NOT NULL
- accountId (계좌Id) — INT — Foreign key → Account.ID — NOT NULL
- type (입출금) — VARCHAR2(10)
- tradeMoney (거래금액) — INT
- tradeDate (거래날짜) — DATETIME