bank
Tables (3)
Account
- 계좌id (Account_id) — INT — Primary key — NOT NULL
- 고객번호 (Client_id) — INT — Foreign key → Client.고객번호 — NOT NULL
- 계좌번호 (Account_num) — VARCHAR(20)
- 잔고 (Balance) — INT
Client
- 고객번호 (Client_id) — INT — Primary key — NOT NULL
- 이름 (name) — VARCHAR(50)
- 연락처 (tel) — INT
Transaction
- 거래번호 (Transaction_id) — INT — Primary key — NOT NULL
- 계좌id (Account_id) — INT — Foreign key → Account.계좌id — NOT NULL
- 거래유형 (transtype) — ENUM
- 거래금액 (amount) — INT
- 거래일시 (trans_date) — DATETIME