Blox Wallet

Tables (11)

Admin (admin)

  • id — number — Primary key — NOT NULL
  • email — string
  • password — string
  • role — enum[SuperAdmin,Admin)
  • isActive — boolean
  • isDeleted — boolean
  • Field

Asset (asset)

  • id — number — Primary key — NOT NULL
  • adminId — number — Foreign key → Admin.id — NOT NULL
  • name — string
  • type — string
  • totalSupply — number
  • tokenPrice — number
  • tokenUnit — number
  • completionDate — number
  • estimatedRoi (estimatedROI) — number
  • description — string
  • facilities — Array<Object>
  • documents — Array<Object>
  • contactPhoneNumbers — Array<Object>
  • totalInvestors — number
  • totalSold — number
  • isActive — boolean
  • isDeleted — boolean
  • roiDescription — string
  • rent — string
  • priority — number

Crypto Network

  • id — number — Primary key — NOT NULL
  • name — string
  • rpc — string
  • type — enum("EVM")
  • isActive — boolean
  • isBoolean — boolean
  • Field

Crypto Wallet

  • id — number — Primary key — NOT NULL
  • userId — number — Foreign key → User.id — NOT NULL
  • networkId — number — Foreign key → Crypto Network.id — NOT NULL
  • walletAddress — string
  • privateKey — string
  • type — enum("EVM")

Referral Reward

  • id — number — Primary key — NOT NULL
  • userId — number — Foreign key → User.id — NOT NULL
  • childId — number
  • referralAmount — number
  • referralInfo — enum("JoinedPlatform")
  • Field

ReferralRewardInfo (ReferredRewardInfo)

  • id — number — Primary key — NOT NULL
  • adminId — number — Foreign key → Admin.id — NOT NULL
  • rewardName — string
  • rewardAmount — numb
  • Field

Transaction

  • id — number — Primary key — NOT NULL
  • walletId — number — Foreign key → Wallet.id — NOT NULL
  • userId — number — Foreign key → Wallet.userId — NOT NULL
  • assetId — number — Foreign key → Asset.id — NOT NULL
  • type — enum(buy,transfer)
  • amount — number
  • currency — string
  • assetAmount — number
  • assetPrice — number
  • toUserId — number
  • toWalletId — number
  • status — enum(Pending, Failed, Success)
  • isDemo — boolean
  • internalStatus — enum(Pending, Failed, Success)
  • transactionMedium — enum(Cash, Bank Transfer)
  • bankTransactionId — string
  • Field

User (user)

  • id — number — Primary key — NOT NULL
  • phoneNumber — string
  • password — string
  • referralCode — string
  • cnic — string
  • name — string
  • isDeleted — boolean
  • isActive — boolean
  • totalReferrals — number
  • referralReward — number
  • profileImage — string
  • twoFactorAuth — boolean
  • kycStatus (Field)
  • referredBy — number
  • type — enum()
  • Field2

Wallet (wallet)

  • id — number — Primary key — NOT NULL
  • userId — number — Foreign key → User.id — NOT NULL
  • balance — number
  • accountNumber — string
  • bank — string
  • totalDeposit — string
  • Field

assetOwnership

  • id — number — Primary key — NOT NULL
  • assetId — number — Foreign key → Asset.id — NOT NULL
  • userId — number — Foreign key → User.id — NOT NULL
  • totalUnits — number
  • investedAmount — number

bankTransaction

  • id — number — Primary key — NOT NULL
  • walletId — number — Foreign key → Wallet.id — NOT NULL
  • userId — number — Foreign key → Wallet.userId — NOT NULL
  • type — enum(deposit,withdraw)
  • amount — number
  • currency — string
  • status — enum(Pending, Failed, Success)
  • isDemo — boolean