PollTerraServer

Tables (13)

Copy Of Copy Of Untitled (poll_participation)

  • Key (id) — int — Primary key — NOT NULL
  • Field (participated_at) — datetime — NOT NULL
  • Field (side) — bigint(20) — NOT NULL
  • Field (amount) — bigint(20) — prediction => should not be null opinion => should be null
  • address (poll_address) — char(44) — Foreign key → poll.address — NOT NULL
  • address (wallet_address) — char(44) — Foreign key → wallet.address — NOT NULL

Copy Of Copy Of Untitled2 (comment_creation)

  • Key (comment_id) — int — Foreign key → Untitled.Key — NOT NULL
  • address (wallet_address) — char(44) — Foreign key → wallet.address — NOT NULL

Copy Of Untitled (poll_like)

  • address (wallet_address) — char(44) — Foreign key → wallet.address — NOT NULL
  • address (poll_address) — char(44) — Foreign key → poll.address — NOT NULL

Copy Of Untitled2 (comment_like)

  • address (wallet_address) — char(44) — Foreign key → wallet.address — NOT NULL
  • Key (comment_id) — int — Foreign key → Untitled.Key — NOT NULL

Copy Of Untitled3 (reply_creation)

  • Key (reply_id) — int — Foreign key → Untitled.Key — NOT NULL
  • address (wallet_address) — char(44) — Foreign key → wallet.address — NOT NULL

Untitled (poll_creation)

  • address (poll_address) — char(44) — Foreign key → poll.address — NOT NULL
  • address (wallet_address) — char(44) — Foreign key → wallet.address — NOT NULL

Untitled (comment)

  • Key (id) — int — Primary key — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field3 (content) — varchar(255) — NOT NULL
  • Key (participation_id) — int — Foreign key → Copy Of Copy Of Untitled.Key — NOT NULL

Untitled (reply)

  • Key (id) — int — Primary key — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Field3 (content) — varchar(255) — NOT NULL
  • Key (participation_id) — int — Foreign key → Copy Of Copy Of Untitled.Key — NOT NULL

Untitled (comment_reply)

  • Key (reply_id) — int — Foreign key → Untitled.Key — NOT NULL
  • Key (comment_id) — int — Foreign key → Untitled.Key — NOT NULL

Untitled (reply_like)

  • address (wallet_address) — char(44) — Foreign key → wallet.address — NOT NULL
  • Key (reply_id) — int — Foreign key → Untitled.Key — NOT NULL

poll

  • address — char(44) — Primary key — NOT NULL
  • joined_at (created_at) — datetime — NOT NULL
  • name (poll_type) — enum["prediction", "opinion"] — NOT NULL
  • Field (description) — varchar(255) — NOT NULL

reolution (resolution)

  • address — char(44) — Foreign key → poll.address — NOT NULL
  • joined_at (topic) — varchar(64) — NOT NULL
  • name (category) — varchar(64) — NOT NULL
  • Field (action) — varchar(32) — NOT NULL
  • Field (estimate) — bigint(32) — NOT NULL

wallet

  • address — char(44) — Primary key — NOT NULL
  • joined_at (created_at) — datetime — NOT NULL
  • name — varchar(20)