블록체인 프로젝트

테이블 (7)

answers

  • answer — CHAR(16) — NOT NULL
  • sub — VARCHAR(255) — 외래 키 → users.sub — NOT NULL
  • str — VARCHAR(20) — NOT NULL
  • answered_at — DATETIME — NOT NULL

nfts

  • tokenID — VARCHAR(78) — 기본 키 — NOT NULL
  • address — VARCHAR(42) — 기본 키 — NOT NULL

reward_claims

  • id — BIGINT — 기본 키 — NOT NULL
  • answer_str — VARCHAR(20) — NOT NULL
  • sub — VARCHAR(255) — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • tx_hash — VARCHAR(80)
  • created_at — TIMESTAMP — NOT NULL
  • completed_at — TIMESTAMP

trades

  • seq — BIGINT — 기본 키 — NOT NULL
  • tokenID — VARCHAR(78) — NOT NULL
  • address — VARCHAR(42) — NOT NULL
  • price — DECIMAL(38,18) — NOT NULL
  • nft_owner — VARCHAR(255) — 외래 키 → users.sub — NOT NULL
  • receiver — VARCHAR(255)
  • completed_at — DATETIME

users

  • sub — VARCHAR(255) — 기본 키 — NOT NULL
  • id — VARCHAR(30) — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • created_at — DATETIME — NOT NULL

wallets1

  • sub — VARCHAR(255) — 외래 키 → users.sub — NOT NULL
  • address — VARCHAR(42) — NOT NULL
  • encrypted_key — TEXT — NOT NULL

wallets2

  • sub — VARCHAR(255) — 외래 키 → users.sub — NOT NULL
  • encrypted_key — TEXT — NOT NULL
  • pw — VARCHAR(255) — NOT NULL