Comments (1)
字段命名-已经修改,改成blockNumber .但是 字段类型为 snowflake 自动转化 int 转为为:number。创建语句为:
Create table ods_ethereum_block_info_da(
blockNumber int COMMENT '区块号。当这个区块处于pending将会返回null。',
blockHash string COMMENT '区块的哈希串。当这个区块处于pending将会返回null。',
parentHash string COMMENT '字符串,32字节的父区块的哈希值。',
nonce string COMMENT '字符串,8字节。POW生成的哈希。当这个区块处于pending将会返回null。',
sha3Uncles string COMMENT '字符串,32字节。叔区块的哈希值。',
logsBloom string COMMENT '字符串,区块日志的布隆过滤器9。当这个区块处于pending将会返回null。',
transactionsRoot string COMMENT 'String 字符串,32字节,区块的交易前缀树的根。',
stateRoot string COMMENT '字符串,32字节。区块的最终状态前缀树的根。',
receiptsRoot string COMMENT '字符串,32字节。区块的最终状态前缀树的根。',
miner string COMMENT '字符串,20字节。这个区块获得奖励的矿工。',
difficulty bigint COMMENT 'BigNumber类型。当前块的难度,整数。',
totalDifficulty bigint COMMENT 'BigNumber类型。区块链到当前块的总难度,整数。',
blockSize int COMMENT 'Number。当前这个块的字节大小。',
extraData string COMMENT '字符串。当前块的extra data字段。',
gasLimit int COMMENT 'Number,当前区块允许使用的最大gas。',
gasUsed bigint COMMENT '当前区块累计使用的总的gas。',
blocktimestamp bigint COMMENT ' Number。区块打包时的unix时间戳。',
transactionCount bigint COMMENT '交易数量',
baseFeePerGas bigint COMMENT '交易费用'
);
from tagee.
Related Issues (14)
- 同步以太坊数据 HOT 3
- 以太坊DWD建表工作 HOT 1
- glassnode指标计算
- 监控配额智能合约开发
- 设计web3项目基本面数据主题 HOT 1
- 计算指标Total Transfer Volume to Exchanges
- 需要对交易所的钱包地址进行标注 HOT 2
- ods表的质量问题 HOT 1
- ethereum-etl 遇到的坑 HOT 2
- Web3项目基本面指标定义
- uniswap流动性套利分析的数据表设计 HOT 6
- 元数据平台调研 HOT 1
- 私有大数据平台设计的问题汇总 HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from tagee.