mars icon indicating copy to clipboard operation
mars copied to clipboard

feat: add token table

Open BohuTANG opened this issue 2 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