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