aptos-tvl&yield

Tables (12)

delegation_2 (CopyOfUntitled6)

  • _id (Key) — Primary key — NOT NULL
  • address (Field)
  • status (Field2)
  • delegation_amount (Field3)
  • commission (Field4)
  • delegators (Field5)
  • reward_earned (Field6)
  • operation_address (Field7)

delegation_node (Untitled6)

  • _id (address) (Key) — Primary key — NOT NULL
  • status (Field2)
  • delegation_amount (Field3)
  • commission (Field4)
  • delegators (Field5)
  • reward_earned (Field6)
  • operation_address (Field7)

node (Untitled5)

  • _id (address) (Key) — Primary key — NOT NULL
  • voting_power (Field2)
  • reward_perf (Field3)
  • last_epoch_perf (Field4)
  • operation_address (Field5)
  • location_desc (Field6)
  • latitude (Field7)
  • longitude (Field8)
  • country_id (Key2) — Foreign key → validation_country._id — NOT NULL
  • city_id (Key3) — Foreign key → validation_city._id — NOT NULL

node_2 (CopyOfUntitled5)

  • _id (Key) — Primary key — NOT NULL
  • address (Field)
  • voting_power (Field2)
  • reward_perf (Field3)
  • last_epoch_perf (Field4)
  • operation_address (Field5)
  • location_desc (Field6)
  • latitude (Field7)
  • longitude (Field8)
  • country_name (Field9)
  • city_name (Field10)
  • is_new (Field11)

pool (Untitled4)

  • _id (Key) — Primary key — NOT NULL
  • portal_asset_id (Key3) — Primary key — NOT NULL
  • protocol_id (Key2) — Foreign key → project._id — NOT NULL
  • pool_name (Field)
  • tvl (Field2)
  • apy (Field3)
  • apy_base (Field4)
  • apy_reward (Field5)
  • apy_base_7d (Field6)
  • apy_mean_30d (Field7)

pool (CopyOfUntitled4)

  • _id (Key) — Primary key — NOT NULL
  • project_id (Key4) — Foreign key → project._id — NOT NULL
  • portal_project_id (Key22) — Foreign key → project.portal_id — NOT NULL
  • symbol (Field)
  • tvl (Field8)
  • apy (Field3)
  • apy_base (Field4)
  • apy_reward (Field5)
  • apy_base_7d (Field6)
  • apy_mean_30d (Field7)
  • apy_chart_30d (Field2)

project (Untitled2)

  • _id (Key) — Primary key — NOT NULL
  • name (Field)
  • slug (Field4)
  • url (Field2)
  • category (Field3)
  • tvl (Field5)
  • tvl_change_1d (Field6)
  • tvl_change_7d (Field7)

project (CopyOfUntitled2)

  • _id (Key) — Primary key — NOT NULL
  • portal_id (Key2) — Primary key — NOT NULL
  • name (Field)
  • slug (Field4)
  • website_url (Field10)
  • logo_url (Field2)
  • category (Field3)
  • tvl (Field5)
  • tvl_change_1d (Field6)
  • tvl_change_7d (Field7)
  • tvl_change_30d (Field8)
  • marketcap (Field9)

tvl_historical_day (Untitled)

  • _id (Key) — Primary key — NOT NULL
  • tvl (Field)
  • apy (Field3)
  • apy_base (Field4)
  • apy_reward (Field5)
  • timestamp (Field2)
  • pool_id (Key2) — Foreign key → pool._id — NOT NULL
  • Key3 — Foreign key → pool.portal_asset_id — NOT NULL

tvl_realtime_hour (Untitled3)

  • _id (Key) — Primary key — NOT NULL
  • tvl (Field)
  • apy (Field2)
  • apy_base (Field4)
  • apy_reward (Field5)
  • timestamp (Field3)
  • pool_id (Key2) — Foreign key → pool._id — NOT NULL
  • Key3 — Foreign key → pool.portal_asset_id — NOT NULL

validation_city (Untitled8)

  • _id (Key) — Primary key — NOT NULL
  • name (Field)
  • node_count (Field2)
  • country_id (Key2) — Foreign key → validation_country._id — NOT NULL

validation_country (Untitled7)

  • _id (Key) — Primary key — NOT NULL
  • name (Field)
  • node_count (Field2)