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