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