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