POP Test

Tables (25)

badge_history

  • badge_hist_id — bigint — Primary key — NOT NULL
  • member_id — bigint — NOT NULL
  • event_code — varchar(10) — NOT NULL
  • event_state — varchar(10) — NOT NULL
  • event_desc — varchar(255) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • badge_id — bigint

badge_info

  • badge_id — bigint — Primary key — NOT NULL
  • app_id — bigint — NOT NULL
  • badge_name — varchar(50) — NOT NULL
  • badge_desc — varchar(255)
  • badge_version — varchar(20)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL
  • badge_category — varchar(30)
  • tier_id — bigint
  • badge_gov_point — int
  • badge_achieve_point — int
  • badge_image_url — text
  • badge_metadata_url — text
  • rate_limit_seconds — int

badge_mint_history

  • badge_mint_hist_id — bigint — Primary key — NOT NULL
  • member_id — bigint — NOT NULL
  • tx_hash — varchar(66)
  • tx_status — tinyint
  • badge_id — bigint — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

badge_mint_job

  • badge_mint_job_id — bigint — Primary key — NOT NULL
  • badge_id — bigint — NOT NULL
  • member_id — bigint — NOT NULL
  • to_wallet_address — varchar(42) — NOT NULL
  • job_status — varchar(10) — NOT NULL
  • tx_hash — varchar(66)
  • reason — varchar(255)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

badge_of_member

  • badge_of_member_id — bigint — Primary key — NOT NULL
  • member_id — bigint — NOT NULL
  • ach_rate — tinyint
  • badge_id — bigint
  • state — varchar(20)
  • passed_rule_count — smallint
  • total_rule_count — smallint
  • validation_requested_at — datetime
  • validation_completed_at — datetime
  • minted_at — datetime
  • tx_hash — varchar(66)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

badge_requirement

  • badge_requirement_id — bigint — Primary key — NOT NULL
  • badge_id — bigint — NOT NULL
  • pop_rule_id — bigint — Foreign key → pop_rule.pop_rule_id — NOT NULL
  • display_order — tinyint
  • weight — tinyint
  • created_at — datetime — NOT NULL

batch_validation_request

  • member_id — int — Primary key — NOT NULL
  • request_status — tinyint — 1: requested\\n2: in progress\\n3: completed
  • last_eligibility_checked_at_utc — datetime
  • created_at — datetime
  • updated_at — datetime

contract

  • contract_address — varchar(42) — Primary key — NOT NULL
  • abi_file_url — varchar(200)
  • description — varchar(100)
  • app_id — varchar(45)
  • created_at — datetime
  • updated_at — datetime

contract_tag

  • tag — varchar(50) — Primary key — NOT NULL
  • contract_address — varchar(42) — Foreign key → contract.contract_address — NOT NULL
  • created_at — datetime
  • updated_at — datetime

crew3_claimed_quest

  • crew3_claimed_quest_id — bigint — Primary key — NOT NULL
  • event_id — varchar(45)
  • quest_id — varchar(45)
  • user_crew3_id — varchar(45)
  • user_discord_id — varchar(45)
  • event_created_at — datetime
  • event_updated_at — datetime
  • created_at — datetime

crew3_user_address

  • crew3_user_address_id — bigint — Primary key — NOT NULL
  • wallet_address — varchar(42)
  • chain_name — varchar(30)
  • user_crew3_id — varchar(45)
  • created_at — datetime

distributed_lock

  • cluster_id — int — Primary key — NOT NULL
  • cluster_desc — varchar(45)
  • lock_acquisition_time — datetime
  • lock_holder_signature — varchar(100)
  • created_at — datetime
  • updated_at — datetime

event_collector_contract

  • contract_id — int — Primary key — NOT NULL
  • contract_address — varchar(42) — NOT NULL
  • abi_file_url — varchar(150)
  • attributes — varchar(100)
  • crawl_start_block — int — NOT NULL
  • last_processed_block — int
  • reset_lpb_to — int
  • paused — tinyint(1)
  • priority — int
  • created_at — datetime
  • updated_at — datetime

event_collector_contract_event

  • block_number — int — Primary key — NOT NULL
  • log_index — int — Primary key — NOT NULL
  • tx_hash — varchar(66)
  • contract_address — varchar(42)
  • event_name — varchar(150)
  • event_signature — varchar(150)
  • parsed_arguments — json
  • address_arg_1 — varchar(42)
  • address_arg_2 — varchar(42)
  • number_arg_1 — varchar(78)
  • created_at — datetime

event_collector_contract_event_arguments

  • block_number — int — Primary key — NOT NULL
  • log_index — smallint — Primary key — NOT NULL
  • argument_index — smallint — Primary key — NOT NULL
  • tx_hash — varchar(66)
  • contract_address — varchar(42)
  • topic_0 — varchar(66)
  • argument_value — varchar(66)
  • created_at — datetime

fee_info

  • fee_id — bigint — Primary key — NOT NULL
  • fee_price — bigint — NOT NULL
  • fee_address — varchar(50) — NOT NULL
  • fee_desc — varchar(100) — NOT NULL
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

naoda_sbt_owner

  • contract_address — varchar(42) — Primary key — NOT NULL
  • eoa_address — varchar(42) — Primary key — NOT NULL
  • badge_id — varchar(80) — Primary key — NOT NULL
  • owns_sbt — tinyint(1)
  • last_update_signature — bigint
  • created_at — datetime
  • updated_at — datetime

naoda_sbt_transfer

  • badge_transfer_id — bigint — Primary key — NOT NULL
  • block_number — bigint
  • log_index — smallint
  • tx_hash — varchar(66)
  • contract_address — varchar(42)
  • badge_id — varchar(80)
  • sender_address — varchar(42)
  • receiver_address — varchar(42)
  • created_at — datetime

pop_rule

  • pop_rule_id — bigint — Primary key — NOT NULL
  • pop_rule_code — varchar(50) — NOT NULL
  • main_desc — varchar(150) — NOT NULL
  • sub_desc — varchar(150)
  • max_progress — int
  • skip_validation — tinyint
  • action_hint — varchar(40)
  • action_hyperlink — varchar(150)
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

pop_rule_eligibility

  • pop_rule_eligibility_id — bigint — Primary key — NOT NULL
  • member_id — bigint — NOT NULL
  • pop_rule_id — bigint — Foreign key → pop_rule.pop_rule_id — NOT NULL
  • achieved_progress — int
  • progress_percentage — tinyint
  • created_at — timestamp(6) — NOT NULL

scheduler_info

  • scheduler_id — int — Primary key — NOT NULL
  • last_processed_element_id — bigint
  • last_processed_element_datetime — datetime
  • created_at — datetime
  • updated_at — datetime

tier_info

  • tier_id — bigint — Primary key — NOT NULL
  • tier_name — varchar(50) — NOT NULL
  • tier_point — int
  • tier_priority — tinyint
  • tier_fee — int
  • created_at — datetime — NOT NULL
  • updated_at — datetime — NOT NULL

twitter_webhook_error

  • error_id — int — Primary key — NOT NULL
  • webhook_raw_data — json
  • created_at — datetime

twitter_webhook_event

  • for_user_id — varchar(20) — Primary key — NOT NULL
  • event_id — varchar(40) — Primary key — NOT NULL
  • twitter_user_id — varchar(40)
  • event_category — varchar(40)
  • event_timestamp — bigint
  • auxiliary_category — varchar(40)
  • created_at — datetime

typeform_submission

  • typeform_submission_id — int — Primary key — NOT NULL
  • form_id — varchar(45) — NOT NULL
  • user_email — varchar(150)
  • score — int — NOT NULL
  • landed_at — datetime
  • submitted_at — datetime — NOT NULL
  • response_id — varchar(45) — NOT NULL
  • pagination_token — varchar(45) — NOT NULL
  • created_at — datetime