ubiquity / ubiquibot

Putting the 'A' in 'DAO'
https://github.com/marketplace/ubiquibot
MIT License
17 stars 59 forks source link

Permits Table Schema II #819

Open 0x4007 opened 11 months ago

0x4007 commented 11 months ago

Another idea I might add to a new scope, but we can save so much on memory if we have:

  1. a foreign key to recognized partner wallet address (partner_wallet_id)
  2. recognized token addresses (token_id) and a new tokens table.
  3. bounty hunter address should be a foreign key also (wallet_id).
Screenshot 2023-09-24 at 17 43 47

Partners Table

id, created, updated, wallet, repository_id

Tokens Table

id, created, updated, network, address

Originally posted by @pavlovcik in https://github.com/ubiquity/ubiquibot/issues/811#issuecomment-1732522341