sdada

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