8퍼센트 ERD
테이블 (3)
ACCOUNT (계좌)
- accountNumber (PK) — INT — 기본 키 — NOT NULL
- userId (Pk) — VARCHAR(255) — 외래 키 → USER.id — NOT NULL
- password (Field) — VARCHAR(255)
- balance (Field2) — BIGINT
TRANSACTION (거래)
- id (Pk) — INT — 기본 키 — NOT NULL
- accountId (account FK) — INT — 외래 키 → ACCOUNT.accountNumber — NOT NULL
- transactionDate (Field) — BIGINT
- balance (Field2) — BIGINT
- transactionType (Field3) — TINYINT
- transactionAmount (Field4) — BIGINT
- briefs (Field5) — VARCHAR(255)
USER (유저)
- id (Pk) — VARCHAR(255) — 기본 키 — NOT NULL
- password (Field) — VARCHAR(255)
- salt (Field2) — VARCHAR(255)