8percent

테이블 (5)

Copy Of 입금 (withdraws)

  • (id) — bigint — 기본 키 — NOT NULL
  • Field2 (digest) — char — NOT NULL
  • Field (transaction_amount) — positiveint — NOT NULL
  • Field (created_at) — datetime — NOT NULL

Untitled (accounts)

  • Key (id) — bigint — 기본 키 — NOT NULL
  • Field (account_number) — int — NOT NULL
  • Field (balance) — positivint — NOT NULL
  • (user_id) — bigint — 외래 키 → 유저.id — NOT NULL

Untitled (transactions)

  • Key (account_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • (deposit_id) — bigint — 외래 키 → 입금.id — NOT NULL
  • (withdraw_id) — bigint — 외래 키 → Copy Of 입금.id — NOT NULL

유저 (users)

  • (id) — bigint — 기본 키 — NOT NULL
  • (name) — char — NOT NULL
  • (password) — char — NOT NULL

입금 (deposits)

  • (id) — bigint — 기본 키 — NOT NULL
  • Field (digest) — char — NOT NULL
  • Field (transaction_amount) — positiveint — NOT NULL
  • Field2 (created_at) — datetime — NOT NULL