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)