블록체인 프로젝트
테이블 (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