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