Crowdfund

39,059 rows

This data as json, CSV (advanced)

Suggested facets: crowdfundType, opts_market, opts_splitBps, opts_initialDelegate, opts_gateKeeper, governanceOpts_feeBps, governanceOpts_feeRecipient, protocolVersion, ethCrowdfund_exchangeRateBps, networkId, ethCrowdfund_exchangeRate, governanceOpts_hosts (array)

Next page

CREATE TABLE [Crowdfund] (
   [crowdfundAddress] TEXT,
   [crowdfundType] TEXT,
   [blockNumber] INTEGER,
   [transactionHash] TEXT,
   [opts_name] TEXT,
   [opts_symbol] TEXT,
   [opts_auctionId] TEXT,
   [opts_market] TEXT,
   [opts_nftContract] TEXT,
   [opts_nftTokenId] TEXT,
   [opts_duration] FLOAT,
   [opts_maximumBid] TEXT,
   [opts_splitRecipient] TEXT,
   [opts_splitBps] INTEGER,
   [opts_initialContributor] TEXT,
   [opts_initialDelegate] TEXT,
   [opts_gateKeeper] TEXT,
   [opts_gateKeeperId] TEXT,
   [opts_maximumPrice] FLOAT,
   [opts_onlyHostCanBuy] INTEGER,
   [opts_onlyHostCanBid] INTEGER,
   [governanceOpts_hosts] TEXT,
   [governanceOpts_voteDuration] TEXT,
   [governanceOpts_executionDelay] INTEGER,
   [governanceOpts_passThresholdBps] TEXT,
   [governanceOpts_feeBps] TEXT,
   [governanceOpts_feeRecipient] TEXT,
   [expiry] INTEGER,
   [protocolVersion] TEXT,
   [creator] TEXT,
   [ethCrowdfund_exchangeRateBps] INTEGER,
   [ethCrowdfund_fundingSplitBps] INTEGER,
   [ethCrowdfund_fundingSplitRecipient] TEXT,
   [ethCrowdfund_maxContribution] FLOAT,
   [ethCrowdfund_maxTotalContributions] FLOAT,
   [ethCrowdfund_minContribution] FLOAT,
   [ethCrowdfund_minTotalContributions] FLOAT,
   [ethCrowdfund_party] TEXT,
   [networkId] INTEGER,
   [ethCrowdfund_exchangeRate] TEXT,
   [tokenOpts_name] TEXT,
   [tokenOpts_numTokensForDistribution] TEXT,
   [tokenOpts_numTokensForLP] TEXT,
   [tokenOpts_numTokensForRecipient] TEXT,
   [tokenOpts_recipient] TEXT,
   [tokenOpts_symbol] TEXT,
   [tokenOpts_totalSupply] TEXT,
   [tokenOpts_lpFeeRecipient] TEXT
);
CREATE INDEX [idx_Crowdfund_networkId]
    ON [Crowdfund] ([networkId]);
CREATE INDEX [idx_Crowdfund_crowdfundAddress]
    ON [Crowdfund] ([crowdfundAddress]);
CREATE INDEX [idx_Crowdfund_creator]
    ON [Crowdfund] ([creator]);
CREATE INDEX [idx_Crowdfund_crowdfundType]
    ON [Crowdfund] ([crowdfundType]);
CREATE INDEX [idx_Crowdfund_networkId_crowdfundAddress]
    ON [Crowdfund] ([networkId], [crowdfundAddress]);