Account
Tables (3)
account
- id — int — Primary key — NOT NULL
- 계좌번호 (number) — varchar
- 계좌상태 (status) — varchar
- 잔액 (balance) — long
- id_user — int — Foreign key → accountuser.id — NOT NULL
accountuser
- id — int — Primary key — NOT NULL
- 이름 (name) — varchar
transaction
- id — int — Primary key — NOT NULL
- 거래타입 (type_transaction) — varchar
- 거래결과타입 (type_result) — varchar
- 금액 (amount) — int
- 거래후잔액 (balance_snapshot) — int
- 거래ID (transaction_id) — varchar
- id_account — int — Foreign key → account.id — NOT NULL