mars icon indicating copy to clipboard operation
mars copied to clipboard

feat: add token table

Open bohutang opened this issue 3 years ago • 4 comments

Summary

Schema:

CREATE TABLE tokens(
   address VARCHAR,
   symbol VARCHAR,
   decimals BIGINT,
   total_supply BIGINT,
   block_number BIGINT
)

bohutang avatar Nov 26 '22 08:11 bohutang

I would like to complete this feature. But I do not know anything else except the title. Can you describe more about the feature? Or just give an example schema of token table like:

CREATE TABLE token(
   address String,
   totalSupply UInt256,
   decimals UInt8
   ...
)

fenghaojiang avatar May 16 '23 08:05 fenghaojiang

Hi @fenghaojiang

Sorry for the confusing, I have update the summary, feel free to take :)

bohutang avatar May 17 '23 00:05 bohutang

Hello,

Along with symbol, normally these is a name metadata also, I suggest to add "name VARCHAR" to this table, what do you think?

lanphan avatar Jun 26 '23 10:06 lanphan

Hello,

Along with symbol, normally these is a name metadata also, I suggest to add "name VARCHAR" to this table, what do you think?

Then it would be

CREATE TABLE tokens(
   address VARCHAR,
   name VARCHAR,
   symbol VARCHAR,
   decimals BIGINT,
   total_supply BIGINT,
   block_number BIGINT
)

fenghaojiang avatar Jun 26 '23 14:06 fenghaojiang