DAO

Tables (6)

CMC (cmc_web_daily)

  • varname (description) — datatype — Primary key — NOT NULL
  • ucid (cmc unqiue id) — INT
  • name (token name)
  • symbol (token ticker)
  • slug (Field)
  • cmcRank (daily ranking)
  • circulatingSupply (Field2)
  • totalSupply (Field3)
  • lastUpdated (updated datetime)
  • platform.ucid (network, chain types)
  • platform.token_address (Field4)
  • numMarketPairs (Field5) — INT
  • price_USD (Field6)
  • price_BTC (Field7)
  • volume24h_USD (Field8)
  • volume24h_BTC (Field9)
  • marketCap_USD (Field10)
  • marketCap_BTC (Field11)

DefiLlama (tvls)

  • Key — Primary key — NOT NULL
  • Field
  • Field2

Rule of ERD (table_name)

  • varname (description) — datatype — Primary key — NOT NULL
  • id (blablabla) — INT

Snapshot (spaces)

  • id — Primary key — NOT NULL
  • Field
  • Field2

Snapshot (proposals)

  • id — VARCHAR — Primary key — NOT NULL
  • space_id (id2) — Foreign key → Snapshot.id — NOT NULL
  • Field2
  • Field

Snapshot (votes)

  • id — VARCHAR — Primary key — NOT NULL
  • proposal_id (id3) — VARCHAR — Foreign key → Snapshot.id — NOT NULL
  • space_id (id22) — VARCHAR — Foreign key → Snapshot.space_id — NOT NULL
  • Field
  • Field2