ㅇㄴㅁ
Tables (3)
Account
- id — BIGINT
- member_id — BIGINT — NOT NULL
- account_number — VARCHAR(20) — NOT NULL
- balance — DECIMAL(15,2)
Member
- id — BIGINT
- username — VARCHAR(20) — NOT NULL
- password — VARCHAR(50) — NOT NULL
- name — VARCHAR(20) — NOT NULL
Transaction
- id — BIGINT
- from_account_id — BIGINT
- to_account_id — BIGINT
- amount — DECIMAL(15,2) — NOT NULL
- type — ENUM('입금', '출금', '송금') — NOT NULL
- timestamp — DATETIME