FintechZerobase
Tables (3)
ACCOUNT (계좌)
- number (계좌번호) — VARCHAR(14) — Primary key — NOT NULL
- user_id (예금주) — VARCHAR(100) — Foreign key → USER.id — NOT NULL
- balance (잔고) — BIGINT
- created_at (생성일) — DATETIME
HISTORY (송금이력)
- id (아이디) — BIGINT — Primary key — NOT NULL
- account_number (계좌번호) — VARCHAR(14) — Foreign key → ACCOUNT.number — NOT NULL
- amount (금액) — BIGINT
- remittance_at (송금날짜) — DATETIME
USER (유저)
- id (아이디) — VARCHAR(100) — Primary key — NOT NULL
- pw (비밀번호) — VARCHAR(100)
- name (이름) — VARCHAR(100)
- rrn (주민번호) — VARCHAR(100)
- registed_at (가입일) — DATETIME
- modified_at (수정일) — DATETIME