Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

TAGEE / TAGEE_ODS / ODS_ETHEREUM_BOLCK_INFO_DA字段命名存在问题 #7

Open
zhangmaosen opened this issue Sep 5, 2022 · 1 comment
Assignees

Comments

@zhangmaosen
Copy link
Contributor

如截图,Number这个字段命名和字段类型,都不太妥当。建议改字段名,字段类型选择更适合做序号的类型
image

@zexianghuang
Copy link
Contributor

字段命名-已经修改,改成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 '交易费用'
);

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants