AccountERD
테이블 (3)
거래 (transaction)
- id (Key) — big int — 기본 키 — NOT NULL
- accountId (Key2) — big int — 외래 키 → 계좌.id — NOT NULL
- transactionType (Field) — varchar(20)
- transactionResultType (Field2) — varchar(2)
- amount (Field3) — big int
- balanceSnapshot (Field4) — big int
- transactionId (Field5) — varchar(50)
- transactedAt (Field6) — datetime
- createdAt (Field7) — datetime
- updatedAt (Field8) — datetime
계좌 (account)
- id (Key) — big int — 기본 키 — NOT NULL
- accountUserId (Key2) — big int — 외래 키 → 유저.id — NOT NULL
- accountNumber (Field) — varchar(10)
- accountStatus (Field2) — varchar(20)
- balance (Field3) — big int
- registeredAt (Field4) — datetime
- unRegisteredAt (Field5) — datetime
- createdAt (Field6) — datetime
- updatedAt (Field7) — datetime
유저 (account_user)
- id (Key) — bit int — 기본 키 — NOT NULL
- name (Field) — varchar(20)
- createdAt (Field2) — datetime
- updatedAt (Field3) — datetime