blocks_database_overview

Tables (17)

Assets

  • id (Asset ID) — number — Primary key — NOT NULL
  • Field (Name) — string
  • totaltoken — number
  • tokenUnit (token Unit) — string
  • totalSold (sold total) — number
  • currentSupply (unlocked token) — string
  • prority — number
  • isDeleted (deleted) — boolen
  • totalInvestors (TotalInvestor) — number
  • type (AssetsType) — enum('property','equitity')
  • tokenPrice (Price) — number
  • Field

BankTransaction

  • id — number — Primary key — NOT NULL
  • name — string
  • token — number
  • unit — number
  • amount — number
  • Field

BlockchainWallet

  • id — number — Primary key — NOT NULL
  • userID — number
  • networkID — number
  • walletAddress — string
  • privateKey — string
  • type — enum('EVM')
  • Field

Campaign

  • id — number — Primary key — NOT NULL
  • name — string
  • description — string
  • startDate (start_date) — DateTime
  • endDate (end_date) — DateTime
  • reward — Aray<Objects>
  • code — string
  • Field

ColorTokens

  • id — number — Primary key — NOT NULL
  • assetsId (assetId) — number
  • sold — number
  • unsold — number
  • booked — number
  • equity — number
  • debt — number

ProprtyRound (PropertyRound)

  • id — number — Primary key — NOT NULL
  • developmentalpropertyID — number
  • assetsID (AssetsID) — number
  • status — enum('pending','active','closed')
  • roundName — string
  • startDate (StartDate) — DateTime
  • endDate (EndDate) — DateTime
  • Area — number
  • price (Price) — number
  • description (Description) — string
  • Field

UserCampaign

  • id — number — Primary key — NOT NULL
  • userId (userID) — number
  • campaignID — number
  • joinedAt — DateTime
  • Field

assetOwnership

  • id — number — Primary key — NOT NULL
  • assetID — number
  • userID — number
  • balance — number
  • createdAt — DateTime
  • UpdatedAt — DateTime
  • Field

blockchainNetwork

  • id — number — Primary key — NOT NULL
  • name — string
  • rpc — string
  • type — enum('EVM')
  • isActive — boolen
  • Field

develpomentalProperty (developmentalProperty)

  • id — number — Primary key — NOT NULL
  • assetsID — number
  • propertyAssetID — number
  • Field

matureProperty

  • id — number — Primary key — NOT NULL
  • assetID (assetsID) — number
  • estROI — number
  • Field

porpertyDocument (propertyDocument)

  • id — number — Primary key — NOT NULL
  • assetsID — number
  • propertyAssetID (ID) — number
  • documentURL (document URL) — string
  • isDeleted (deleted Bit) — boolen
  • createdBy — number
  • createdAt — DateTime
  • Field

propertyasset

  • id (property ID) — number — Primary key — NOT NULL
  • assetsID (Assets ID) — number
  • name — string
  • description — string
  • type — enum('developmental','mature')
  • unit — enum('sq.ft','sq.m')
  • location — Array<Object>
  • completetionDate (Date) — DateTime
  • createdBy — number
  • createdAt — DateTime
  • IsDeleted (isDeleted) — boolen
  • amenities — Array<Object>

propertynft

  • id — number — Primary key — NOT NULL
  • name — number
  • assetsID — number
  • propertyID — number
  • description — string
  • floorNumber — number
  • netArea — number
  • spaceType — enum('ONE_BED_APARTMENT','TWO_BED_APARTMENT','etc");
  • unitAmenities — Array<Object>
  • virtualTourUrl — string
  • premiumCategory — enum('PREMIUM','DELUXE','ELITE','ELITE_PLUS','STANDARD')
  • grossArea — number
  • unitUsageType — enum('RESIDENTIAL','COMMERCIAL','MANAGERIAL')
  • userInvestmentPlanID — number
  • Field

tradeactivity

  • id — number — Primary key — NOT NULL
  • sellerID (To User ID) — number
  • BuyerID (From User ID) — number
  • roundID — number
  • assetID — number
  • blockchainReference — string
  • totalToken — number
  • totalPrice — number
  • paymentMode — enum('online','cash')
  • paymentDate — DateTime
  • status — enum('pending','verified','approved','locked')
  • createdAt — DateTime
  • updatedAt — DateTime
  • medium — enum('P2P','Marketplace','etc')
  • isDemo — boolen
  • discount — number
  • voucherID — number
  • Field

userBank

  • id — number — Primary key — NOT NULL
  • userID — number
  • Field

users (Users)

  • id (userID) — number — Primary key — NOT NULL
  • legalName (name) — string
  • cnic — string
  • type (userType) — enum('investor','affiliate')
  • phoneNumber (PhoneNo) — string
  • password — hash
  • createAt (user Created At) — date
  • createdBy (created By) — enum('userID','AdminID')
  • isDemo (Demo account) — boolen
  • isSuspended (Suspend Account) — boolen
  • ntn (ntn no) — string
  • gender — enum('male','female','other')
  • profilePicURL (profile pic) — string
  • pushNotification (Notification) — boolen
  • smsNotification (SMS notification) — boolen
  • nickName (nick name for marketplace) — string
  • referralCode (Referral Code) — string
  • referredBy (Referred By user) — string
  • isBlocksMember (Team Member) — boolen
  • investedAmount (Total Investment by user) — number
  • Balance (Total Balance in Tokens) — number
  • Field