新版
Tables (9)
BlockchainTransactions
- TransactionID — INT
- UserID — INT
- TransactionHash — VARCHAR(255) — NOT NULL
- Amount — DECIMAL(18, 8)
- Currency — VARCHAR(10)
- TransactionDate — DATETIME — NOT NULL
- Type — ENUM('DEPOSIT', 'WITHDRAWAL', 'PRIZE', 'FEE') — NOT NULL
- Status — ENUM('PENDING', 'CONFIRMED', 'FAILED') — NOT NULL
Games
- GameID — INT
- GameName — VARCHAR(255) — NOT NULL
- Developer — VARCHAR(255)
- ReleaseDate — DATE
- Platform — ENUM('PC', 'MOBILE', 'CONSOLE') — NOT NULL
- Genre — VARCHAR(50)
Leaderboards
- LeaderboardID — INT
- UserID — INT
- TournamentID — INT
- Rank — INT — NOT NULL
- Score — INT
Matches
- MatchID — INT
- TournamentID — INT
- WinnerID — INT
- LoserID — INT
- MatchDate — DATETIME — NOT NULL
NFTInteractions
- NFTID — INT
- OwnerID — INT
- Name — VARCHAR(255) — NOT NULL
- Description — TEXT
- CreationDate — DATETIME — NOT NULL
- MetadataURL — VARCHAR(255)
- SalePrice — DECIMAL(18, 8)
- IsForSale — BOOLEAN
- ContractID — INT
Participation
- ParticipationID — INT
- UserID — INT
- TournamentID — INT
- RegistrationDate — DATETIME — NOT NULL
- HasPaidEntryFee — BOOLEAN
- Score — INT
- RankAchieved — INT
SmartContracts
- ContractID — INT
- Address — VARCHAR(255) — NOT NULL
- Name — VARCHAR(255)
- ABI — TEXT
Tournaments
- TournamentID — INT
- TournamentName — VARCHAR(255) — NOT NULL
- StartDate — DATETIME — NOT NULL
- EndDate — DATETIME
- EntryFee — DECIMAL(10, 2)
- PrizePool — DECIMAL(10, 2)
- Status — ENUM('OPEN', 'ONGOING', 'COMPLETED', 'CANCELLED') — NOT NULL
- GameID — INT
Users
- UserID — INT
- Username — VARCHAR(255) — NOT NULL
- Email — VARCHAR(255) — NOT NULL
- WalletAddress — VARCHAR(255)
- PasswordHash — VARBINARY(255) — NOT NULL
- DateRegistered — DATETIME — NOT NULL
- LastLogin — DATETIME
- ProfilePictureURL — VARCHAR(255)
- Bio — TEXT
- Country — VARCHAR(50)
- TotalWins — INT
- TotalLosses — INT
- Reputation — INT